How to get distinct values from database in gridview

Question

Hi
   I have one problem regarding gridview i,e follows:
        I wanna display values in gridview from database but not in dropdown list.
    Ex: I have one column(Item name) and it display redundant values like...

Qty    Item Name
1       Petrol
2       Petrol
3 diesel
4       diesel

But I want as like
Qty   Item Name
1      Petrol
2      diesel

Vulpes · Answer

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	Item Name"); foreach(Row r in rows2) Console.WriteLine("{0}	{1}", r.Qty, r.ItemName); Console.ReadKey(); } }

How to get distinct values from database in gridview

Answers (1)