Search
Close this search box.

Getting Distinct Column Values from a (C#)Datatable

The following code snippet shows you a way to extract distinct values in a specific column from a datatable.

// Datatable Creation
DataTable dt = new DataTable();
DataColumn dc = new DataColumn("Col1");
dt.Columns.Add(dc);
dc = new DataColumn("Col2");
dt.Columns.Add(dc);

DataRow dr = dt.NewRow();
dr[0] = "A1";
dr[1] = "B1";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "A1";
dr[1] = "B2";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "A1";
dr[1] = "B3";
dt.Rows.Add(dr);

// To Copy distinct values from col1 to a different datatable
DataTable uniqueCols = dt.DefaultView.ToTable(true, "col1");

We have got disctinct values of  col1 into uniqueColTable. DefaultView.Totable can accept more than one column. The first parameter indicates that the method should fecth disinct values. you can also write dt.DefaultView.ToTable(true, “col1″,”col2”); which will fecth distinct values from both the column combination and copy that to new datatable.

Print | posted on Tuesday, March 29, 2011 9:17 AM

This article is part of the GWB Archives. Original Author: Gino Abreham

Related Posts