Solved

Count using DataTable

Posted on 2012-12-28
2
307 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 500 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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

743 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

14 Experts available now in Live!

Get 1:1 Help Now