DataColumn size

[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

 

[Cor Ligthert [MVP]]

Kari,

Would you believe this. MaxLength

http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.maxlength.aspx

I hope this helps,

Cor

 

[Guest]

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...

 

[W.G. Ryan - MVP]

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?