M Miha Markic Dec 16, 2003 #4 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.
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.
T ToddT Dec 16, 2003 #5 how do you get column info (e.g., names, data type, constraints) on a per table basis?
M Miha Markic Dec 16, 2003 #6 Hi ToddT, Just change Tables to Columns oleDbConnection1.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] {}); Click to expand... Click to expand... -- Miha Markic - RightHand .NET consulting & development miha at rthand com ToddT said: 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. Click to expand... Click to expand...
Hi ToddT, Just change Tables to Columns oleDbConnection1.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] {}); Click to expand... Click to expand... -- Miha Markic - RightHand .NET consulting & development miha at rthand com ToddT said: 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. Click to expand... Click to expand...
T ToddT Dec 16, 2003 #7 i guess that's easy enough. thx. Hi ToddT, Just change Tables to Columns oleDbConnection1.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] {}); Click to expand... Click to expand... Click to expand...
i guess that's easy enough. thx. Hi ToddT, Just change Tables to Columns oleDbConnection1.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] {}); Click to expand... Click to expand... Click to expand...
