Populating dataset with multiple data tables

Question

4.00/5 (1 vote)

See more:

Hi Experts,

I have a problem in populating the second table in a data set.

Here is my code

C#

da = new oledataadapter(query_string,con)
ds = new dataset


da.fill(ds,"table_1")  --- Here data is getting populated

Again I have

query_string = "Select * from different_table"
cmd.CommandText = query_string
cmd = new oledbcommand(query_string,con)

da.fill(ds,"table_2")

- Here if I see in dataset visualizer, it shows 2 tables but, when select table_2 it is not showing the data belong to table_2 and shows the table_1 data only.

Any idea? where am I going wrong.

Cheers
Anand

Posted 12-Jul-12 21:01pm

Anand Rangaraju

Updated 12-Jul-12 21:08pm

Sander Rossel

v2

Add a Solution

Comments

Sander Rossel 13-Jul-12 3:08am

Added a code block for readability.

3 solutions

Solution 1

Instead of filling a DataSet, use DataAdapter.Fill on a DataTable instead. Then attach that to your DataSet.

Posted 12-Jul-12 21:05pm

OriginalGriff

Comments

Sander Rossel 13-Jul-12 3:07am

My 5. Things don't always have to be that complicated :)

OriginalGriff 13-Jul-12 3:16am

I like simple! :laugh:

Sander Rossel 13-Jul-12 3:50am

KISS! :)

Solution 3

First of all,

Sorry for the delay in reply [ As I was out of station ]

The actual problem was data adapter need to be instantiated again for every when the query is changed. i.e. I just changed as below

VB

da = New OleDbDataAdapter(wsql_query, con)
                   da.Fill(ds, "table2")

That's it, it is working fine.

But, As Amit told, it would be better to put it in procedure so that every thing gets done in one trip.

Thanks Again Amit for your suggestion and links provided.

Cheers
Anand

Posted 19-Jul-12 0:24am

Anand Rangaraju

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Amy · Accepted Answer · 2012-07-12T21:07:00

Hi,
Can't you have a procedure in OleDBCommand?
Create a procedure and execute it. This will help you to prevent database round-trips. And also decrease the network traffic.
Try this:

C#

cmd = new oledbcommand("ProcedureName",con)
da.fill(ds)
ds.Tables[0].TableName="tbl1";
ds.Tables[0].TableName="tbl2";

To learn how to create procedures in Access, refer the links below:
http://msdn.microsoft.com/en-us/library/bb177892%28v=office.12%29.aspx[^]
http://www.vbdotnetforums.com/ms-access/31267-how-create-stored-procedure-ms-access.html[^]
http://stackoverflow.com/questions/3287545/how-do-i-make-a-stored-procedure-in-ms-access[^]
http://forums.databasejournal.com/showthread.php?31544-Create-Store-Procedure-MS-Access[^]

All the best.
--Amit