how to display all the table name(in database) in a page?

[netbee]

thanks!
netbee

 

[Miha Markic]

Hi,

What do you want to display? Table name? Table content?

 

[netbee]

haha, just for study, I want to display Table name.

 

[Miha Markic]

Try this:
oleDbConnection1.Open();

DataTable schemaTable =

oleDbConnection1.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,

new object[] {});

oleDbConnection1.Close();

You'll get a DataTable full of table entries.

You can use it as a datasource, perhaps for DataGrid.

 

[ToddT]

how do you get column info (e.g., names, data type, constraints) on a
per table basis?

 

[Miha Markic]

Hi ToddT,

Just change Tables to Columns

oleDbConnection1.GetOleDbSchemaTable(OleDbSchemaGuid.Columns,

new object[] {});

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com

how do you get column info (e.g., names, data type, constraints) on a
per table basis?

Try this:
oleDbConnection1.Open();

DataTable schemaTable =

oleDbConnection1.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,

new object[] {});

oleDbConnection1.Close();

You'll get a DataTable full of table entries.

You can use it as a datasource, perhaps for DataGrid.

 

[ToddT]

i guess that's easy enough. thx.

Hi ToddT,

Just change Tables to Columns

oleDbConnection1.GetOleDbSchemaTable(OleDbSchemaGuid.Columns,

new object[] {});