Grid View - Data Binding Large Database (Server Mode)

Time taken:   ms
Drag a column header here to group by that column
Bert ParkinsData Archiving. We still don't have this features in our application.11/5/2013125432
Andrew MillerData Import. What database types will we support?10/31/20135232
Peter DolanWeb Edition: Search Page is ready for testing.10/22/2013193699
Jimmy LewisCheck Register. We are using different paths for different modules.10/31/2013253422
Peter DolanReceivables Calculator. Where can I find the complete specs?11/2/201362728
Carl LucasCurrency Mask. The current currency mask in completely unusable.11/14/2013238678
Dave MurrelCurrency Mask. The current currency mask in completely unusable.10/17/201387996
Mark HamiltonReceivables Printing module is ready for testing.11/29/2013243026
Carl LucasReceivables Printing module is ready for testing.10/30/2013107023
Ray ShipmanCurrency Mask. The current currency mask in completely unusable.10/31/2013172155
 Count=600,000 Sum=90579199435 
Page 1 of 60000 (600000 items)Prev1234567599985999960000Next

This demo illustrates how the DevExpress ASP.NET MVC Grid View can be bound to a large databases using LINQ to SQL.

With the ASP.NET MVC Grid View, you can easily bind to LINQ to SQL data sources via the extension's BindToLINQ method. Simply call the method, pass the DataContext and table name as method parameters, and specify the key field via the GridView's KeyFieldName property. Internally, the BindToLINQ method uses our LinqServerModeDataSource component, which was specifically designed to allow the Grid View MVC extension to efficiently process large amounts of data. The LinqServerModeDataSource component automatically enables server mode to optimize the execution of all LINQ queries initiated by the Grid View. In this mode, the Grid View loads records on demand and performs data-aware operations (sorting, filtering, grouping, etc.) on the data server. This technique significantly improves the Grid View's speed and responsiveness.

You can explore the performance of the DevExpress ASP.NET MVC Grid View by executing data shaping operations against it (sorting, filtering, and grouping). Note how quickly the Grid View calculates summaries against 300,000 records.

Version: v2014 vol 2.7
Copyright © 2006-2015 Developer Express Inc
Your Next Great MVC App Starts Here

Get started today and download your 30-day trial of DevExpress MVC Extensions (includes 30 days of free technical support).

All demos ship with full source code and are included in the DevExpress MVC distribution. Refer to the Demos and Sample Applications topic to learn more.

DevExpress MVC Extensions ship as part of DevExpress Universal, DXperience and ASP.NET Subscriptions and are backed by a 60 day unconditional money-back guarantee.
To learn more and obtain pricing information, visit the Compare Features and Pricing webpage. For immediate assistance, contact us by Email at or by phone at +1 (818) 844-3383 between 7:30am and 4:30pm Pacific Time.