[2005] Comparing data types

[Oliver1]

Hi All,

Hoping you can help. The below if statement works but it feels wrong to me

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

[talkro]

Using this query you can information about columns in your database

query = "SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'MyTable'"

[Oliver1]

Thanks, not quite what I need though.
I just need to know how i run an if statement or a case statement on the below.

DataGridView1.Columns(e.ColumnIndex).ValueType

eg

Select case DataGridView1.Columns(e.ColumnIndex).ValueType
case boolean 
'blah blah

case text
'blah blah

case int
'blah blah

Case else

[talkro]

Well i think you already got your solution. The case you just did would be the best solution for this problem. You have the type of the column you ar looking for and you know the different possibilities. Either it is an if statement or a case as you just did.

[Oliver1]

Thanks for your time on this, my problem is that it will not let you do a comparison like this

If boolean = boolean then

end if

As you get an error saying boolean is a type and cannot be used in an expression.

So how do you do a comparison on datatypes.

[Tom Sawyer]

You can't use = to find a datatype, you have to use Is.

So, it would be:

If bVariable Is Boolean then ...

[talkro]

you can use an if structure and

if typeof DataGridView1.Columns(e.ColumnIndex).ValueType is System.boolean then
 
end if