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);
}
