Count using DataTable

Posted on 2012-12-28
Last Modified: 2012-12-29

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:

Ref No
Creation Date
Required Date
Last Updated Date

Please suggest
Question by:tia_kamakshi
LVL 23

Expert Comment

by:Roopesh Reddy
ID: 38728960

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?
LVL 25

Accepted Solution

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Problem of RegEx to match the first occurence of 10 35
Word Directory is not in the drop down list 4 25
System.Speech 2 11
Code works but it's slow 24 30
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now