aspx Tutorial

NET Articles,jQuery demo, with jQuery, online tutorial,Jquery, SilverLight, Javascript,,JSON, MVC,.NET Articles,demo, Web Services,
Advertise Here


Get our toolbar!


Posted by Aamir Hasan   on Monday, December 6, 2010 Total Views:  

Yesterday developer asked me, distinct method on a column using linq is not woking. So, i have decided to wite this example in my blog to share with all of you. Let’s start

Open your Visual Studio 2008/2010 from File -> New -> New Web Site.

Following is the code of Default.aspx page.

<html xmlns="">
<head runat="server">
   <form id="form1" runat="server">
       <asp:GridView ID="GridView1" runat="server">

Following is the code of Default.aspx.cs page.

protected void Page_Load(object sender, EventArgs e)
       GridView1.DataSource = from i in getAllEmployee()
                              group i by i.FullName into temp1
                              select temp1.Key;

   public List<Employee> getAllEmployee()
       List<Employee> emp = new List<Employee>()
           new Employee(){ ID=1, FullName="Aamir Hasan", Age=25 },
           new Employee(){ ID=2, FullName="Awais Ahmed", Age=21 },
           new Employee(){ ID=3, FullName="Saba khan", Age=11 },
           new Employee(){ ID=4, FullName="Mahwish Hasan", Age=18 },
           new Employee(){ ID=5, FullName="Hina", Age=26 },
           new Employee(){ ID=6, FullName="John", Age=24 },
           new Employee(){ ID=7, FullName="Aamir Hasan", Age=22 },
           new Employee(){ ID=8, FullName="Awais Ahmed", Age=21 },
           new Employee(){ ID=9, FullName="Aamir Hasan", Age=20 },
       return emp;

   public class Employee
       public int ID { get; set; }
       public String FullName { get; set; }
       public int Age { get; set; }

Note: You can get distinct values of any column by using above  linq query syntax.


Download (1.11 kb)

See live demo

Protected by Copyscape Online Plagiarism Tool

Add comment

  Country flag

  • Comment
  • Preview

Advertizement 1
Advertizement 2
Advertizement 3
Advertizement 4
Advertizement 5