How to get Distinct rows from dataset

[kumar_1981]

Hi

i am having a dataset with a Table which contains repeated values in rows.

i need to get Distinct field value

like

my DS contains 5 records

with


FileLocation :C:\\test

i should get only one record with FileLocation :C:\\test

thanks
Vinay Kumar

[jmcilhinney]

If you want distinct rows then you need to do that with your SQL code when you retrieve the data in the first place. Once the data is in a DataTable it's too late. There is no inbuilt way to filter out duplicate rows in a DataTable, so you'd have to write code to loop and test.