Count using DataTable

tia_kamakshi
tia_kamakshi used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Roopesh ReddyIT Analyst
Top Expert 2012

Commented:
Hi,

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?
Without more detail its difficult, but check out the DataTable.Compute() method:

http://msdn.microsoft.com/en-us/library/system.data.datatable.compute.aspx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial