field size of database column

[Saifee]

hi friends,

I have a database table with some columns say name varchar2
(20).
Now i want to get the column data szie i.e 20 in ado.net
how do i get it..pls help

 

[Miha Markic]

Hi,

OleDbConnection.GetOleDbSchemaTable will provide the info.
The code below will give you info for column COLUMNNAME:
DataTable table =
oleDbConnection1.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new
object[]{null, null, null, "COLUMNNAME"});