Hi All,
Hoping you can help. The below if statement works but it feels wrong to me
Code:Dim upsql As String = "Update Calls SET " & col & " = @newvalue Where callID = @callid" Dim sqlcmd As New SqlCommand(upsql, sqlcon) If DataGridView1.Columns(e.ColumnIndex).ValueType.ToString = "System.Boolean" Then sqlcmd.Parameters.Add("@newvalue", SqlDbType.Bit) Else sqlcmd.Parameters.Add("@newvalue", SqlDbType.Text) End If
Does anyone know a better way to find out if my datacolumn is a boolean or not.
Cheers




Reply With Quote