How to retrieve the Name of the DataType of a column

Using MSSQL 2000 and VB2005. Want to get the data type of a column in a table in order to know if my insert command needs a convert statement.

I Found TYPE_NAME but i can't get it to work. Any help would be appreciated

Ger




Answer this question

How to retrieve the Name of the DataType of a column

  • Valerie Prieur

    SqlDataReader class has GetSchemaTable method that returns metadata information. It could be what you need

  • Chris Cyvas

    Thanks for your help. Thats what i needed to use.

  • How to retrieve the Name of the DataType of a column