How to print out the summation of a column

Fares Ayyad

10y902.NET

Hello everyone,

I write a query that shows multiple values in multiple columns from multiple:

Select i.cdin_cdindexid as cntdp, coalesce((i.cdin_NoofPackages),0) as sqty,coalesce((i.cdin_WT),0) as swt ,coalesce((i.cdin_volumewt),0) as svwt ,coalesce((i.cdin_MortgageAmount),0) as samt
from cdindex i inner join company c on i.cdin_CompanyId =c.Comp_CompanyId inner join Territories t on i.cdin_Secterr =t.Terr_TerritoryID left outer join Performainv p on i.cdin_cdindexid=p.pinv_cdindexid
where(cdin_deleted Is null And c.comp_deleted Is null And t.Terr_Deleted Is null and p.pinv_deleted is null and (p.pinv_InvoiceProperty ='01' or p.pinv_InvoiceProperty is null ) and (p.pinv_Status in('Draft','Posted') or p.pinv_status is null) )
and i.cdin_startunstufdate between '2016-07-01'and '2016-07-11'
group by i.cdin_cdindexid,i.cdin_NoofPackages,i.cdin_WT,i.cdin_volumewt ,i.cdin_MortgageAmount

And this is the result:

my question is how to get the summation of one column an print it in asp label tool.

for Example i want to get the summation of cntdp and represent the result in asp label using C#, if it's possible.

Thank You All.

with my respect.

4 Replies

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

Midhun Tp10y ago
Accepted answer
Hi,
You can get the sum of a datatable column with below code -
object sum = dt.Compute("SUM(cntdp)", "");
+2
Midhun Tp10y ago
Hi,

Happy to see, it solved your problem.
To get count of distinct values in a row, you can use below code -
int countDepInvo = table.AsDataView().ToTable(true, "depInvo").Rows.Count;

Please mark it as answer, if the solution was helpful to you as it helps others with same problem!
+1
Fares Ayyad10y ago
Midhun T P
Thank you, this solved the problem but
i want to retrieve count of a column with distinct records how to get that.
i mean can i do this by c# or by sql statement like.
I mean can i get DISTINCT values from this C# statement:
countDepInvo=table.Compute("Count(depInvo)","");
0
Nitin Sontakke10y ago
If the above query is part of stored procedure, you can have another query below this and handle multiple result sets in your data access layer in C#.
If you are using SQL Server 2012 and above, you can use advance windowing functions to get the sum in the same row and pick the value only from the last row.
Or make a separate db call just for the sum.
0