How Do I Use Dataset To Merge Two Table Into One Another Table

Question

0.00/5 (No votes)

See more:

use of dataset to merge two table and store into another table .

and also view the new updated(another) table in gridview

Posted 8-Jul-14 0:48am

10923679

Add a Solution

Comments

George Jonsson 8-Jul-14 7:00am

Do you mean that you have two data tables in a dataset and want to merge both into a third table?
IS the third table inside or outside the dataset?

10923679 9-Jul-14 1:16am

i have two tables in database.
i have to merge both and make it one and store that new updated data to another table in database.

for eg
table 1-

slno name roll
1 a 1001
2 c 1254

table 2-

slno roll age
1 1001 20
2 1254 15

table 3-(new table)

slno name roll age
1 a 1001 20
2 c 1254 10 in another new table in databse

now i guess u have an idea..
can u help me to implement in asp.net

George Jonsson 9-Jul-14 2:06am

Next time post information like this in your original question.
Much easier to help you with relevant info at hand.

2 solutions

Add a Solution

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

DamithSL · Accepted Answer · 2014-07-08T01:01:00

Solution 1

C#

DataTable dtAll = ds.Tables[0].Copy();
dtAll.Merge(ds.Tables[1]);
ds.Tables.Add(dtAll);
gridview1.DataSource =ds.Tables[2];
gridview1.DataBind();

Posted 8-Jul-14 1:01am

DamithSL

Updated 8-Jul-14 1:03am

v2

kedar001 · Accepted Answer · 2014-07-08T01:06:00

Solution 2

check this ..

Merge Dataset[^]

Merging dataset[^]

Posted 8-Jul-14 1:06am

kedar001

How Do I Use Dataset To Merge Two Table Into One Another Table

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How Do I Use Dataset To Merge Two Table Into One Another Table

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us