linq(增,删,改)
前台页很简单,就一个GridView1,四个按钮
前台页
1<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
2
3<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4
5<html xmlns="http://www.w3.org/1999/xhtml">
6<head runat="server">
7 <title></title>
8</head>
9<body>
10 <form id="form1" runat="server">
11 <div>
12
13 <asp:GridView ID="GridView1" runat="server">
14 </asp:GridView>
15 <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="查 询" />
16 <asp:Button ID="Button2" runat="server" onclick="Button2_Click" Text="修 改" />
17 <asp:Button ID="Button3" runat="server" onclick="Button3_Click" Text="删 除" />
18 <asp:Button ID="Button4" runat="server" onclick="Button4_Click" Text="添 加" />
19 <br />
20
21 </div>
22 </form>
23</body>
24</html>
25
1<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
2
3<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4
5<html xmlns="http://www.w3.org/1999/xhtml">
6<head runat="server">
7 <title></title>
8</head>
9<body>
10 <form id="form1" runat="server">
11 <div>
12
13 <asp:GridView ID="GridView1" runat="server">
14 </asp:GridView>
15 <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="查 询" />
16 <asp:Button ID="Button2" runat="server" onclick="Button2_Click" Text="修 改" />
17 <asp:Button ID="Button3" runat="server" onclick="Button3_Click" Text="删 除" />
18 <asp:Button ID="Button4" runat="server" onclick="Button4_Click" Text="添 加" />
19 <br />
20
21 </div>
22 </form>
23</body>
24</html>
25
查询按钮事件
1testDataContext db = new testDataContext();//类型于我们SQL语句里的,创建字符串连接
2 var a = from test in db.user //类似于SQL中 select id,name from user where id=1
3 where test.id == 1
4 select new { test.id, test.name }; //如果在这里要查询所有的项,则可以直接写 test
5 this.GridView1.DataSource = a;
6 this.GridView1.DataBind();
1testDataContext db = new testDataContext();//类型于我们SQL语句里的,创建字符串连接
2 var a = from test in db.user //类似于SQL中 select id,name from user where id=1
3 where test.id == 1
4 select new { test.id, test.name }; //如果在这里要查询所有的项,则可以直接写 test
5 this.GridView1.DataSource = a;
6 this.GridView1.DataBind();
添加按钮事件
1 protected void Button4_Click(object sender, EventArgs e)
2 {
3 testDataContext con = new testDataContext();
4 user InsertUserInfo = new user {name="aa",pwd="12346" };
5 con.user.InsertOnSubmit(InsertUserInfo);
6 con.SubmitChanges();//提交数据库修改
7 look();//此方法为查询按钮事件里,提取的方法(便于显示)
8 }
1 protected void Button4_Click(object sender, EventArgs e)
2 {
3 testDataContext con = new testDataContext();
4 user InsertUserInfo = new user {name="aa",pwd="12346" };
5 con.user.InsertOnSubmit(InsertUserInfo);
6 con.SubmitChanges();//提交数据库修改
7 look();//此方法为查询按钮事件里,提取的方法(便于显示)
8 }
修改事件
1protected void Button2_Click(object sender, EventArgs e)
2 {
3 testDataContext db = new testDataContext();
4 user userinfo = db.user.First(a=>a.id==5);//这里是查询以id=5的第一个记录
5 userinfo.name += "ok";
6 db.SubmitChanges();
7 look();
8 }
1protected void Button2_Click(object sender, EventArgs e)
2 {
3 testDataContext db = new testDataContext();
4 user userinfo = db.user.First(a=>a.id==5);//这里是查询以id=5的第一个记录
5 userinfo.name += "ok";
6 db.SubmitChanges();
7 look();
8 }
删除事件代码
1protected void Button3_Click(object sender, EventArgs e)
2 {
3 testDataContext db = new testDataContext();
4 user userinfo = db.user.First(a => a.id == 5);
5 db.user.DeleteOnSubmit(userinfo);
6 db.SubmitChanges();
7 look();
8 }
1protected void Button3_Click(object sender, EventArgs e)
2 {
3 testDataContext db = new testDataContext();
4 user userinfo = db.user.First(a => a.id == 5);
5 db.user.DeleteOnSubmit(userinfo);
6 db.SubmitChanges();
7 look();
8 }