The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
Count using DataTable
Hi,
I am working on ASP.net4.0 using C#
I have DataTable, I want another DataTable from my existing DataTable where I can get a count based on:
- Status row in DataTable
- another DataTable having count based on "Owner" and Priority
My DataTable has following rows:
Application
Ref No
Title
Owner
By
Priority
Creation Date
Required Date
Status
Last Updated Date
Remarks
Please suggest
I am working on ASP.net4.0 using C#
I have DataTable, I want another DataTable from my existing DataTable where I can get a count based on:
- Status row in DataTable
- another DataTable having count based on "Owner" and Priority
My DataTable has following rows:
Application
Ref No
Title
Owner
By
Priority
Creation Date
Required Date
Status
Last Updated Date
Remarks
Please suggest
Asked:
1 Solution
Without more detail its difficult, but check out the DataTable.Compute() method:
http://msdn.microsoft.com/en-us/library/system.data.datatable.compute.aspx
http://msdn.microsoft.com/en-us/library/system.data.datatable.compute.aspx
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
Can you be more specific with your question?
Are you looking to extract the values from the exisiting DataTable and create a new DataTable with that?