aspx Tutorial

.NET Articles,jQuery demo, asp.net with jQuery, online tutorial,Jquery, SilverLight, Javascript, asp.net,JSON, MVC,.NET Articles,demo, Web Services, .NET articles, Sharepoint 2010, visual studio 2010,Aamir Hasan,IT, Building Your First Web Application Project
Advertise Here

Toolbar

Get our toolbar!

Advertize



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="http://www.w3.org/1999/xhtml">
<head runat="server">
   <title></title>
</head>
<body>
   <form id="form1" runat="server">
   <div>
       <asp:GridView ID="GridView1" runat="server">
       </asp:GridView>
   </div>
   </form>
</body>
</html>

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;
       GridView1.DataBind();
   }

   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.

Output

Download

Linq-Distinct-column-fetch-records.zip (1.11 kb)

See live demo

Protected by Copyscape Online Plagiarism Tool

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Advertizement 1
Advertizement 2
Advertizement 3
Advertizement 4
Advertizement 5