how select distinct records from dataset

You can use linq to leverage that, if you still don't use LINQ I think it's time to use it ;-)

var query = (
from row in yourdataset.tables["tableName"].AsEnumerable()
select row.Field("FieldName")).Distinct();

foreach (var name in query) {
Console.WriteLine(name);
}