DataColumn size

  • Thread starter Thread starter Kari Lappalainen
  • Start date Start date
K

Kari Lappalainen

Hi everybody!

Do someone know the easiest way to obtain the datacolumn size in code (I
mean the size that
you define creating a text field in a table)? In VB6 you could get it by
means of Recordset.Field.
DefinedSize property. I have been searchin for something similar in ADO.NET
but without luck.

Thanks beforehand
 
For SQL server you should use sp_columns.
Or sp_help.
The Ado.Net catalog information part is not very implemented/working...
This method will work for sure...
 
Kari:

Are you looking for columns in general or just Text Columns? Also, is what
you're looking for the Schema information, i.e. the size of the column in
the db? If so, what back end DB are you using?
 
Back
Top