While I not understand with your last part of your sentence is the answer on
the first part, yes you can have more datatables in a dataset. That is why
it exist, it holds datatables and the relations between them.
When you can explain something more what you mean with the dataadapter
sentence than maybe can I as well answer that question.
I have an oledbdataadapter that I am using to communicate with an Access
database. The problem that I am having is when I generate the dataset from
the oledbdataadapter. I have two tables is the database, Customers &
Employees, the only way that I know how to get both table in the dataset is
to create an oledbdataadapter for each table. Is this the correct method?
When you configure the dataadapter you have to tell the query what to select.
My sql knowledge is very limited. Is there someway in the query builder to
tell it that I want to select information from two seperate tables and keep
them seperate. What I am trying to say is that when I generate the dataset I
want two tables in it. I do not want one table with all the information from
both tables in the database.
Cor,
Thanks for the help. I just figured it out. I opened the dataset1.xsd and
switched to the servers by the toolbox and drug the other table into the
dataset.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
