How to bind gridview using Linq to SQL

By bryan tugade

Access over 40 UI widgets with everything from interactive menus to rich charts.

We can easily bind gridview using linq to sql. Assuming that your using AdventureWorks as your database.

Imports System.Data.Linq
Imports Microsoft.VisualBasic

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 xemployee = (From employee In adventureContext.Employees Select employee.Title)
            GridView1.DataSource = xemployee
           GridView1.DataBind()

        Catch ex As Exception

           Console.WriteLine(ex.Message)

         End Try
    End Sub
End Class

Here's the result...

That's it. Happy Coding.

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

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.

How to connect to SQLExpress in VB6 and execute stored procedure

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

Find Checkbox Control inside gridview in C#

We can find checkbox inside gridview by using Findcontrol.

Create, Retrieve, Update, Delete - CRUD function using adapter and dataset

Here's a clever way to create CRUD function using adapter and dataset.

Find Checkbox Control inside gridview in VB

We can find checkbox inside gridview by using Findcontrol.

How to bind gridview using Linq to SQL (690 Views)

How to bind gridview using Linq to SQL

We can easily bind gridview using linq to sql. Assuming that your using AdventureWorks as your database.

Related FAQs