-
Checkboxes and datagrids
Hello, I could really use some help with this issue that I'm having. I have a datagrid that I'm populating when my tables completed field =0. I want to use a check box on the form(not in a template column) to update the completed field of my table with a 1.
I'm still new and learning and have tried to add to my WITH statement this: .item("Completed")=Me.cbCompleted.text
But I get a boolean conversion error.
What do I need to add to my update function to update the completed field with the value of the checkbox?
Here is the function:
Private Function UpdateRequestInfo()
Dim iID As Integer = Convert.ToInt32(Me.lblId.Text)
Call LoadGrid()
Dim dr As DataRow = Me.DataSet11.requestInfo.Rows.Find(iID)
With dr
.Item("FirstName") = Me.txtFirstName.Text
.Item("Middlename") = Me.txtMiddleName.Text
.Item("LastName") = Me.txtLastName.Text
End With
Me.SqlDataAdapter1.Update(Me.DataSet11, "RequestInfo")