请教一个关于Datagrid中删除数据的功能
我现在有一个datagrid控件,我想用一个bottoncolumn来实现删除数据,但是删除后
我希望重载datagrid,现在问题是我设置了分页功能,如何实现datagrid重载后,能
仍然留在当前页,并刷新记录?部分相关代码如下:
<asp:datagrid ID="peall" runat="server" allowsorting="True" datakeyfield="psid" AutoGenerateColumns="false" BackColor="#EFEDFE" HorizontalAlign="center" HeaderStyle-ForeColor="#0066FF" HeaderStyle-Font-Bold="true" Width="700" Allowpaging="true" PageSize="12" PagerStyle-mode="Numericpages" Position="TopandBotton" OnSortcommand="sortcmd" OnPageIndexChanged="Pagechange" onitemcommand="del">
<columns>
<asp:hyperlinkcolumn
headertext="简历编号"
DataNavigateUrlField="psid"
DataNavigateUrlFormatString="perpe.aspx?psid={0}"
DataTextField="psid"
Target ="_blank"
Sortexpression="psid"/>
<asp:boundcolumn
HeaderText="性别"
DataField="sex"
Sortexpression="sex"/>
<asp:boundcolumn
HeaderText="年龄"
DataField="age"
Sortexpression="age"/>
<asp:boundcolumn
HeaderText="居住地"
DataField="hukou"
Sortexpression="hukou"/>
<asp:boundcolumn
HeaderText="学历"
DataField="medu"
SortExpression="medu"/>
<asp:boundcolumn
HeaderText="工作年限"
DataField="wt"
SortExpression="wt"/>
<asp:boundcolumn
HeaderText="专业"
DataField="specf"
SortExpression="specf"/>
<asp:boundcolumn
HeaderText="求职意向"
DataField="specf1"
SortExpression="specf1"/>
<asp:boundcolumn
HeaderText="发布日期"
DataField="plb"
SortExpression="plb"/>
<asp:boundcolumn
HeaderText="备注"
DataField="det"
SortExpression="det"/>
<asp:buttoncolumn
headertext="删除"
buttontype="pushbutton"
text="删除"
/>
</columns>
</asp:datagrid>
Sub del( ByVal sender as object,ByVal E as Datagridcommandeventargs)
Dim theid as string
Dim strcmd as string
theid=peall.Datakeys(E.item.itemindex)
test.text=theid
strcmd="delete basicinfo where psid=" & theid
con=new sqlconnection(Configurationsettings.Appsettings("class"))
cmd=new sqlcommand(strcmd,con)
con.open
cmd.executenonquery
con.close
strcmd="delete edu where psid=" & theid
con=new sqlconnection(Configurationsettings.Appsettings("class"))
cmd=new sqlcommand(strcmd,con)
con.open
cmd.executenonquery
con.close
strcmd="delete jobexp where psid=" & theid
con=new sqlconnection(Configurationsettings.Appsettings("class"))
cmd=new sqlcommand(strcmd,con)
con.open
cmd.executenonquery
con.close
strcmd="delete certall where psid=" & theid
con=new sqlconnection(Configurationsettings.Appsettings("class"))
cmd=new sqlcommand(strcmd,con)
con.open
cmd.executenonquery
con.close
strcmd="delete cust where psid=" & theid
con=new sqlconnection(Configurationsettings.Appsettings("class"))
cmd=new sqlcommand(strcmd,con)
con.open
cmd.executenonquery
con.close
'peall.currentpageindex=pageid
'searchwt
End sub