Running queries/filters on Datasets.

[qwert231]

I am getting XML data into my dataset, but now I want to start creating a report that counts fields (ie. 'there are 20 records that have Pie in the FavDesert field.')

In VBA we had the Count function... anything similar for datasets in VB .Net.

 

[qwert231]

So, does anybody have any info on sorting or counting fields in a dataset?

 

[qwert231]

I have more of a complex request.

I want to get totals from a dataset that looks like this:

recNum    P1   Q1   P2   Q2   P3   Q3...P10   Q10
0002      A    1    K    1
0001      B    1
0004      K    2
0009      A    2    B    1    K    1

Which would result in:
Package Total
A 3
B 2
K 4

I had a real messy query for a similar result in SQL, but I need to get this data from an dataset.

 

[jfrost10]

Why does it have to be a dataset? Something like that would be much better done on sql server or some other RDBMS.

D

 

[qwert231]

This is for a client application that may not have a RDBMS.

 

[qwert231]

Duh, I'm sorry. I just need to send a database file along and then I can use Jet... I'm sorry... I was silly. I was thinking that I needed to have Access to be able to use a database file.