首页 > 代码库 > linq asp.net

linq asp.net

  1. 添加Linq to SQL类
    添加新项|Linq to SQL类,拖放SQL db中的表到dbml文件,自动创建相关的数据库相应的类。(在.cs文件中)
  2. Linq的使用
  •   添加本页面的全局变量,公用的绑定代码

 

public DataClassesDataContext lqDB = new DataClassesDataContext(ConfigurationManager.ConnectionStrings["pubsConnectionString"].ToString());
 protected void bind()
    {
        var result = from r in lqDB.authors
                     where r.state.Equals("CA")
                     select r;//new { r.au_id, r.au_fname, r.au_lname, r.address};
        GridView1.DataSource = result;
        GridView1.DataBind();
    }
  • PageLoad事件
    protected void Page_Load(object sender, EventArgs e)
        {
            if(!IsPostBack)
    
            bind();
        }

     

  • Row_Editing事件
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
        {
            GridView1.SelectedIndex = e.NewEditIndex;
            GridView1.EditIndex = e.NewEditIndex;
            bind();
    
        }

     

  • RowCancellingEdit事件
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            GridView1.EditIndex = -1;
            bind();
        }

RowUpdating事件

 protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        //au_id    au_lname    au_fname    phone    address    city    state    zip         contract     
//定位行对象
        authors au = lqDB.authors.First(c => c.au_id == GridView1.DataKeys[e.RowIndex].Value);
//修改行对象
        au.au_lname = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
        au.au_fname = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text;
        au.phone = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
        au.address = ((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0]).Text;
        au.city = ((TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0]).Text;
        au.state = ((TextBox)GridView1.Rows[e.RowIndex].Cells[6].Controls[0]).Text;
        au.zip = ((TextBox)GridView1.Rows[e.RowIndex].Cells[7].Controls[0]).Text;
        au.contract = ((CheckBox)GridView1.Rows[e.RowIndex].Cells[8].Controls[1]).Checked;//模版字段有itemtemplate\edititemtemplate两个。
//提交行对象
        lqDB.SubmitChanges();
        GridView1.EditIndex = -1;
        bind();
    }

 

linq asp.net