C#.NET: Get Top and Bottom n Rows from DataTable using LINQ

LINQ, introduced in late 2007 is a way of querying data in arrays, lists, enumerable classes, XML,  relational database s and anything...




LINQ, introduced in late 2007 is a way of querying data in arrays, lists, enumerable classes, XML, relational databases and anything built on these.This post explains how to get the top and bottom n number of  records from C# DataTable without looping through each row using LINQ queries. A LINQ query operation consists of three actions: obtain the data source or sources, create the query, and execute the query.

For this example let me create a datatable with three columns and four rows such as this,

            DataTable dt = new DataTable();
            dt.Columns.Add("Column1");
            dt.Columns.Add("Column2");
            dt.Columns.Add("Column3");
            dt.Rows.Add("A", "B", "C");
            dt.Rows.Add("D", "E", "F");
            dt.Rows.Add("G", "H", "I");
            dt.Rows.Add("J", "K", "L");

To get the top two rows use the following query,

DataTable dt1 = dt.AsEnumerable().Take(2).CopyToDataTable();

This will produce the following output when bound to a gridview,

Column1Column2Column3
ABC
DEF

To get the last two rows use the following query,

DataTable dt1 = dt.AsEnumerable().Reverse().Take(2).CopyToDataTable();

Output:

Column1Column2Column3
JKL
GHI


Subscribe to GET LATEST ARTICLES!


Related

Dot Net 2176976618474508337

Post a Comment

  1. Nice post! Educational content developer for K12 can face challenges while developing content, as every bit of information needs to be aligned to the learning objectives and the corresponding standards of the curriculum framework.
    copy editing services

    ReplyDelete
  2. If you're fond of laying board games monopoly slots will certainly attract you with cool featured you might pretty appealing and worth trying

    ReplyDelete

  3. HP printers offer top-notch offices to their clients around the world. In the event that you have additionally purchased another HP remote printer and don't have a 123.hp.com/setup clue how to set it up on your working framework, then, at that point, this nitty-gritty aide will prove to be useful. In this aide, we bring to you the best strategies and rules on the best way to set up HP Officejet Pro 6978 driver through its authority 123.hp.com/arrangement page. There are two different ways to associate an HP Officejet Pro 6978 with your Windows working framework. Design your new printer by visiting the www.123.hp.com/arrangement page through SSID and secret phrase, WPS ways take out your new HP Officejet Pro 6978 printer and turn it 'On'Open your Windows working framework on the opposite side and snap-on 'Start'Go to the 'Control Panel' and open the organizer of 'Organization and Connectivity' Snap on the 'HP Officejet Pro 6978 printer' symbol and push on the 'Settings' to open it. Select the wizard of 'Arrangement' and hit the catch of 'alright'

    ReplyDelete

emo-but-icon

SUBSCRIBE


item