unfortunately, you can't do a select distinct. the only alternative
i've seen is to loop through the rows and add the columns value to a
hashtable.
Hashtable ht = new Hashtable();
foreach(DataRow dr in table.Rows)
{
if(!ht.Contains(dr["ColumnName"]))
{
ht.Add(dr["ColumnName"], null);
}
}
On Wed, 11 Feb 2004 21:52:33 +0100, "Soren Staun Jorgensen"
<no@spam.com> wrote:
Hi,
How do i get unique values of a specific column in a DataTable - i dont
surpose i ts possible to use something like "select distinct" as in regular
SQL ??
Soren