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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Interrogating mySQL datatypes with ADO.NET 8
Changing a DataTables Schema 9
inserting new row in datatable 3
HELP: Cast as Type VS 2003 5
getting ntext datatype 1
How to extract data from a Datatable into another DataTable or dat 1
Database datatype to c# datatype 3
Error: Cannot change DataType of a column once it has data 4

Back
Top