Length of a column of an SQL Table

[Sebastian T Xavier]

Hello... How can I get the Length of a column of an sql table from my C# code.... In my application I am using databound controls. I want to know the length of the field in UI. any help would be appreciated... Thanks

Sebastian

[Adam R Harris]

Query the schema of the table. http://www.mayvelous.com/2008/02/13/listing-tables-and-columns-in-sql-2005-using-information-schema/[^] The info in this article is specific to sql 2005, but it should still apply to other versions.

If at first you don't succeed ... post it on The Code Project and Pray.

[PIEBALDconsult]

See this[^] recent thread.

[Sebastian T Xavier]

Thanks a lot