Need to access multiple tables

[greymonkey]

Hi,

I have a MsAccess DB with two tables in (Table A, Table B) and I am trying to have two drop down boxes in my vb.net application showing the date from each table.

I have got as far as setting up the connection with the database and setting the OleDbDataAdapter and the DataSet.

this all works fine for one table and i am able to read and write to it. The problem starts when I get to the second combo box - It is not showing any data or updating with the Access Database.


Does anyone have any Idea how to overcome this issue.

Thanks,

 

[mansii]

Are there any data to fill into the second combo?
Or perhaps you could show us some of the codes?

Regards,
mansii

 

[steve1rm]

We need to see your code or we cannot really understand what you have done.

Are you sure you are using the right code to populate the 2nd combo box.

Steve

 

[greymonkey]

All sorted - Left out the AleDataAdapter.Fill() command on the form_load for the second data set.

Cheers.