Skip and Take in Linq to Sql in VB.Net

By bryan tugade
ODBC Drivers for QuickBooks, Salesforce, SAP, MSCRM, SharePoint … Free Trial!

We could get specific rows in the database table by skip and take using Linq to Sql. Here is the sample code.

Imports system.Linq

Partial Class _Default
    Inherits System.Web.UI.Page

  Private Sub GetData(ByVal iSkip As Integer, ByVal itake As Integer)
        Dim sqldatacontext = New linqtosqlclassDataContext

         Dim data = (From product In sqldatacontext.Products Where Product.Color = "Black" Skip iSkip Take itake Select product)

        GridView1.DataSource = data
        GridView1.DataBind()

    End Sub

End Class

Use the AdventureWorks as the sample database. Just call the sub procedure and pass an integer to its parameter.
i.e. GetData(5,10) where 5 is the rows that you want to skip and 10 is the row that you only wanted to show in the result.


Related FAQs

Select / Deselect all checkbox in gridview in C#
In C#, 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.
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 bind gridview using Linq to SQL
We can easily bind gridview using linq to sql. Assuming that your using AdventureWorks as your database.
Skip and Take in Linq to Sql in VB.Net  (491 Views)