get DataColumn metadata

[Guest]

hello all,
i am looking for a way to get metadata of a DataColumn (in c#).

i want to write a switch-case statement(if it possible) that check the
Column DataType as declared at the database (adChar, adVarChar,adDate,
adDBDate, adDBTimeStamp,adDecimal, adSingle, adDouble, adNumeric, ..., ....)
and then to get for each one it's 'DefinedSize' and 'NumericScale' values.

in ADO Recordset it was very simple,
what is the best & right way to do it in ADO.net (C#)?
thank's
stan

 

[William \(Bill\) Vaughn]

In 2.0 you can use the Connection.GetSchema method.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________