How to retrieve db table field's max length by using ADO.NET?

[Jacky]

How to retrieve db table field's max length by using
ADO.NET?

Please advise.

Thanks

 

[Ken Cox [Microsoft MVP]]

I suspect you need to use ADOX for that kind of task.

There's an article here that demonstrates using ADOX with .NET.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;317867

 

[Chris Botha]

Not really, I think the documentation just stinks around this area. You can
use the OleDbDataAdapter. The select string something like "Select * from
MyTable", and then call adapter.FillSchema into a DataTable. It puts the
information into an empty table (no rows), but the Columns contains all the
info needed, length, null-able, primary key, etc.

 

[Ken Cox [Microsoft MVP]]

Thanks Chris. I stand corrected.

Not really, I think the documentation just stinks around this area. You can
use the OleDbDataAdapter. The select string something like "Select * from
MyTable", and then call adapter.FillSchema into a DataTable. It puts the
information into an empty table (no rows), but the Columns contains all the
info needed, length, null-able, primary key, etc.

 

[Ken Cox [Microsoft MVP]]

Ken,

You're back!

Doppleganger