Grid - Virtualization

ID	Contact Title	Contact Name	Country	Rating


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