getting ntext datatype

[Rippo]

I am returning a datatable from a stored procedure and then iterating
through the columns. I am trying to find out if a column has the sql
data type of ntext. In .net the datatype of a sql ntext column is
System.String. .Net also returns System.String for varchar, char, text,
nvarchar and nchar. This obviously does not help me as I want to
identify the ntext column

I have searched for this and cannot find the answer in .net. I can
however query the database for the column datatype but this seems like
overkill.

Can any help?

Thanks

 

[Karl Seguin]

DataTable is a generic thing. You can get a DataTable from an access
database, which knows nothing of VarChar's and Text SQL types.

The only way I'm aware of is to use the GetSchemaTable from the
SqlDataReader:
http://www.netomatix.com/DumpDbSchema.aspx

Karl