combine two datatables

Question

0.00/5 (No votes)

See more:

i have two datatables in dataset ds.
in table[0] i have columns mnth, amount,month
it looks a like

HTML

mnth   amount1  month
 9      1500    sep
10     1700    oct
11     2200    nov

and in table[1] i have columns mnth,amount
it looks a like

HTML

mnth   amount2
4       1000 
7       1500
9       800

now i want to merge tables and want to diplay such like this

HTML

month amount1  amount2    
4               1000
7               1500
9       1500     800
10      1700
11      2200

here both table's amount is irrelevant.. i want that both the amount should display month wise.. if both tables have amount in 9th month then there should be only one row..

i tried merge() function but it didn't worked.
plz help me out..

Posted 29-Jan-12 22:40pm

Member 8589824

Updated 30-Jan-12 2:48am

Anuja Pawar Indore

v2

Add a Solution

Comments

Anuja Pawar Indore 30-Jan-12 8:48am

formatting done

5 solutions

Add a Solution

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

uspatel · Answer 1 · 2012-01-29T22:42:00

Solution 1

See this thread
http://stackoverflow.com/questions/285474/merge-2-datatables-and-store-in-a-new-one[^]

Posted 29-Jan-12 22:42pm

uspatel

Comments

Amir Mahfoozi 30-Jan-12 5:47am

+5

uspatel 30-Jan-12 5:48am

Thanks Amir....

Rajesh Anuhya · Answer 2 · 2012-01-29T22:43:00

Solution 2

Try

dt.Merge()

Thanks
--RA

Posted 29-Jan-12 22:43pm

Rajesh Anuhya

testy_proconsul · Answer 3 · 2012-01-29T22:47:00

Solution 3

DataTable.Merge is not the right method, because merge processes data on row base. Instead of merge use LINQ if possible:

http://stackoverflow.com/questions/656013/linq-join-2-datatables-wildcard[^]

Posted 29-Jan-12 22:47pm

testy_proconsul

Comments

Member 8589824 30-Jan-12 4:56am

okay.. but how can i join tables in c#?? this ans is for linq

Member 8589824 · Answer 4 · 2012-01-30T00:32:00

Solution 4

i have solved this using this link
http://social.msdn.microsoft.com/Forums/en/adodotnetdataset/thread/d3ab19fd-6094-42e9-aa23-4e5a653d8422[^]

Posted 30-Jan-12 0:32am

Member 8589824

Member 8589824 · Answer 5 · 2012-01-30T01:05:00

Solution 5

http://social.msdn.microsoft.com/Forums/en/adodotnetdataset/thread/d3ab19fd-6094-42e9-aa23-4e5a653d8422[^]

Posted 30-Jan-12 1:05am

Member 8589824

combine two datatables

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

combine two datatables

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us