Protected void gridviewinclurowediting (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 ();
}