المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : how to get tables of an access db into a list box using c#?



C# Programming
08-07-2009, 09:46 AM
hi evry1!

i needed to create a form in which i hav to browse and open mdb files ---> i did this part usin oprnfile dialogue!

private void button1_Click(object sender, EventArgs e)

{

OpenFileDialog oDlg = new OpenFileDialog();

oDlg.Title = "Select MDB";

oDlg.Filter = "MDB (*.Mdb)|*.mdb";

oDlg.RestoreDirectory = true;

string dir = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);

oDlg.InitialDirectory = dir;

DialogResult result = oDlg.ShowDialog();

if (result == DialogResult.OK)

{

textBox1.Text = oDlg.FileName.ToString();

}

}



this is my code so far!!!



now i need to make 3 list boxes!!

1st one to display the table names of the db!

2nd to to display field names when clicked on table name!!!

3rd to display attributes on fiels on clickin on it!

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



pls help