|
-
Feb 24th, 2004, 09:57 AM
#1
Thread Starter
Member
multiple delete
Hi,
i have try to use multiple checkbox to delete users by using datagrid.
Below is my codes:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
Dim conn As OleDbConnection
Dim objCmd = New OleDbCommand
conn = connectToDB()
objCmd.commandtext = "spGetMembers"
objCmd.CommandType = CommandType.StoredProcedure
objCmd.connection = conn
Dim myDataReader As OleDbDataReader
myDataReader = objCmd.ExecuteReader
dgDelMember.DataSource = myDataReader
dgDelMember.DataBind()
conn.close()
End Sub
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
Dim Item
For Each Item In Request.QueryString("chkMemDelete")
'SQL statement here
Dim conn As OleDbConnection
Dim objCmd = New OleDbCommand
conn = connectToDB()
objCmd.commandtext = "spDelMembers"
objCmd.CommandType = CommandType.StoredProcedure
objCmd.connection = conn
Dim myDataReader As OleDbDataReader
myDataReader = objCmd.ExecuteReader
dgDelMember.DataSource = myDataReader
dgDelMember.DataBind()
conn.Close()
Next
End Sub
But they can't find the "chkMemDelete" as the id for checkbox is in the datagrid.
Error:
Object reference not set to an instance of an object.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|