T
Timothy Parez
Hello,
I have a DataSet with lots of data in it,
there is no database just the DataSet.
In the DataTable contained by the DataSet
there is a field Category. I would like to get the different Categories
out of that DataSet, so no duplicates.
With SQL this would be very easy,
SELECT DISTINCT or Group By should do the job,
but I don't suppose you can run SQL against a dataset can you ?
Is there another way to select distinct values from a column in a
DataTable ?
If it held
A
B
B
A
C
E
F
A
G
F
G
H
I would only like to get
A
B
C
E
F
G
H
back.
Thnx.
I have a DataSet with lots of data in it,
there is no database just the DataSet.
In the DataTable contained by the DataSet
there is a field Category. I would like to get the different Categories
out of that DataSet, so no duplicates.
With SQL this would be very easy,
SELECT DISTINCT or Group By should do the job,
but I don't suppose you can run SQL against a dataset can you ?
Is there another way to select distinct values from a column in a
DataTable ?
If it held
A
B
B
A
C
E
F
A
G
F
G
H
I would only like to get
A
B
C
E
F
G
H
back.
Thnx.