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.
Course Of The Month
9 days, left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Count using DataTable
Posted on 2012-12-28
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
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
[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
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?
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
http://msdn.microsoft.com/en-us/library/system.data.datatable.compute.aspx
Featured Post
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…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month9 days, left to enroll
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.