I have a database with simple table with 1.2 million rows and when I put that into a grid using linq, paging is painfully slow. In the demo http://demos.telerik.com/aspnet-ajax/Grid/Examples/GeneralFeatures/ASPNET35/DefaultCS.aspx it looks like the source code isn't all there, am i missing something? When I put in the .cs file code that is listed in the demo I get no results when paging or sorting, something is missing.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> |
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %> |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
<html xmlns="http://www.w3.org/1999/xhtml"> |
<head runat="server"> |
<title></title> |
</head> |
<body> |
<form id="form1" runat="server"> |
<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager> |
<div> |
<telerik:RadAjaxPanel runat="server" ID="RadAjaxPanel1" LoadingPanelID="RadAjaxLoadingPanel1" EnableAJAX="true"> |
<telerik:RadGrid ID="RadGrid1" EnableLinqExpressions="true" Skin="Vista" DataSourceID="LinqDataSource1" PageSize="100" |
AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" EnableViewState="false" |
runat="server"> |
<HeaderContextMenu Skin="Vista" EnableTheming="True"> |
<CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> |
</HeaderContextMenu> |
<PagerStyle Mode="NextPrevAndNumeric" Position="TopAndBottom" /> |
<MasterTableView DataSourceID="LinqDataSource1" AutoGenerateColumns="False"> |
<RowIndicatorColumn> |
<HeaderStyle Width="20px"></HeaderStyle> |
</RowIndicatorColumn> |
<ExpandCollapseColumn> |
<HeaderStyle Width="20px"></HeaderStyle> |
</ExpandCollapseColumn> |
<Columns> |
<telerik:GridBoundColumn DataField="Column1" HeaderText="Column1" |
SortExpression="Column1" UniqueName="Column1"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="Column2" HeaderText="Column2" |
SortExpression="Column2" UniqueName="Column2"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="Column3" HeaderText="Column3" |
SortExpression="Column3" UniqueName="Column3"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="Column4" HeaderText="Column4" |
SortExpression="Column4" UniqueName="Column4"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="Column5" HeaderText="Column5" |
SortExpression="Column5" UniqueName="Column5"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="Column7" DataType="System.Char" |
HeaderText="Column7" SortExpression="Column7" UniqueName="Column7"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="Column9" HeaderText="Column9" |
SortExpression="Column9" UniqueName="Column9"> |
</telerik:GridBoundColumn> |
</Columns> |
</MasterTableView> |
<FilterMenu Skin="Hay" EnableTheming="True"> |
<CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> |
</FilterMenu> |
</telerik:RadGrid> |
<asp:LinqDataSource ID="LinqDataSource1" runat="server" |
ContextTypeName="Kelly.RAPData" TableName="RAPs" AutoPage="true"> |
</asp:LinqDataSource> |
<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Height="75px" Width="75px" Transparency="5"> |
<img style="margin-top:50px;" alt="Loading..." src='<%= RadAjaxLoadingPanel.GetWebResourceUrl(Page, "Telerik.Web.UI.Skins.Default.Ajax.loading4.gif") %>' /> |
</telerik:RadAjaxLoadingPanel> |
</telerik:RadAjaxPanel> |
</div> |
</form> |
</body> |
</html> |