// Produces a new table containing unique values for data in the specified columns. DataTable dt; dt = this.myDataTable .DefaultView.ToTable(true, "location");The "true" parameter tells it that you want distinct locations.
SELECT location from myDataTable GROUP BY location>