list to databinding metot

Ufuk 1 Reputation point
2022-09-28T09:51:01.903+00:00

Hello ;

My code works like this. But when I click on the column header, it doesn't sort.

 db.satis.Where(x => x.Tarih >= baslangic && x.Tarih <= bitis).OrderByDescending(x => x.Tarih).Load();  
                var Satislar = db.satis.Local.ToBindingList();     
  
  
List<satis> result = Satislar  
              .GroupBy(l => l.Barkod)  
              .Select(cl => new satis  
              {  
                  UrunAd = cl.Select(x => x.UrunAd).FirstOrDefault(),  
                  Barkod = cl.Select(x => x.Barkod).FirstOrDefault(),  
                  Miktar = cl.Sum(x => x.Miktar)  
              })  
              .OrderBy(x => x.Miktar)  
              .ToList();  
  
                dataGridView2.DataSource = result;  

When I write the code like this, an error occurs.245499-ekran-al%C4%B1nt%C4%B1s%C4%B1.png

       db.satis.Where(x => x.Tarih >= baslangic && x.Tarih <= bitis)  
                         .GroupBy(es => es.Barkod)  
                         .Select(f =>new satis  
                         {  
                         UrunAd = f.Select(x => x.UrunAd).FirstOrDefault(),  
                         Barkod = f.Select(x => x.Barkod).FirstOrDefault(),  
                         Miktar = f.Sum(x => x.Miktar)  
                     })  
                   .OrderByDescending(x => x.Miktar)  
                   .Load();/*  
  
                   var result = db.satis.Local.ToBindingList();  
                dataGridView2.DataSource = result;  
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,714 questions
{count} votes