Skip and Take in Linq to Sql in VB.Net
By bryan tugade
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
In C#, we can select and deselect checkbox in gridview in onPostback event of checkbox in gridview header.
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.
We can hover on gridview row using javascript onmouseover event. We can also change the color in code behind.
We can filter data using dataview.
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.
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 (1470 Views)