关于DataGrid删除记录的问题(网上答案很多,但都不够详细,还是没有帮我解决问题,请高手帮忙)
我写的代码如下:
ASPX代码:<asp:ButtonColumn Text="<img border=0 alt='删除' src=../index/images/delete.gif>"
HeaderText="删除"
ButtonType="LinkButton"
HeaderStyle-ForeColor="#FFFFFF"
CommandName="Delete_Click" />
ASPX.VB代码:Protected Sub Delete_Click(ByVal Sender As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs)
Dim StrID = e.Item.Cells(0).Text
Dim MyConn As OleDbConnection, MyCmd As OleDbCommand, MySql As String
MyConn = New OleDbConnection(ConfigurationManager.AppSettings("AccessString") & System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings("DataBase")))
MyConn.Open()
MySql = "Delete * from Equipment Where C_ID=" & StrID
MyCmd = New OleDbCommand(MySql, MyConn)
MyCmd.ExecuteNonQuery()
MyConn.Close()
End Sub
请各位高手帮忙
------解决方案--------------------<!--在DataGrid控件里添加一个"OnDeleteCommand">
<asp:DataGrid ID="MyGrid" runat="server"
......
OnDeleteCommand="Delete_Click"
AutoGenerateColumns="false"
.....>
<Columns>
<!--如果是自定义字段,那就增加一个id,传给VB代码-->
<asp:BoundColumn DataField="id" Visible="false">
<!--在增加一个删除链接(按钮)-->
<asp:ButtonColumn Text= "<img src='../index/images/delete.gif' OnClick='JavaScript:return delAction()' border='0'>" CommandName="Delete" HeaderText="操作" HeaderStyle-ForeColor="#FFFFFF" />
</Columns>
</asp:DataGrid>
另外::JavaScript:return delAction()是一个JavaScript的验证,提示用户是否确定删除,其他的应该看得懂了吧?