☰

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

tag-icon • tag-icon c# select datatable distinct
How to select distinct rows in a datatable and store into an array Ask Question

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());

ベストアンサー1

DataView view = new DataView(table);
DataTable distinctValues = view.ToTable(true, "Column1", "Column2" ...);

おすすめ記事