Tuesday 11 November 2014

Get Distinct Record only from datatable in C# Linq



    //----------Get Distinct Record only
                                

                    var distinctNames = (from row in dtGridSeries.AsEnumerable()
                                                      select row.Field<string>("Parameter Type")).Distinct();

        List<string> lstSelectedParamList = distinctNames.ToList();  // Get data in List
                                
       DataTable dtUnique = dtGridSeries.DefaultView.ToTable(true, "ColName");

No comments:

Post a Comment