DataSet filtering

[Tim Smith]

Hi,

If I retreive a set of records from my database e.g.

NAME GROUP
John Beetles
John Sting
John Queen
Bob Brittany

and I have in a dataset. If I want to display in a list

Bob
John

is there an easy way to do a operation such as SELECT DISTINCT NAME FROM DATASET
so that I can filter it without doing another database call?

thanks

Tim

 

[William Ryan eMVP]

http://support.microsoft.com/default.aspx?scid=kb;EN-US;326176

--
W.G. Ryan MVP Windows - Embedded

http://forums.devbuzz.com
http://www.knowdotnet.com/dataaccess.html
http://www.msmvps.com/williamryan/