string[] str = new string[2];// string array is passed with column name of table
str[0] = "ColumnName1";
str[1] = "ColumnName2";
Datatable dt = //your tableobject
dt.DefaultView.ToTable(true, str);// return table of distinct rows
Showing posts with label select distinct rows. Show all posts
Showing posts with label select distinct rows. Show all posts
Retrieve Distinct Rows of Table from Data View or Data Table
string[] str = new string[2];// string array is passed with column name of table
str[0] = "ColumnName1";
str[1] = "ColumnName2";
Datatable dt = //your tableobject
dt.DefaultView.ToTable(true, str);// return table of distinct rows
