Linq增删改查的关键代码

来源:互联网 发布:淘宝上门自提 编辑:程序博客网 时间:2024/06/05 06:28
  private void DtBind()
    {
        ContarDataContext cdc = new ContarDataContext();
        var RtData = from OneLine in cdc.ENTRY_CONTAINERs
                     select OneLine;
        GridView1.DataSource = RtData;
        GridView1.DataBind();
    }
    protected void Bt_Select_Click(object sender, EventArgs e)
    {
        ContarDataContext cdc = new ContarDataContext();
        var RtData=from OneLine in cdc.ENTRY_CONTAINERs
                   orderby OneLine.CONTAINER_WT descending
                   select OneLine;
        GridView1.DataSource = RtData;
        GridView1.DataBind();
      
    }
    protected void Bt_Insert_Click(object sender, EventArgs e)
    {
        ContarDataContext db = new ContarDataContext();
        ENTRY_CONTAINER E_C = new ENTRY_CONTAINER{CONTAINER_ID="aa",CONTAINER_WT=10,ENTRY_ID="1"};
        db.ENTRY_CONTAINERs.InsertOnSubmit(E_C);
        db.SubmitChanges();
        DtBind();
    }
    protected void Bt_Update_Click(object sender, EventArgs e)
    {
        ContarDataContext db = new ContarDataContext();
        ENTRY_CONTAINER E_C = db.ENTRY_CONTAINERs.First(p => p.ENTRY_ID.StartsWith("1"));
        E_C.CONTAINER_WT += 6;
        db.SubmitChanges();
        DtBind();
    }
    protected void Bt_Del_Click(object sender, EventArgs e)
    {
        ContarDataContext db = new ContarDataContext();
        ENTRY_CONTAINER E_C = db.ENTRY_CONTAINERs.First(p => p.ENTRY_ID.StartsWith("1"));
        db.ENTRY_CONTAINERs.DeleteOnSubmit(E_C);
        db.SubmitChanges();
        DtBind();
    }
原创粉丝点击