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 startOpen 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