Grid - Virtualization

ID	Contact Title	Contact Name	Country	Rating


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