Grid - Virtualization

ID	Contact Title	Contact Name	Country	Rating


1	Sales Agent	Pascale Cartrain	Austria	1 2 3 4 5
2	Accounting Manager	Paul Henriot	Argentina	1 2 3 4 5
3	Owner	Jaime Yorres	Germany	1 2 3 4 5
4	Sales Consultant	Hanna Moos	Spain	1 2 3 4 5
5	Accounting Manager	Paul Henriot	USA	1 2 3 4 5
6	Owner	Howard Snyder	England	1 2 3 4 5
7	Marketing Assistant	Hanna Moos	Austria	1 2 3 4 5
8	Accountant	Elizabeth Lincoln	Argentina	1 2 3 4 5
9	Accounting Manager	Georg Pipps	Bulgaria	1 2 3 4 5
10	Sales Representative	Howard Snyder	Austria	1 2 3 4 5
11	Marketing Assistant	Antonio Moreno	England	1 2 3 4 5
12	Sales Consultant	Antonio Moreno	France	1 2 3 4 5
13	Marketing Assistant	Pascale Cartrain	Germany	1 2 3 4 5
14	Sales Agent	Howard Snyder	Italy	1 2 3 4 5
15	Sales Manager	Hanna Moos	Germany	1 2 3 4 5
16	Sales Consultant	Antonio Moreno	England	1 2 3 4 5
17	Sales Consultant	Howard Snyder	England	1 2 3 4 5
18	Sales Agent	Hanna Moos	Italy	1 2 3 4 5
19	Sales Associate	Matti Karttunen	Germany	1 2 3 4 5
20	Sales Manager	Elizabeth Lincoln	England	1 2 3 4 5
21	Sales Manager	Georg Pipps	Brazil	1 2 3 4 5
22	Sales Agent	Paul Henriot	Brazil	1 2 3 4 5
23	Sales Manager	Pascale Cartrain	Bulgaria	1 2 3 4 5
24	Accounting Manager	Hanna Moos	USA	1 2 3 4 5
25	Marketing Assistant	Jaime Yorres	Germany	1 2 3 4 5
26	Sales Agent	Jaime Yorres	France	1 2 3 4 5
27	Sales Manager	Antonio Moreno	Bulgaria	1 2 3 4 5
28	Sales Associate	Paul Henriot	Bulgaria	1 2 3 4 5
29	Accounting Manager	Patricio Simpson	Argentina	1 2 3 4 5
30	Sales Representative	Georg Pipps	Italy	1 2 3 4 5
31	Accounting Manager	Jaime Yorres	England	1 2 3 4 5
32	Sales Agent	Paul Henriot	Austria	1 2 3 4 5
33	Owner	Pascale Cartrain	Austria	1 2 3 4 5
34	Accounting Manager	Pascale Cartrain	Spain	1 2 3 4 5
35	Accountant	Jaime Yorres	Austria	1 2 3 4 5
36	Marketing Manager	Matti Karttunen	Bulgaria	1 2 3 4 5
37	Marketing Manager	Georg Pipps	Austria	1 2 3 4 5
38	Marketing Manager	Georg Pipps	England	1 2 3 4 5
39	Marketing Manager	Howard Snyder	Argentina	1 2 3 4 5
40	Accounting Manager	Hanna Moos	Bulgaria	1 2 3 4 5
41	Sales Consultant	Patricio Simpson	England	1 2 3 4 5
42	Sales Representative	Patricio Simpson	France	1 2 3 4 5
43	Marketing Manager	Georg Pipps	England	1 2 3 4 5
44	Marketing Assistant	Georg Pipps	England	1 2 3 4 5
45	Sales Representative	Paul Henriot	Spain	1 2 3 4 5
46	Sales Consultant	Howard Snyder	Germany	1 2 3 4 5
47	Accountant	Antonio Moreno	Spain	1 2 3 4 5
48	Marketing Manager	Matti Karttunen	Argentina	1 2 3 4 5
49	Sales Agent	Antonio Moreno	France	1 2 3 4 5
50	Sales Representative	Hanna Moos	Germany	1 2 3 4 5
51	Sales Representative	Patricio Simpson	Italy	1 2 3 4 5
52	Marketing Manager	Jaime Yorres	Brazil	1 2 3 4 5
53	Sales Manager	Howard Snyder	Spain	1 2 3 4 5
54	Owner	Pascale Cartrain	England	1 2 3 4 5
55	Marketing Assistant	Pascale Cartrain	Bulgaria	1 2 3 4 5
56	Sales Manager	Hanna Moos	Germany	1 2 3 4 5
57	Sales Associate	Antonio Moreno	Bulgaria	1 2 3 4 5
58	Sales Manager	Elizabeth Lincoln	Austria	1 2 3 4 5
59	Accounting Manager	Howard Snyder	USA	1 2 3 4 5
60	Accountant	Pascale Cartrain	USA	1 2 3 4 5
61	Sales Agent	Georg Pipps	Germany	1 2 3 4 5
62	Marketing Manager	Antonio Moreno	Spain	1 2 3 4 5
63	Accounting Manager	Paul Henriot	Germany	1 2 3 4 5
64	Accounting Manager	Paul Henriot	USA	1 2 3 4 5
65	Accountant	Antonio Moreno	Argentina	1 2 3 4 5
66	Marketing Assistant	Paul Henriot	France	1 2 3 4 5
67	Accountant	Antonio Moreno	USA	1 2 3 4 5
68	Sales Agent	Howard Snyder	Germany	1 2 3 4 5
69	Sales Agent	Pascale Cartrain	Germany	1 2 3 4 5
70	Marketing Assistant	Matti Karttunen	Austria	1 2 3 4 5
71	Accountant	Antonio Moreno	Spain	1 2 3 4 5
72	Sales Agent	Elizabeth Lincoln	Bulgaria	1 2 3 4 5
73	Marketing Assistant	Jaime Yorres	Brazil	1 2 3 4 5
74	Accounting Manager	Antonio Moreno	USA	1 2 3 4 5
75	Owner	Howard Snyder	Spain	1 2 3 4 5
76	Marketing Manager	Matti Karttunen	Argentina	1 2 3 4 5
77	Accountant	Jaime Yorres	Argentina	1 2 3 4 5
78	Accountant	Howard Snyder	Spain	1 2 3 4 5
79	Sales Representative	Elizabeth Lincoln	Bulgaria	1 2 3 4 5
80	Sales Manager	Matti Karttunen	Brazil	1 2 3 4 5
81	Owner	Paul Henriot	England	1 2 3 4 5
82	Sales Associate	Patricio Simpson	Austria	1 2 3 4 5
83	Marketing Assistant	Georg Pipps	USA	1 2 3 4 5
84	Sales Representative	Elizabeth Lincoln	England	1 2 3 4 5
85	Accounting Manager	Paul Henriot	England	1 2 3 4 5
86	Accountant	Hanna Moos	USA	1 2 3 4 5
87	Sales Consultant	Elizabeth Lincoln	Spain	1 2 3 4 5
88	Sales Consultant	Elizabeth Lincoln	England	1 2 3 4 5
89	Sales Associate	Matti Karttunen	Argentina	1 2 3 4 5
90	Owner	Hanna Moos	Italy	1 2 3 4 5
91	Owner	Patricio Simpson	France	1 2 3 4 5
92	Marketing Manager	Matti Karttunen	Argentina	1 2 3 4 5
93	Owner	Howard Snyder	USA	1 2 3 4 5
94	Sales Manager	Matti Karttunen	Bulgaria	1 2 3 4 5
95	Sales Agent	Georg Pipps	Italy	1 2 3 4 5
96	Marketing Manager	Matti Karttunen	USA	1 2 3 4 5
97	Sales Consultant	Howard Snyder	Brazil	1 2 3 4 5
98	Marketing Assistant	Jaime Yorres	Austria	1 2 3 4 5
99	Accountant	Georg Pipps	USA	1 2 3 4 5
100	Sales Consultant	Howard Snyder	USA	1 2 3 4 5


1 2 3 4 5 6 7 8 9 10 ... Item 1 to 1000 of 300000 Page: of 300 Page size:

Sort Ascending
Sort Descending
Clear Sorting
Columns
- ID
- Contact Title
- Contact Name
- Country
- Rating

Isolate this demo as a stand-alone application

About this demo
C#
VB

RadGrid's virtualization feature allows you to handle hundreds of thousands of rows without negatively impacting the user experience. The control achieves this thanks to its ItemsPerView property allowing you to control the number of items loaded at a time. Users can now scroll, as well as show, hide, resize and reorder columns without any waiting time.

This demo shows how quickly Telerik's ASP.NET DataGrid can handle user interactions with 300,000 items. You can configure the component to allow scrolling through the entire data set or only through the current page by using EnableCurrentPageScrollOnly property,.

<%@ Page Language="vb" AutoEventWireup="false" CodeFile="DefaultVB.aspx.vb" Inherits="Telerik.GridExamplesVBNET.Performance.Virtualization.DefaultVB" %>

<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<%@ Register TagPrefix="qsf" Namespace="Telerik.QuickStart" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns='http://www.w3.org/1999/xhtml'>
<head runat="server">
    <title>Telerik ASP.NET Example</title>
    <link href="styles.css" rel="stylesheet" />
</head>
<body>
    <form id="form1" runat="server">
    <telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    <telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" />
    <telerik:RadAjaxLoadingPanel runat="server" ID="RadAjaxLoadingPanel1"></telerik:RadAjaxLoadingPanel>
    <telerik:RadAjaxPanel runat="server" ID="RadAjaxPanel" LoadingPanelID="RadAjaxLoadingPanel1" CssClass="demo-container">
        <telerik:RadGrid RenderMode="Lightweight" ID="RadGrid1" runat="server"  AutoGenerateColumns="false"
            AllowSorting="true" GroupingEnabled="false"
            EnableHeaderContextMenu="true" AllowPaging="true" PageSize="1000" OnNeedDataSource="RadGrid1_NeedDataSource">
            <MasterTableView TableLayout="Fixed">
                <Columns>
                    <telerik:GridBoundColumn UniqueName="ID" HeaderText="ID" HeaderStyle-Width="50px" DataField="ID"></telerik:GridBoundColumn>
                    <telerik:GridBoundColumn UniqueName="ContactTitle" HeaderText="Contact Title" HeaderStyle-Width="150px" DataField="ContactTitle"></telerik:GridBoundColumn>
                    <telerik:GridBoundColumn UniqueName="ContactName" HeaderText="Contact Name" HeaderStyle-Width="150" DataField="ContactName"></telerik:GridBoundColumn>
                    <telerik:GridBoundColumn UniqueName="Country" HeaderText="Country" HeaderStyle-Width="100px" DataField="Country"></telerik:GridBoundColumn>
                    <telerik:GridRatingColumn UniqueName="Rating" HeaderText="Rating" HeaderStyle-Width="100px" DataField="Rating"></telerik:GridRatingColumn>
                </Columns>
            </MasterTableView>
            <ClientSettings ReorderColumnsOnClient="true" AllowColumnsReorder="true" ColumnsReorderMethod="Reorder">
                <Virtualization EnableVirtualization="true" InitiallyCachedItemsCount="2000"
                    LoadingPanelID="RadAjaxLoadingPanel1" ItemsPerView="100"/>
                <Scrolling AllowScroll="true" UseStaticHeaders="true" ScrollHeight="500px" />
                <Resizing AllowColumnResize="true" />
            </ClientSettings>
            <PagerStyle Mode="NextPrevNumericAndAdvanced"></PagerStyle>
        </telerik:RadGrid>
    </telerik:RadAjaxPanel>
    </form>
</body>
</html>

Support & Learning Resources

Find Assistance

Submit a support ticket
if you have an active license or trial
Post in the forum
if you don't have access to support

Help Us Improve

Was this example helpful?

YesNo

skins

Grid - Virtualization

Related Resources

Support & Learning Resources

Find Assistance

Help Us Improve