Datatable-rowwise and columnwise calculations

Question

Hi all...

I have a datatable as follows -

SrNo	Location	Total	Pending(A)	New(B)	Updated(C)	Remarks
1	Assam	4	1	3	5	Test
2	Bihar	7	2	4	6	Test

Now, I want the output as follows -

SrNo	Location	Total	A	B	C	D=A+B-C	Remarks
						1+3-5=-1
						2+4-6=0

And in the last row, I need column-wise total -

Total of Columns - Total, A, B,C,D.

Please guide...

Bhushan Bhasme · Answer

you need to loop through your datatable foreach (DataRow dtRow in dtTable.Rows) { dtrow[D]=(Convert.ToInt32(dtrow[A])+Convert.ToInt32(dtRow[b])+Convert.Toint32(dtRow[c])).Tostring(); } Here You Will GEt all column addition in d column int a=0; foreach(DataColumn dc in dtTable.Columns) { a= convert.Toint32(dc[D])+a; } In a You Will Get columnwise Addition Hope this Will help You

Riddhi Valecha · Answer

Hi.. I have to do it in front-end and not in query... How to do it in datatable in asp.net c# ??

Khan Abrar Ahmed · Answer

Hi try like this select *(Pending+New-updated) as Total from @test