当前文件路径：LinqDemo/Default.aspx.cs

		            
 1using System;
 2using System.Configuration;
 3using System.Data;
 4using System.Linq;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.HtmlControls;
 9using System.Web.UI.WebControls;
10using System.Web.UI.WebControls.WebParts;
11using System.Xml.Linq;
12//Download from 51aspx.com/cv/LinqDemo
13public partial class _Default : System.Web.UI.Page 
14...{
15
16    StaffBLL sb = new StaffBLL();
17    protected void Page_Load(object sender, EventArgs e)
18    ...{
19        if (!this.IsPostBack)
20        ...{
21            bindData();
22        }
23    }
24
25    private void bindData()
26    ...{
27        //StaffBLL sb = new StaffBLL();
28        this.GridView1.DataSource = sb.LinqStaff();
29        this.GridView1.DataBind();
30    }
31    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
32    ...{
33        this.GridView1.EditIndex = e.NewEditIndex;
34        bindData();
35    }
36    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
37    ...{
38        int id = Convert.ToInt32(this.GridView1.DataKeys[e.RowIndex].Value);
39        TextBox staffTb = this.GridView1.Rows[e.RowIndex].Cells[1].Controls[0] as TextBox;
40        TextBox ageTb = this.GridView1.Rows[e.RowIndex].Cells[2].Controls[0] as TextBox;
41        string staffName = staffTb.Text;
42        int  age = Convert.ToInt32(ageTb.Text);
43        sb.LinqUpdateStaff(id, staffName, age);
44        this.GridView1.EditIndex = -1;
45        bindData();
46    }
47    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
48    ...{
49        this.GridView1.EditIndex = -1;
50        bindData();
51    }
52    protected void Button1_Click(object sender, EventArgs e)
53    ...{
54        sb.LinqInsertStaff(this.TextBox1.Text,Convert.ToInt32(this.TextBox2.Text));
55        bindData();
56        this.TextBox1.Text = "";
57
58    }
59    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
60    ...{
61        int id = Convert.ToInt32(this.GridView1.DataKeys[e.RowIndex].Value);
62        sb.LinqDeleteStaff(id);
63        bindData();
64    }
65}
66