I'm trying to do this and it errors with Input string was not in a correct format
Dim i As Integer
For i = 0 To surveyNameDropdown.Items.Count - 1
If ds.Tables(0).Columns("surveyActive").ColumnName = True Then
Column in database called surveyActive with the data type set as bit
Thanks in advance..