How do I display unique items in Repeater?

No code posted ;)

oops

        foreach (DataRow row in dt.Rows)
        {
            intCountBadCategories = intCountBadCategories + 1;

            // Check to see if this is a valid category
            if (IsValidCategory(row["Category"].ToString()) == false)
            {
                // Add to Repeater
                DataRow newRow3 = dt3.NewRow();
                newRow3["Category"] = row["Category"].ToString();
                dt3.Rows.Add(newRow3);
            }
        }

Select allOpen in new window

If dt is populated from the database, the best place would be to use a SELECT DISTINCT in the code loading data into the datatable, dt.

otherwise, check if the value already exists in dt3. Something like:

if (IsValidCategory(row["Category"].ToString()) == false && dt3.Select("Category = '" + row["Category"].ToString().Replace("'","''") + "'").Length = 0)

Select allOpen in new window