How to select distinct rows in a datatable and store into an array

c# select datatable distinct
Ahmed Atia picture Ahmed Atia · Jul 29, 2009 · Viewed 610.9k times · Source

I have a dataset objds. objds contains a table named Table1. Table1 contains column named ProcessName. This ProcessName contains repeated names.So i want to select only distinct names.Is this possible.

  intUniqId[i] = (objds.Tables[0].Rows[i]["ProcessName"].ToString());

Answer

Thomas Levesque picture Thomas Levesque · Jul 29, 2009 
DataView view = new DataView(table);
DataTable distinctValues = view.ToTable(true, "Column1", "Column2" ...);

Related questions

Datatable select with multiple conditions

I have a datatable with 4 columns A, B, C and D such that a particular combination of values for column A, B and C is unique in the datatable. Objective: To find the value of column D, for a given …

Read More
How to select min and max values of a column in a datatable?

For the following datatable column, what is the fastest way to get the min and max values? AccountLevel 0 1 2 3

Read More
Select and updating data from datatable

I select data from my datatable, by using following code: DataRow[] result = table.Select("Size >= 230 AND Sex = 'm'"); Now I change the data in the datarow-array result and I want to update my datatable (datatable should get the changes). …

Read More