John,

This returns a DataTable rather than a DataRow, but I think it might be what you want:

	// 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.

~~Bonnie




>Hi,
>How could I retrieve datarow as sql below from datatable which its data still in datatable but not yet saved in database?
>
>

SELECT location from myDataTable GROUP BY location

>
>Thank you