Interrogate datatype in a datatable

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

I would like to do something like this if possible.

If tablename.Columns.Item(i).DataType() =
System.String or system.date Then
'build dynamic sql with quotes
Else
'build dynamic sql without quotes
End If


Any solutions?

Thanks.
 
-----Original Message-----
I would like to do something like this if possible.

If tablename.Columns.Item(i).DataType() =
System.String or system.date Then
'build dynamic sql with quotes
Else
'build dynamic sql without quotes
End If


Any solutions?

Thanks.
.
Click to expand...
 
Back
Top