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;";

Listing all table names

Answers (3)