Skip and Take in Linq to Sql in C#

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

This Topic will show you on how to skip and take rows using Linq to Sql in C#.

using System;
using System.Linq;
using System.Web;
using System.Data;

public partial class Default3 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       GetData(Convert.ToInt32(ddskip.SelectedValue),Convert.ToInt32(ddtake.SelectedValue));
    }

    private void GetData(int iSkip, int itake)
{
var sqldatacontext = new linqtosqlclassDataContext();

         var data = (from p in sqldatacontext.Products where p.Color == "Black" select new { p.ProductID, p.ProductNumber, p.Name }).Skip(iSkip).Take(itake);

GridView1.DataSource = data;
GridView1.DataBind();

}

}

That's it! Happy Coding.

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.
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
We could get specific rows in the database table by skip and take using Linq to Sql. Here is the sample code.
Skip and Take in Linq to Sql in C#  (577 Views)