如何可以插入到另一个表中的数据，然后再删除，但首先，我搜索帮助ID和数据显示在GridView的数据

|Tejas_Vaishnav:您可以插入，删除之前使用表触发器在另一个表中的数据意味着你可以写触发器将触发您的表之前的数据将被删除意味着你必须做删除触发器之前..查表数据插入背部和触发器里面写的代码。GridView的数据显示，意味着你想显示在该网格数据，数据被删除或剩余的数据......如果它被删除的数据，然后选择从备份表中的数据，并显示网格如果它是剩余数据，然后选择从您的原始表，并显示在网格..触发更多的细节，请参阅此......imgsrc=]
vino2012

codepre spanclass="code-keyword"protected/spanspanclass="code-keyword"void/spanGridView1_RowUpdating(spanclass="code-keyword"object/spansender,GridViewUpdateEventArgse){TextBoxtxtserverName=(TextBox)GridView1.Rows[e.RowIndex].FindControl(spanclass="code-string""/spanspanclass="code-string"txtserveredit"/span);DropDownListclientname=(DropDownList)GridView1.Rows[e.RowIndex].FindControl(spanclass="code-string""/spanspanclass="code-string"ddlclient"/span);DropDownListprojectname=(DropDownList)GridView1.Rows[e.RowIndex].FindControl(spanclass="code-string""/spanspanclass="code-string"ddlproject"/span);LinkButtonlnk=(LinkButton)GridView1.Rows[e.RowIndex].FindControl(spanclass="code-string""/spanspanclass="code-string"lnkRequestthree"/span);TextBoxtxtdate=(TextBox)GridView1.Rows[e.RowIndex].FindControl(spanclass="code-string""/spanspanclass="code-string"txtcal"/span);spanclass="code-keyword"string/spanservername=txtserverName.Text;spanclass="code-keyword"int/spanid=Convert.ToInt16(lnk.CommandArgument.ToString());spanclass="code-keyword"string/spanclientnameval=clientname.SelectedItem.Text;spanclass="code-keyword"string/spanprojectnameval=projectname.SelectedItem.Text;spanclass="code-keyword"string/spandate=txtdate.Text;DB_ref.updateIpSchemevalues(id,servername,clientnameval,projectnameval,date);spanclass="code-keyword"string/spanlnkipid=GridView1.DataKeys[e.RowIndex].Values[spanclass="code-digit"0/span].ToString();spanclass="code-keyword"string/spanlnkservername=servername;spanclass="code-keyword"string/spanlnkclientnamepublicip=GridView1.DataKeys[e.RowIndex].Values[spanclass="code-digit"2/span].ToString();spanclass="code-keyword"string/spanlnkclientnameprivateip=GridView1.DataKeys[e.RowIndex].Values[spanclass="code-digit"3/span].ToString();spanclass="code-keyword"string/spanlnkclientname=clientname.SelectedItem.Text;spanclass="code-keyword"string/spanlnkprojectname=projectname.SelectedItem.Text;spanclass="code-keyword"string/spanlnkdate=txtdate.Text;spanclass="code-keyword"int/spanIpId=Convert.ToInt16(lnkipid.ToString()); spanclass="code-keyword"int/spanisactive=spanclass="code-digit"1/span; spanclass="code-keyword"string/spancheckservername=DB_ref.insertcheckhistory(spanclass="code-string""/spanspanclass="code-string"ServerName"/span,IpId,lnkservername); spanclass="code-keyword"if/span(lnkservername==checkservername){DB_ref.updatetblhistory(spanclass="code-string""/spanspanclass="code-string"ServerName"/span,lnkservername,IpId,lnkservername);}spanclass="code-keyword"else/span{DB_ref.inserthistory_tb(IpId,lnkservername,lnkclientnamepublicip,lnkclientnameprivateip,lnkclientname,lnkprojectname,lnkdate,isactive); } } spanclass="code-keyword"public/spanspanclass="code-keyword"void/spaninserthistory_tb(spanclass="code-keyword"int/spanipid,spanclass="code-keyword"string/spanservername,spanclass="code-keyword"string/spanpublicip,spanclass="code-keyword"string/spanprivateip,spanclass="code-keyword"string/spanclientname,spanclass="code-keyword"string/spanprojectname,spanclass="code-keyword"string/spandate_tb,spanclass="code-keyword"int/spanisactive){sqldatabaseobjdatabase=spanclass="code-keyword"new/spansqldatabase();SqlCommandobjCmd;spanclass="code-keyword"try/span{objCmd=spanclass="code-keyword"new/spanSqlCommand();objCmd.CommandText=spanclass="code-string""/spanspanclass="code-string"INSERTINTOtblIPHistory(IPID,ServerName,PublicIP,PrivateIP,ClientName,ProjectName,Date,isActive)VALUES(@IPID,@ServerName,@PublicIP,@PrivateIP,@ClientName,@ProjectName,@Date,@isActive)"/span;objCmd.Connection=objdatabase.getConnection(); objCmd.Parameters.AddWithValue(spanclass="code-string""/spanspanclass="code-string"@IPID"/span,ipid);objCmd.Parameters.AddWithValue(spanclass="code-string""/spanspanclass="code-string"@ServerName"/span,servername);objCmd.Parameters.AddWithValue(spanclass="code-string""/spanspanclass="code-string"@PublicIP"/span,publicip);objCmd.Parameters.AddWithValue(spanclass="code-string""/spanspanclass="code-string"@PrivateIP"/span,privateip);objCmd.Parameters.AddWithValue(spanclass="code-string""/spanspanclass="code-string"@ClientName"/span,clientname);objCmd.Parameters.AddWithValue(spanclass="code-string""/spanspanclass="code-string"@ProjectName"/span,projectname);objCmd.Parameters.AddWithValue(spanclass="code-string""/spanspanclass="code-string"@Date"/span,date_tb);objCmd.Parameters.AddWithValue(spanclass="code-string""/spanspanclass="code-string"@isActive"/span,isactive);objCmd.ExecuteNonQuery();}spanclass="code-keyword"catch/span(Exceptionex2){spanclass="code-keyword"string/spanerrrr=ex2.Message.ToString();}spanclass="code-keyword"finally/span{objdatabase.closeConnection();}  }/pre/code
vino2012

查看这个范例..................保持更新历史记录...............