How to do a multiple select and update in a datagrid

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wolffang - 23 Oct 2004 21:21 GMT

Using Visual studio.net VB

I have a datagrid that brings records from a stored procedure.

Be selecting multiple datarows using a checkbox.
All i want to do is update a field called 'Active' datatype bit from 0 to 1
for all those records that have been selected with the checkbox and mark
another field 'User' with the name of the user who selected these items when
a update button is clicked.

checkbox needs to be disabled if the record of 'Active' is 1

any solutions out there???

Reply to this Message

irene - 27 Oct 2004 20:50 GMT

You can do a batch update.
something like:

Dim dg As DataGridItem
Dim ck As CheckBox
Dim UserID As Label

For Each dg In yourdatagrid.Items
ck = dg.FindControl("yourcheckboxname")
UserID = dg.FindControl("yourdatakeyfield")

If ck.Checked = True Then
UpdateUserHistory(UserID.Text, 1)
Else
UpdateUserHistory(UserID.Text, 0)
End If

Next

and then you can define the function on UpdateUserHistory...

HTH,

Irene

> Using Visual studio.net VB
>
[quoted text clipped - 9 lines]
>
> any solutions out there???

Reply to this Message

Wolffang - 30 Oct 2004 17:59 GMT

Thank you for your answer...

This is what i have so far.... but i am geting an error.... where the OrderID is not being passed from the datagrid "dgOrders" to the stored procedure... but the checkbox is working... is this because i am using FindControl???

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click

Dim dg As DataGridItem

Dim ck As CheckBox

Dim OrdID As Label

Me.SqlConnection1.Open()

For Each dg In dgOrders.Items

ck = dg.FindControl("chkSelect")

OrdID = dg.FindControl("OrderID")

If ck.Checked = True Then

Me.SqlCommand1.Parameters("@OrderID").Value = OrdID

Me.SqlCommand1.Parameters("@AdminUserName").Value = lblUserName.Text

Me.SqlCommand1.Parameters("@AdminProcess").Value = 1

Me.SqlCommand1.ExecuteNonQuery()

End If

Next

Me.SqlConnection1.Close()

End Sub

Reply to this Message

How to do a multiple select and update in a datagrid

Free Magazines