How to Sum up two datatable same Column ?

Question

Dear Friends  I had a situation  Like i wanna to sum up two datatable same column... i shown the data and desired data .. If anybody Possible ..Guide me Datatable :1 Sno Agent Id Amount 1 AG121 400 2 AG125 300 3 AG127 200 Datatable :2 Sno Agent Id Amount 1 AG121 100 2 AG125 200 3 AG127 100 4 AG129 400 My desired OutPut Is SNo Agent Id Amount 1 AG121 500 2 AG125 500 3 AG127 300 4 AG129 400 This what i am really want to do ... Thanks in advance - KARTHIK

Sanjeeb Lenka · Answer

hi you can do this using linq check this sample code: DataTable dt = new DataTable(); dt.Columns.Add(sno typeof(int)); dt.Columns.Add(AgentId typeof(string)); dt.Columns.Add(Amount typeof(int)); dt.Rows.Add(1 AG121 400); dt.Rows.Add(2 AG125 300); dt.Rows.Add(3 AG127 200); DataTable dt2 = new DataTable(); dt2.Columns.Add(sno typeof(int)); dt2.Columns.Add(AgentId typeof(string)); dt2.Columns.Add(Amount typeof(int)); dt2.Rows.Add(1 AG121 100); dt2.Rows.Add(2 AG125 200); dt2.Rows.Add(3 AG127 100); dt2.Rows.Add(3 AG129 400); var result = from t1 in dt2.AsEnumerable() join t2 in dt.AsEnumerable() on t1[AgentId] equals t2[AgentId] into ds from o in ds.DefaultIfEmpty(null) select new { Sno = t1[sno] AgentId = t1[AgentId] Amount = (int?)((t1 == null) ? 0 : t1[Amount]) + (int?)((o == null) ? 0 : o[Amount]) }; DataTable dt3 = new DataTable(); dt3.Columns.Add(sno typeof(string)); dt3.Columns.Add(AgentId typeof(string)); dt3.Columns.Add(Amount typeof(string)); foreach (var item in result) { dt3.Rows.Add(item.Sno.ToString() item.AgentId.ToString() item.Amount.ToString()); }

Jignesh Trivedi · Answer

hi Is your two table is in different database and server? if yes I think database link can help you. Please read http://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_concepts002.htm hope this will help you.

Prasenjit Dey · Answer

Hi try that select t.AgentIDsum(t.amount+t1.amount) from databasename1.dbo.tablename t inner join databasename2.dbo.tablename t1 ON t1.AgentID=t.AgentID group by t. AgentIDt.amount

venkata kumar · Answer

hi try the fallowing select t.AgentIDsum(t.amount+t1.amount) from databasename1.dbo.tablename t inner join databasename2.dbo.tablename t1 ON t1.AgentID=t.AgentID group by t. AgentIDt.amount

Karthik Che · Answer

Hi  I Have using the Oracle Database.. Two Databases and i had permision I havent use it ..i dont know how to joint two different database table in one query can you say one example for... this is very new concepts for me .. Thanks KARTHIK

Prasenjit Dey · Answer

Hi at first check that is there permission of yours in that 2 databases i.e. have you full access in that two databases. And after that put the database name and after that schema name before the name of the table in that query

Karthik Che · Answer

Hi  If it same db i can able to do as your way  i had those data in different database So i unable to do in that way  Provide me other option to complete that one Thanks KARTHIK

venkata kumar · Answer

hi try the fallowing select t.Agent Idsum(t.amount+t1.amount) from table_1 t inner join table_2 t1 ON t1. Agent Id=t. Agent Id group by t. Agent Idt.amount

Datatable :1
Sno	Agent Id	Amount

1	AG121	400
2	AG125	300
3	AG127	200


Datatable :2

Sno	Agent Id	Amount

1	AG121	100
2	AG125	200
3	AG127	100
4	AG129	400