Datatable-rowwise and columnwise calculations

Riddhi Valecha

11y1.9k.NET

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...

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhushan Bhasme11y ago

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 Valecha11y ago
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 Ahmed11y ago
Hi try like this

select *,(Pending+New-updated) as Total from @test