oops..sorry. Towards the end of the day in office..you know how that goes :)
Anyway, there is no direct way of filtering out distinct values from a
datatable in a dataset. Here are a couple of options you have:
1. You could create a new DataColumn and create a unique constraint on it
and then copy the contents from your original data column to this new
column. It'll throw up an error when you try to enter duplicate values. You
can suppress the error so that you don't end up with a chain of exceptions.
2. here's another solution:
http://support.microsoft.com/default...b;EN-US;325684
hope that helps..
Imran.
"rodchar" <ro*****@discussions.microsoft.com> wrote in message
news:9F**********************************@microsof t.com...
But where would I put that select statement to pull it out of an already
populated database?