Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Count using DataTable

Posted on 2012-12-28
2
Medium Priority
?
323 Views
Last Modified: 2012-12-29
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
0
Comment
Question by:tia_kamakshi
2 Comments
 
LVL 23

Expert Comment

by:Roopesh Reddy
ID: 38728960
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?
0
 
LVL 25

Accepted Solution

by:
Rouchie earned 2000 total points
ID: 38729193
Without more detail its difficult, but check out the DataTable.Compute() method:

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Loops Section Overview
Suggested Courses

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question