Tuesday, January 29, 2013

get distinct in datatable or dataSet

          ds= ds.RemoveAColumn("ScheduleId");

          //ds being dataset in here.


           List<string> getTheListOfColumns = ds.GetAllColumnNamesInList();
           DataView view = new DataView(ds.Tables[0].Copy());
           DataTable distinctValues = view.ToTable(true,getTheListOfColumns.ToArray());
           DataSet dsTop = new DataSet();
           dsTop.Tables.Add(distinctValues);

No comments:

Post a Comment