Get distinct records from datatable

Nikunj Satasiya

Hello Everyone,

I have a data table with the following columns and rows as I showed below.

DataTable dt = new DataTable();
try
{
dt.Columns.Add("f1");
dt.Columns.Add("f2");
dt.Columns.Add("f3");
dt.Rows.Add("ABC", "ATAG", "");
dt.Rows.Add("abc", "atag", "");
dt.Rows.Add("abc", "ATAGChild", "");
}
catch (Exception)
{
throw;
}

I want to get distinct records from this data table (check case sensitive information) and I need the following expected output as a result in the data table.

Expected Output:

f1	f2
ABC	ATAG
abc	ATAGChild

where f1 and f2 is my column.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
try this code:
DataView view = new DataView(table);
DataTable distinctValues = view.ToTable(true, "Column1", "Column2" ...);
Amit Gupta7y ago
Here you go
table.CaseSensitive =false;

DataView view = new DataView(table);
DataTable distinctValues = view.ToTable(true, "Column1", "Column2" ...);
Nikunj Satasiya7y ago
Thanks, Piyush and Amit but It's Not Working...

Please look my requirement again

"ABC", "ATAG" and "abc", "atag" both are same.... there is only one difference is capital and small latter... I need only one unique record from these records.

f1 f2

ABC ATAG

abc atag

There is my writing mistake in the last record and I really apologized for that.
Piyush Pansuriya7y ago
Hi
Use below code for better performance
dt.AsEnumerable().Distinct(System.Data.DataRowComparer.Default).ToList();
Amit Gupta7y ago
DataView view = new DataView(table); DataTable distinctValues = view.ToTable(true, "Column1", "Column2" ...);