请问大家都是如何做----“确认删除”----的啊????在线给分~~谢谢拉~~
在删除之前,让用户确认是否删除。我的代码:
Private Sub DataGrid1_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.DeleteCommand
Response.Write("<script language='javascript'>if(confirm('是否确认此操作?')==true)this.location.href='usermanage.aspx?a=1';else ;</script>")
If Request.QueryString("a") = 1 Then
Dim id As Integer
Dim strsql As String
id = DataGrid1.DataKeys(e.Item.ItemIndex)
strsql = "DELETE FROM usertable where user_id=@id"
SqlConnection1.Open()
Dim cmdsql As SqlCommand = New SqlCommand(strsql, SqlConnection1)
cmdsql.Parameters.Add("@id", id)
cmdsql.ExecuteNonQuery()
SqlConnection1.Close()
DataGrid1.EditItemIndex = -1
binddatagrid()
End If
End Sub
--------------------------------------------------------------------
我的代码有问题,就是第一条没法删除,以后的才能删除,请问大家有什么好办法啊???