How can I check the length of a Field in a Table

[Sajid]

Hi!,

I just want to display (in a DataGrid) the length and Type (e.g.
Type=Char Length=10) of all the fields in my database table. I have
already made a DataTable using the DataAdapter Fill command. So how
can I do it.

Your kind help will be highly appreciated.


cheers

SY

 

[John Timney \(Microsoft MVP\)]

read the database schema

http://www.dotnetextreme.com/code/getdbschema.asp

--
Regards

John Timney
Microsoft Regional Director
Microsoft MVP

 

[Sajid]

Hi!,

Thanks for replying back. Is there any equivalent command available for ODBC?

cheers

SY