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