How to get Distinct rows from dataset

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

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.