How to add 3 dataset values in 1 dataset

Question

0.00/5 (No votes)

See more:

Hello Friends,

Please help me,

I have three datasets and i want to bind three dataset values into one dataset and bind this dataset to gridview.

Give me any solution.

Posted 9-Aug-13 0:15am

nita kadam

Add a Solution

2 solutions

Solution 2

You can use Merge function if all the dataset are identical in-terms of column Name & No. of column

Like
ds1.merge(ds2)

Posted 9-Aug-13 0:25am

Mukesh Ghosh

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)

Gautam Raithatha · Accepted Answer · 2013-08-09T00:23:00

Solution 1

For combining data from multiple datasets, all datasets must have same structure.

C#

DataSet ds1 = new DataSet();
DataSet ds2 = new DataSet();
DataSet ds3 = new DataSet();

//Code to fill three datasets here

DataSet ds = new DataSet();
DataTable dt = ds1.Tables[0].Clone();
ds.Tables.Add(dt);

foreach (DataRow dr in ds1.Tables[0].Rows)
    ds.Tables[0].ImportRow(dr);

foreach (DataRow dr in ds2.Tables[0].Rows)
    ds.Tables[0].ImportRow(dr);

foreach (DataRow dr in ds3.Tables[0].Rows)
    ds.Tables[0].ImportRow(dr);

//ds will have data of first datatable of all three datasets ds1,ds2,ds3. Bind ds to gridview

Posted 9-Aug-13 0:23am

Gautam Raithatha

Updated 9-Aug-13 1:36am

v3

Comments

nita kadam 9-Aug-13 7:27am

ds.Tables[0].ImportRow(dr); gets error like cannot fine table 0

Gautam Raithatha 9-Aug-13 7:39am

yes you need to create datatable with same structure as three dataset's datatables and add it to ds.

check updated solution.

nita kadam 9-Aug-13 8:09am

A DataTable named 'Table' already belongs to this DataSet i got this error for second dataset.

nita kadam 9-Aug-13 8:11am

A DataTable named 'Table' already belongs to this DataSet, I got error like this in second dataset

Gautam Raithatha 9-Aug-13 8:13am

you don't have to add datatable dt to dataset ds for three times. just add dt to ds once. Check above solution.

nita kadam 9-Aug-13 10:26am

but i have for loop and if i come second time then display error like- table already belongs to this dataset..

Gautam Raithatha 9-Aug-13 11:06am

can u plz post your code?

Gautam Raithatha 9-Aug-13 11:08am

u can use different table names in each loop like below:

for (int i = 0; i < 5; i++)
{
DataTable dt = new DataTable("table" + i.ToString());
}