Listing all table names

Question

Hi My access db has 70 table and i want to list all table's name in a dropdown control. How can i do that?

Kirtan Patel · Answer

Friend Here I coded How to List Tables please check  Do you like this answer  if it helps you :) using System.Data.Common; using System.Data.OleDb; private void button1_Click( object sender EventArgs e) { DbProviderFactory factory = DbProviderFactories .GetFactory( System.Data.OleDb ); OleDbConnection con = new OleDbConnection ( @Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\school.mdb;Persist Security Info=True ); DataTable dt = new DataTable (); //Get Only User Created Tables Not System Tables string [] Restrictions = new string [4]; Restrictions[3] = Table ; con.Open(); dt = con.GetSchema( Tables  Restrictions); int i = 0; comboBox1.Items.Clear(); foreach ( DataRow r in dt.Rows) { comboBox1.Items.Add(r[2].ToString()); } }

Master Billa · Answer

Hi You use this code private void LoadAllTables() { // Microsoft Access provider factory DbProviderFactory factory = DbProviderFactories.GetFactory(  System.Data.OleDb  ); DataTable userTables = null ; using (DbConnection connection = factory.CreateConnection()) { // c:	est	est.mdb connection.ConnectionString =  Provider=Microsoft .Jet.OLEDB.4.0;Data Source=c:\test\test.mdb  ; // We only want user tables not system tables string [] restrictions = new string [ 4 ]; restrictions[ 3 ] =  Table  ; connection.Open(); // Get list of user tables userTables = connection.GetSchema(  Tables   restrictions); } // Add list of table names to listBox for ( int i = 0 ; i userTables.Rows.Count; i ++ ) listBox1.Items.Add(userTables.Rows[i][ 2 ].ToString()); } thank you

theLizard · Answer

If you know sql this returns just the table names in an Access DB. SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name]1) '~') AND (Left$([Name]4) 'Msys') AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name;;