Get distinct values from a column in a datatable

[jvb]

I am trying to find a way, other than iterating through every row or
requerring the database, to get the distinct values from a column in a
datatable.

Any help would be appreciated.

Thanks.

[AMDRIT]

You will have to iterate over the rows so that you may compare for distinct
values. However, the logic may be prepared generically.

Each datatable has a getenumerable method. internally, it loops over the
list. You could create a generic GetDistinctEnum erable and pass in the
datatable's enumerable. Perhaps you could then bind your data list repeater
or datagrid to the result set.


"jvb" <go*****@gmail. com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

I am trying to find a way, other than iterating through every row or
requerring the database, to get the distinct values from a column in a
datatable.

Any help would be appreciated.

Thanks.

[W.G. Ryan - MVP]

I don't think you can get around iteration in one form or another, but this
should help http://support.microsoft.com/default...b;en-us;326176

"jvb" <go*****@gmail. com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

I am trying to find a way, other than iterating through every row or
requerring the database, to get the distinct values from a column in a
datatable.

Any help would be appreciated.

Thanks.