gridview 编辑需要 写的事件》。。。。

protected void GridView1_RowEditing( object sender, GridViewEditEventArgs e)
... {
GridView1.EditIndex = e.NewEditIndex;
bind();
}
protected void GridView1_RowUpdating( object sender, GridViewUpdateEventArgs e)
... {
        sqlcon = new SqlConnection(strCon);
string sqlstr = " update tb_Member set name=' "
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[ 1 ].Controls[ 0 ])).Text.ToString().Trim() + " ',sex=' "
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[ 2 ].Controls[ 0 ])).Text.ToString().Trim() + " ',nPlace=' "
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[ 3 ].Controls[ 0 ])).Text.ToString().Trim() + " ' where id=' "
+ GridView1.DataKeys[e.RowIndex].Value.ToString() + " ' " ;
        sqlcom = new SqlCommand(sqlstr,sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        GridView1.EditIndex = - 1 ;
        bind();
    }
protected void GridView1_RowCancelingEdit( object sender, GridViewCancelEditEventArgs e)
... {
        GridView1.EditIndex = - 1 ;
        bind();
    }
public void bind()
... {
string sqlstr = " select * from tb_Member " ;
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, " tb_Member " );
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = new string [] ... { " id " } ;
        GridView1.DataBind();
        sqlcon.Close();
    }