<asp:GridView ID="g1" runat="server" AutoGenerateColumns="False" 
            _disibledevent="g1_RowDataBound" _disibledevent="g1_RowDeleting" 
            _disibledevent="g1_Sorting" _disibledevent="g1_PageIndexChanging" 
            _disibledevent="g1_RowCancelingEdit" _disibledevent="g1_RowEditing" 
            _disibledevent="g1_RowUpdating">
            <Columns>
                <asp:BoundField DataField="id" HeaderText="学号" SortExpression="id" />
                <asp:BoundField DataField="studentName" HeaderText="姓名" 
                    SortExpression="studentName" />
                <asp:BoundField DataField="studentSex" HeaderText="性别" 
                    SortExpression="studentSex" />
                <asp:TemplateField HeaderText="年龄" SortExpression="studentAge">
                    <EditItemTemplate>
                        <asp:TextBox ID="txtAge" runat="server" Text='<%# Bind("studentAge") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="labAge" runat="server" Text='<%# Bind("studentAge") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:CommandField ButtonType="Button" ShowDeleteButton="True" />
                <asp:CommandField ButtonType="Button" ShowEditButton="True" />
            </Columns>
        </asp:GridView>

public SqlConnection conn = new SqlConnection("server=.;database=db_workHard;user=sa;pwd=123;");
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                InitData();
            }
        }

        private void InitData()
        {
            try
            {
                conn.Open();
            }
            catch(Exception ex)
            {}
            string sql = "select * from tb_Student";
            SqlCommand comm = new SqlCommand(sql, conn);
            SqlDataAdapter sda = new SqlDataAdapter(comm);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            g1.DataSource = dt;
            g1.DataKeyNames = new string[] { "id"};
            g1.AllowSorting = true;
            if (ViewState["sortExpression"] == null)
                ViewState["sortExpression"] = "id";
            if (ViewState["sortDirection"] == null)
                ViewState["sortDirection"] = "asc";
            dt.DefaultView.Sort = ViewState["sortExpression"] + "" + ViewState["sortDirection"];
            g1.AllowPaging = true;
            g1.PageSize = 3;
            g1.DataBind();
            conn.Close();
        }

        protected void g1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            try
            {
                conn.Open();
            }
            catch(Exception ex)
            {}
            string sql = "delete from tb_Student where id=@id";
            SqlCommand comm = new SqlCommand(sql, conn);
            comm.Parameters.AddWithValue("@id", g1.DataKeys[e.RowIndex].Value);
            comm.ExecuteNonQuery();
            InitData();
            conn.Close();
        }

        protected void g1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                try
                {
                    Button b = (Button)e.Row.Cells[4].Controls[0];
                    b.Attributes["onclick"] = "x=confirm('确定要删除" + e.Row.Cells[1].Text + "吗?');if(!x) return;";
                }
                catch(Exception ex)
                {}
            }
        }

        protected void g1_Sorting(object sender, GridViewSortEventArgs e)
        {
            if (ViewState["sortExpression"].ToString() == e.SortExpression)
            {
                if (ViewState["sortDirection"].ToString() == "asc")
                    ViewState["sortDirection"] = "desc";
                else
                    ViewState["sortDirection"] = "asc";
            }
            else
            {
                ViewState["sortExpression"] = e.SortExpression;
                ViewState["sortDirection"] = "asc";
            }
            InitData();
        }

        protected void g1_RowEditing(object sender, GridViewEditEventArgs e)
        {
            g1.EditIndex = e.NewEditIndex;
            InitData();
        }

        protected void g1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            g1.EditIndex = -1;
            InitData();
        }

        protected void g1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            conn.Open();
            string stuName = ((TextBox)g1.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
            string stuAge = ((TextBox)g1.Rows[e.RowIndex].Cells[3].Controls[1]).Text;
            string sql = "update tb_Student set studentName=@stuName,studentAge=@stuAge where id=@id";
            SqlCommand comm = new SqlCommand(sql, conn);
            comm.Parameters.AddWithValue("@stuName", stuName);
            comm.Parameters.AddWithValue("@stuAge", stuAge);
            comm.Parameters.AddWithValue("@id", g1.DataKeys[e.RowIndex].Value);
            comm.ExecuteNonQuery();
            g1.EditIndex = -1;
            InitData();
            conn.Close();
        }

        protected void g1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            g1.PageIndex = e.NewPageIndex;
            InitData();
        }