lazycode SQL类

代码下载：http://download.csdn.net/source/2508693  

 

插入操作：

 

返回插入ID

 

返回影响行数 

 

 

 

 

protected void Button1_Click(object sender, EventArgs e) { int a = Convert.ToInt32(TextBox1.Text.Trim()); string b = TextBox2.Text; DateTime c = Convert.ToDateTime(TextBox3.Text); lazySQLDAL data = new lazySQLDAL("testTable");//testTable 你要插入的表名 data.insertfiled = "one,two,three";//要插入的字段 data.insertvlues = a + "," + b + "," + c; //要插入的参数 注意字段和插入的参数类型和数量要一致 Label1.Text="影响行数："+ data.insert(); //没带参数的返回影响行数 // Label1.Text = "插入字段ID：" + data.insert(true); //带bool参数的无论是true还是false都返回插入字段ID }

 

 

改：

 

protected void Button2_Click(object sender, EventArgs e) { int a = Convert.ToInt32(TextBox5.Text.Trim()); string b = TextBox6.Text; DateTime c = Convert.ToDateTime(TextBox8.Text); int id = Convert.ToInt32(TextBox4.Text); lazySQLDAL data = new lazySQLDAL("testTable");//testTable 你要修改的表名 data.updatefiled = "one,two,three";//要修改的字段 data.updatevalues = a + "," + b + "," + c; ;//要修改的参数 Label2.Text = "修改行数：" + data.update("id", id);//自增主键 ,要修改的id }

 

 

查：

<asp:Repeater ID="Repeater1" runat="server"> <ItemTemplate> <div> <font color="red">id:</font><%#Eval("id") %> <font color="red">one:</font><%#Eval("one") %> <font color="red">two:</font><%#Eval("two") %> <font color="red">three:</font><%#Eval("three") %></div> </ItemTemplate> </asp:Repeater>

 

 

//********************************************无参的getDataSet getDatareader 的需要 selectFiled orderby*****************************************************// //********************************************其它的只要给个true就OK如getDatareader(true)*****************************************************// } protected void Button1_Click(object sender, EventArgs e) { int a = Convert.ToInt32(TextBox1.Text.Trim()); string b = TextBox2.Text; DateTime c = Convert.ToDateTime(TextBox3.Text); lazySQLDAL data = new lazySQLDAL("testTable");//testTable 你要插入的表名 data.insertfiled = "one,two,three";//要插入的字段 data.insertvlues = a + "," + b + "," + c; //要插入的参数 注意字段和插入的参数类型和数量要一致 Label1.Text="影响行数："+ data.insert(); //没带参数的返回影响行数 // Label1.Text = "插入字段ID：" + data.insert(true); //带bool参数的无论是true还是false都返回插入字段ID }

 

 

 

删：

protected void Button3_Click(object sender, EventArgs e) { int id = Convert.ToInt32(TextBox7.Text); lazySQLDAL data = new lazySQLDAL("testTable"); //所在表 bind(); //绑写repeater Label3.Text="删除行数："+ data.delete("id",id); }

 

 

返回第一行第一列：

protected void Button4_Click(object sender, EventArgs e) { lazySQLDAL data = new lazySQLDAL("testTable"); //所在表 data.condition = "sum(id)"; Label4.Text = data.getScalar().ToString(); } protected void Button5_Click(object sender, EventArgs e) { lazySQLDAL data = new lazySQLDAL("testTable"); //所在表 data.condition = "avg(id)"; Label4.Text = data.getScalar().ToString(); } protected void Button6_Click(object sender, EventArgs e) { lazySQLDAL data = new lazySQLDAL("testTable"); //所在表 data.condition = "max(id)"; Label4.Text = data.getScalar().ToString(); } protected void Button7_Click(object sender, EventArgs e) { lazySQLDAL data = new lazySQLDAL("testTable"); //所在表 data.condition = "count(id)"; Label4.Text = data.getScalar().ToString(); }

 

检测是否存在：

protected void Button9_Click(object sender, EventArgs e) { lazySQLDAL data = new lazySQLDAL("testTable"); //所在表 string str=TextBox9.Text; data.selectFiled = "one";//字段 data.condition = "one="+str+""; //条件 Label5.Text= data.chekValue().ToString(); //返回true 或false }