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
testDataContext db = new testDataContext();//类型于我们SQL语句里的，创建字符串连接2
var a = from test in db.user //类似于SQL中 select id,name from user where id=13
where test.id == 14
select new 
{ test.id, test.name }; //如果在这里要查询所有的项，则可以直接写 test5
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 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
}
删除事件代码1
protected 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
}
浙公网安备 33010602011771号