求助! vb.net的delete问题vb.net的delete问题
Sub DeleteEdit(ByVal sender As Object, ByVal e As DataGridCommandEventArgs)
'删除数据
Dim index As String
index = e.Item.ItemIndex
Dim strSQL As String = "Delete From sqbiao Where " & DataGrid1.DataKeyField & _
"=" & DataGrid1.DataKeys(e.Item.ItemIndex) executesql(strSQL)
DataGrid1.EditItemIndex = -1
BindGrid()
Response.Write("<script>alert('" + index + "')</script>") End Sub为什么会出错了,
异常详细信息: System.ArgumentOutOfRangeException: 索引超出范围。必须为非负值并小于集合大小。参数名: index应该怎么改啊,大家帮我一下啊,谢谢了
Sub DeleteEdit(ByVal sender As Object, ByVal e As DataGridCommandEventArgs)
'删除数据
Dim index As String
index = e.Item.ItemIndex
Dim strSQL As String = "Delete From sqbiao Where " & DataGrid1.DataKeyField & _
"=" & DataGrid1.DataKeys(e.Item.ItemIndex) executesql(strSQL)
DataGrid1.EditItemIndex = -1
BindGrid()
Response.Write("<script>alert('" + index + "')</script>") End Sub为什么会出错了,
异常详细信息: System.ArgumentOutOfRangeException: 索引超出范围。必须为非负值并小于集合大小。参数名: index应该怎么改啊,大家帮我一下啊,谢谢了
Select Case e.Item.ItemType
Case ListItemType.Item, ListItemType.AlternatingItem, ListItemType.EditItem
Dim myDeleteButton As ImageButton
myDeleteButton = e.Item.FindControl("ImageButton1")
myDeleteButton.Attributes.Add("onclick", "return confirm('您确定要把该书从收藏夹中删除吗?');")
End Select End Sub
Private Sub DataGrid1_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.ItemCommand
Select Case e.CommandName Case "del" Dim conn As New OleDbConnection("Data Source=""" & Me.Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings("database")) & """;Provider=""Microsoft.Jet.OLEDB.4.0"";User ID=Admin")
'得到用户ID
Dim userid As Integer
Dim myCommand As New OleDbDataAdapter("SELECT UserId, UserName FROM T_UserInfo WHERE (UserName = '" & Me.Session("username") & "')", conn)
Dim ds As New DataSet
myCommand.Fill(ds, "T_UserInfo")
userid = CInt(ds.Tables(0).DefaultView.Item(0).Item(0))
Dim a As Integer = e.Item.Cells(0).Text conn.Open()
Dim favdel As New OleDbCommand("DELETE FROM T_Favorites WHERE (Book_ID = " & a & ") AND (UserID = " & userid & ")", conn)
favdel.ExecuteNonQuery()
If DataGrid1.CurrentPageIndex < Me.DataGrid1.PageCount And DataGrid1.CurrentPageIndex <> 0 Then
DataGrid1.CurrentPageIndex = DataGrid1.CurrentPageIndex - 1
End If
conn.Close()
favbind()
End Select
End Sub仔细看看
还有别的方法吗
Sub DeleteEdit完全代码应该是怎样写的啊?
这句是不是有问题....那条已经删除了.
现在急用,谢谢大家啊
ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) _
Handles DataGrid1.DeleteCommand
Dim index As Integer
index = e.Item.ItemIndex
DataGrid1.DataBind()
End Sub怎样为控件的 DeleteCommand 事件创建一个事件处理程序啊???????