How can i Sum value from Data Table Distinct Value

Feroz Khan

Dear,

i using C# language for showing txt file data in Datatable and its showing like beow also.

now if column (store0) if there is value distinct should be just one and second coluumn should be count the distinct value.

for view i am using this code.

DataView view = new DataView(dt);

and Distince i am using below code.

DataTable distinctValues = view.ToTable(true, "Store0", "Store1");

and report showing like ok but in second column showing value ( 1 ) this should be 3, should be sum the distinct value. please i need your help for how can i sum disticnt values.

2 Replies

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

Ravi Kiran Chanduri8y ago
Hello Feroz,

As Shwetha said, you can apply logic in c# code. If you are fetching data from the database, it is better to handle it on the script side itself.
Select Store0, Count(Store1) from table_name
group by Store0.
database side coding is very simpler than c# coding in such situations.
Shweta Lodha8y ago
Hi Feroz,
You can try something like this:

var result= dt.AsEnumerable()
.GroupBy(row=> row.Field("Store0"))
.Select(r=> new
{
Store0 = r.Key,
Store1 = r.Sum(row=>row.Field("Store1")
});

Below code may not be slight syntactically incorrect as I don't have editor handy to verify this. But this will surely give you an idea.