Monday, 18 June 2012

Selecting distinct value from DataTable in C#

DataTable dtMain = new DataTable();

dtMain.Columns.Add("ID");
dtMain.Columns.Add("Name");
dtMain.Rows.Add(1, "AA");
dtMain.Rows.Add(1, "AA");
dtMain.Rows.Add(2, "CC");
dtMain.Rows.Add(3, "DD");
dtMain.Rows.Add(4, "EE");
dtMain.Rows.Add(5, "BB");
dtMain.Rows.Add(6, "AA");
dtMain.Rows.Add(5, "BB");
dtMain.Rows.Add(7, "FF");
dtMain.Rows.Add(1, "AA");

DataTable dtDistinct = dtMain.DefaultView.ToTable(true, "ID", "Name");

No comments:

Post a Comment