Linq 学习笔记一（添加、修改、删除 ）

最近看了看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();
    }