protected void BindButtonName() { var dt = menu = mbl.getMenuNo(Staff_CD, Base_DL.iniEntity.StoreType); if (dt.Rows.Count > 0) { var _result = dt.AsEnumerable().GroupBy(x => x.Field <string>("Char1")).Select(g => g.First()).CopyToDataTable(); //////Changed by PTk bcox of Gtone HOMESTAYED TIME COVID_19 var dt1 = dt.AsEnumerable() .GroupBy(r => new { Col1 = r["BusinessID"], Col2 = r["BusinessSEQ"] }) .Select(g => { var row = dt.NewRow(); //r => r["PK"]).First() //row["PK"] = g.Min(r => r.Field<int>("PK")); row["char1"] = g.First().Field <string>("char1"); row["BusinessID"] = g.Key.Col1; row["BusinessSEQ"] = g.Key.Col2; return(row); }) .CopyToDataTable(); ButtonText(panelLeft, dt1, 1); } //var _result =(from r1 in dt.AsEnumerable() group r1 by new { Char1 = r1.Field<string>("Char1"), } into g select new { Char1 = g.Key.Char1, BusinessSEQ = g.Max(x => x.Field<int>("BusinessSEQ")) }).ToArray(); //Group By //var _result = dt.AsEnumerable().GroupBy(x => x.Field<string>("Char1")).Select(g => g.First()).CopyToDataTable(); //ButtonText(panelLeft, _result, 1); }
protected void BindButtonName() { var dt = menu = mbl.getMenuNo(Staff_CD); var _result = dt.AsEnumerable().GroupBy(x => x.Field <string>("Char1")).Select(g => g.First()).CopyToDataTable(); ButtonText(panelLeft, _result, 1); }