最近看了看Linq。以下是我在学习过程中的笔记,一些简单的添加、修改、删除的代码。希望对大家有所帮助。
随便建了个表结构如下,同时在vs2008下新建一个dbml文件并添加student表:
//将数据绑定到gridview
private void InitData()
{
DataClassesDataContext db = new DataClassesDataContext();
var stu = from p in db.student
orderby p.age ascending
select new
{
编号 = p.id,
姓名 = p.name,
性别 = p.sex,
年龄 = p.age
};
this.GridView1.DataSource = stu;
this.GridView1.DataBind();
}
//添加数据
public void add()
{
DataClassesDataContext db = new DataClassesDataContext();
student s = new student();
s.id = this.tbadd.Text.ToString();
s.name = "test";
s.sex = "男";
s.age = "100";
db.student.InsertOnSubmit(s);
db.SubmitChanges();
}
//删除数据
public void dele()
{
DataClassesDataContext db = new DataClassesDataContext();
var stu = from p in db.student
where p.id == this.tbdeleate.Text
select p;
foreach (var s in stu)
{
db.student.DeleteOnSubmit(s);
}
db.SubmitChanges();
}
// 更新id为“001”的数据
public void update()
{
DataClassesDataContext db = new DataClassesDataContext();
student s= db.student.Single(u => u.id == "001");
s.name = this.tbupdate.Text;
db.SubmitChanges();
}