Hello,
I have some text boxes and a check box in a gridview footer for adding values. When users add a record I get the checkbox's value as a True or False with this code:
Dim blActive As Boolean = False Dim chkBoxDSA As CheckBox = DirectCast(gvDetails.FooterRow.FindControl("ChckBxAddADefaultShip"), CheckBox) If chkBoxDSA.Checked Then blActive = True Else blActive = False
When I go to insert the text boxes and this checkbox's value I get an error Conversion from string "," to type 'Double' is not valid always pointing to the + after blActive. I have ran through the debugger and verified blActive value is True or False when checkbox is selected. Depending upon true or false I am trying to insert a 1 or 0 in the ship column which is of type bit.
Here is the insert code using ADO.NET:
Dim cmd As New SqlCommand("insert into dbo.Customers" & _ " ...

Go to the complete details ...