Grid - Virtualization

ID	Contact Title	Contact Name	Country	Rating


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