Grouping table data

Weeman Osekre

I have data in my table and some have the same data on one of the columns ( tabel_no_) . I want to group all the table_no_ that have the same number and create a dynamic button for it . The problem with this code is item doesn’t accept Groupby private void Interface_Load(object sender, EventArgs e){int i = 0;int x = 0;if (gg.unpaidchecks.Count() != 0){foreach(var item in gg.unpaidchecks.ToList()){ item.GroupBy(p => p.tabel_no_).Select(group => new { Key = group.Key, item = group.OrderByDescending(s => s.date) }).Select(g => g.item.First());if (item.user == libuser.Text){Button btn = new Button();btn.Location = new Point(3 + i, 14 + x);btn.Width = 160;btn.Height = 80;btn.BackColor = System.Drawing.Color.Red;btn.ForeColor = System.Drawing.Color.Yellow;btn.Text = "Tabel" + item.tabel_no_ .ToString();btn.Click += new EventHandler(btn_Click);this.flowLayout5.Controls.Add(btn);i += 10;x += 10;

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Just change the variable name from group to grouplist anything you wish like var groupDs=gg.items.groupBy(.....)
Weeman Osekre5y ago
I still run into an error private void Interface_Load(object sender, EventArgs e){ int i = 0;int x = 0;if (gg.unpaidchecks.Count() != 0){ var group=gg.unpaidchecks.GroupBy(p => p.tabel_no_). Select(group(it has an error saying . A local or parameter named ‘group’ cannot be declared in scope because name is used in an enclosing local scope to define local or parameter ) => new { Key = group.Key, item = group.OrderByDescending(s => s.date) }) .Select(g => g.item.First());
Sachin Singh5y ago
you are doing it in incorrectly , GroupBy works on List not on individual object
private void Interface_Load(object sender, EventArgs e){
     int i = 0;int x = 0;if (gg.unpaidchecks.Count() != 0){
         var group=gg.unpaidchecks.GroupBy(p => p.tabel_no_).
             Select(group => new { Key = group.Key, item = group.OrderByDescending(s => s.date) })
                 .Select(g => g.item.First());
         foreach(var item in group){

             if (item.user == libuser.Text)
             {Button btn = new Button();
                 btn.Location = new Point(3 + i, 14 + x);
                 btn.Width = 160;btn.Height = 80;
                 btn.BackColor = System.Drawing.Color.Red;
                 btn.ForeColor = System.Drawing.Color.Yellow;btn.Text = "Tabel" + item.tabel_no_ .ToString();
                 btn.Click += new EventHandler(btn_Click);this.flowLayout5.Controls.Add(btn);i += 10;x += 10;

    }