private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
鲗8犾e4
{ c?B嚵哠
DataGrid1.EditItemIndex=(int)e.Item.ItemIndex; / ТЭ羪?
BindGrid(); 嚕b?6w?
} 唷2姁桳N揎
2鈔漱嵼Y揫
private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) h鯮?妰??
{ {g4?旇B猊
DataGrid1.EditItemIndex=-1; ?鐳SsP?
BindGrid(); ???z袚?
} ?侊9@:?v
獳IY濖b [
private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) *鋂~危擿F
{ el0?UHt
DataGrid1.EditItemIndex=-1; ?祯C漵
旇}o鶴枷踊
SqlConnection SqlConn; 嶋曧7M?
DataSet objDataSet=new DataSet(); - !#r?]?
string Connstr=ConfigurationSettings.AppSettings["strConn"]; T簳硬稆圜x
string SQLstr="select * from khxx"; ]?S敟愦
SqlConn=new SqlConnection(Connstr); vJ焐躗e惺
SqlDataAdapter objAdapter=new SqlDataAdapter(SQLstr,SqlConn); 倴^沨-
objAdapter.Fill(objDataSet,"khxx"); R睯H$烃?
W淉戔?皻A
TextBox CurrentText; x`N3瞐呥
CurrentText = (TextBox)e.Item.Cells[1].Controls[0];//取得文本框 [^潁鑕P/?
objDataSet.Tables["khxx"].Rows[(int)e.Item.ItemIndex]["khjc"]=CurrentText.Text; 隠q??qS
?寯M鹿
SqlCommandBuilder cb=new SqlCommandBuilder(objAdapter); ?“AB?lt;?
SqlConn.Open(); 嵪}@夹)媖R
objAdapter.Update(objDataSet,"khxx"); 洈 C;琟锚%
SqlConn.Close(); #蔟?ザ7
禦椘?
DataGrid1.DataSource=objDataSet.Tables["khxx"]; 県[a灎 鍞X
DataGrid1.DataBind(); 笺"_槚摎稢
"癜憐'焭Q
} 墶袱
在PageLoad()里一定要if(Page.IsPostBack){....}; m糱`}效?l
DataGrid1.DataKeyField="khbh"; 砨鷇 l
{ c?B嚵哠
DataGrid1.EditItemIndex=(int)e.Item.ItemIndex; / ТЭ羪?
BindGrid(); 嚕b?6w?
} 唷2姁桳N揎
2鈔漱嵼Y揫
private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) h鯮?妰??
{ {g4?旇B猊
DataGrid1.EditItemIndex=-1; ?鐳SsP?
BindGrid(); ???z袚?
} ?侊9@:?v
獳IY濖b [
private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) *鋂~危擿F
{ el0?UHt
DataGrid1.EditItemIndex=-1; ?祯C漵
旇}o鶴枷踊
SqlConnection SqlConn; 嶋曧7M?
DataSet objDataSet=new DataSet(); - !#r?]?
string Connstr=ConfigurationSettings.AppSettings["strConn"]; T簳硬稆圜x
string SQLstr="select * from khxx"; ]?S敟愦
SqlConn=new SqlConnection(Connstr); vJ焐躗e惺
SqlDataAdapter objAdapter=new SqlDataAdapter(SQLstr,SqlConn); 倴^沨-
objAdapter.Fill(objDataSet,"khxx"); R睯H$烃?
W淉戔?皻A
TextBox CurrentText; x`N3瞐呥
CurrentText = (TextBox)e.Item.Cells[1].Controls[0];//取得文本框 [^潁鑕P/?
objDataSet.Tables["khxx"].Rows[(int)e.Item.ItemIndex]["khjc"]=CurrentText.Text; 隠q??qS
?寯M鹿
SqlCommandBuilder cb=new SqlCommandBuilder(objAdapter); ?“AB?lt;?
SqlConn.Open(); 嵪}@夹)媖R
objAdapter.Update(objDataSet,"khxx"); 洈 C;琟锚%
SqlConn.Close(); #蔟?ザ7
禦椘?
DataGrid1.DataSource=objDataSet.Tables["khxx"]; 県[a灎 鍞X
DataGrid1.DataBind(); 笺"_槚摎稢
"癜憐'焭Q
} 墶袱
在PageLoad()里一定要if(Page.IsPostBack){....}; m糱`}效?l
DataGrid1.DataKeyField="khbh"; 砨鷇 l