How to show Distinct data using Linq to SQL

By bryan tugade

INSTANTLY dtSearch TERABYTES OF POPULAR DATA TYPES; hundreds of reviews, etc.!

We can show Distinct data in gridview using Linq to SQL. We can compare in the result how the distinct function works in Linq to sql. Here's how.

Imports Microsoft.VisualBasic
Imports System.Linq
Imports System.Data.Linq

Partial Public Class WebForm1
    Inherits System.Web.UI.Page

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
        Dim adventureContext = New adventureWorks()

        Try
            Dim original_employee = (From employee In adventureContext.Employees Select employee.Title)

            Dim distinct_employee = (From employee In adventureContext.Employees Select employee.Title).Distinct()

            GridView1.DataSource = distinct_employee
             GridView1.DataBind()
            GridView2.DataSource = original_employee
             GridView2.DataBind()
        Catch ex As Exception

           Console.WriteLine(ex.Message)

        End Try
    End Sub
End Class

And here's the compared result of two queries.

As you can see the original data are not sorted and repeatedly shown in the gridview unlike when you used the distinct in Linq to sql the data are sorted and the data shown distinctively.

That's it! Happy Coding. : )

We can select and deselect checkbox in gridview in onPostback event of checkbox in gridview header.

LINQ To SQL Selecting mulitple fields in a database table

We can select multiple fields in a given database tables using Linq to sql. I use AdventureWorks as my database in this sample app and to show you how it works i bind the results in gridview control.

Hover in Gridviewrows using javascript in VB.NET

We can hover on gridview row using javascript onmouseover event. We can also change the color in code behind.

Filtering data using dataview

We can filter data using dataview.

How to connect to SQLExpress in VB6 and execute stored procedure

This snippet shows how to connect to SQLExpress and execute stored procedure.

Connecting to SQL Express in microsoft excel using visual basic application

Assuming that you need to create an application that needs to transfer data from sql server to microsoft excel. The first thing you need to do is to find a way to connect to sql server. We can do this by using visual basic application.

How to show Distinct data using Linq to SQL (707 Views)

How to show Distinct data using Linq to SQL

We can show Distinct data in gridview using Linq to SQL. We can compare in the result how the distinct function works in Linq to sql. Here's how.

Related FAQs