Distinct/Group by

[Mike]

Hi,

I have a dataset and I would like to create a dataview or another dataset with only the unique values of one of the fields of the original dataset. I would like to avoid querying the DBMS again. Is there a possibility to do so?

Thanks.
Mike

 

[Val Mazur]

Hi,

Check next KB with an example

http://support.microsoft.com/default.aspx?scid=kb;en-us;325684&Product=adonet

--
Val Mazur
Microsoft MVP



Hi,

I have a dataset and I would like to create a dataview or another dataset with only the unique values of one of the fields of the original dataset. I would like to avoid querying the DBMS again. Is there a possibility to do so?

Thanks.
Mike

 

[William Ryan eMVP]

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

--
W.G. Ryan MVP Windows - Embedded

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups

Hi,

I have a dataset and I would like to create a dataview or another dataset
with only the unique values of one of the fields of the original dataset. I
would like to avoid querying the DBMS again. Is there a possibility to do
so?

Thanks.
Mike