Retrieving all tables names from Access Databse.

Question

I want to retrieve all the table names from a access database to check that the table that should be there are there. I also would like to retrieve all the column names foreach table to make sure that is correct.

I have been searching for about an hour now and I can't find what I'm specifically looking for... or maybe I'm just using the wrong key words. ;)

Anyway. Please help.

Thanks

Answer 1

Use this code in selected index changed event of combobox

 

for(int i=0; i<dataGridView1.Rows.Count;i++)

{

   dataGridView1.Rows[i].Cells[6].Value=comboBox1.SelectedValue;

}

 

 

Answer 2

Hii Ranjit,

thank you for your reply. there is just one little change I have to do that is instead of 'combobox1.SelectedValue' I added 'SelectedItem'. it is because when I used SelectedValue, and changed the value from combobox, all the values went blank...

 

'combobox1.text' also works.

 

anyway, my problem is solved.

thank you once again.

 

Mayank Jani