how to get fields tables of an acces db into a list box?`
<p>need to create a form in which i hav to browse and open mdb files ---> i did this part usin oprnfile dialogue! </p>

<p>private void button1_Click(object sender, EventArgs e)
{</p>

<p>OpenFileDialog oDlg = new OpenFileDialog();
oDlg.Title = </p>

<p>"Select MDB";
oDlg.Filter = </p>

<p>"MDB (<em>.Mdb)|</em>.mdb";
oDlg.RestoreDirectory = </p>

<p>true;</p>

<p>string dir = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
oDlg.InitialDirectory = dir;</p>

<p>DialogResult result = oDlg.ShowDialog();</p>

<p>if (result == DialogResult.OK)
{</p>

<p>textBox1.Text = oDlg.FileName.ToString();</p>

<p>}</p>

<p>string strFileName = oDlg.FileName.ToString();</p>

<p>OleDbConnection cn = new OleDbConnection();</p>

<p>DataTable schemaTable;
cn.ConnectionString = </p>

<p>"Provider=Microsoft.Jet.OLEDB.4.0;Mode=Share Deny None;Data Source="+strFileName;
cn.Open();</p>

<p>schemaTable = cn.GetOleDbSchemaTable(</p>

<p>OleDbSchemaGuid.Tables,</p>

<p>new Object[] { null, null, null, "TABLE" });</p>

<p>//List the table name from each row in the schema table.</p>

<p>for (int i = 0; i &lt; schemaTable.Rows.Count; i++)
{</p>

<p>strTableName = schemaTable.Rows[i].ItemArray[2].ToString();</p>

<p>listBox1.Items.Add(strTableName);</p>

<p>}</p>

<p>//Explicitly close - don't wait on garbage collection.</p>

<p>cn.Close();</p>

<p>}</p>

<p>this is my code so far!!!</p>

<p>now i need to make 3 list boxes!!</p>

<p>1st one to display the table names of the db&lt;-----done till here!!!! </p>

<p>2nd to to display field names when clicked on table name!!!---> to b done! 
3rd to display attributes on fiels on clickin on it!!!---> to b done!</p>

<p>v can edit the attribute values and on clickin of save button it should update the database!!!</p>
