How to get distinct values from database in gridview

As you're using quantities rather than Ids, I take it you mean:

Qty Item Name

3 Petrol

7 diesel

You can do this quite easily using a LINQ query.

I've done it below in the form of a console application, using local objects, and will leave it to you to translate it into the context of your application:

using System;

using System.Collections.Generic;

using System.Linq;

class Row

{

public int Qty {get; set;}

public string ItemName {get; set;}

public Row(int qty, string itemName)

{

Qty = qty;

ItemName = itemName;

}

class Program

{

static void Main()

{

var rows = new List();

rows.Add(new Row(1, "Petrol"));

rows.Add(new Row(2, "Petrol"));

rows.Add(new Row(3, "diesel"));

rows.Add(new Row(4, "diesel"));

var query = from row in rows group row by row.ItemName into g

select new Row(g.Sum(row => row.Qty), g.Key);

List rows2 = query.ToList();

Console.WriteLine("Qty\tItem Name");

foreach(Row r in rows2) Console.WriteLine("{0}\t{1}", r.Qty, r.ItemName);

Console.ReadKey();

}

1 Reply

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

Vulpes15y ago
As you're using quantities rather than Ids, I take it you mean:

Qty Item Name
3 Petrol
7 diesel

You can do this quite easily using a LINQ query.

I've done it below in the form of a console application, using local objects, and will leave it to you to translate it into the context of your application:

using System;
using System.Collections.Generic;
using System.Linq;

class Row
{
   public int Qty {get; set;}
   public string ItemName {get; set;}

   public Row(int qty, string itemName)
   {
   Qty = qty;
   ItemName = itemName;
   }

}

class Program
{
   static void Main()
   {
   var rows = new List();
   rows.Add(new Row(1, "Petrol"));
   rows.Add(new Row(2, "Petrol"));
   rows.Add(new Row(3, "diesel"));
   rows.Add(new Row(4, "diesel"));

   var query = from row in rows group row by row.ItemName into g
   select new Row(g.Sum(row => row.Qty), g.Key);
   List rows2 = query.ToList();
   Console.WriteLine("Qty\tItem Name");
   foreach(Row r in rows2) Console.WriteLine("{0}\t{1}", r.Qty, r.ItemName);
   Console.ReadKey();
   }
}
0