Solved

Count using DataTable

Posted on 2012-12-28
2
315 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

617 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