Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Repartition from a column
Message
From
24/10/2006 15:44:41
 
 
To
24/10/2006 02:10:01
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01164033
Message ID:
01164170
Views:
12
This message has been marked as the solution to the initial question of the thread.
Michel,

I'd use the .FindRows() method of a DataView. It requires that the DataView be sorted (use the DefaultView of your Table). The method returns a collection of DataRowView and you can then count using the DataRowView.Length property.

~~Bonnie




>I have a dataset which includes a table and several columns under. On one of those columns, I need to get the repartition. Presently, I have in a datatable with all the unique values of that column. Now, I need to scan that datatable and for each column, I need to get the count in the dataset. What would be the simplest way to achieve that?
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform