I have a grid with 200 rows, there is no paging and that is not an option. The issue is that sometimes users do a search and return +-200 rows. When it does this the scrolling is terrible, I mean it takes about 10-15 seconds just to move the scrollbar 5-10 rows. What can be done to resolve this?
Here is my Code
Code Behind:
Here is my Code
<telerik:RadGrid ID="RadGrid1" |
AllowMultiRowSelection="True" |
AllowSorting="True" |
AllowNaturalSort="True" |
AllowPaging="False" |
AutoGenerateColumns="False" |
AlternatingItemStyle-HorizontalAlign="Center" |
BackColor="#ffffff" |
CellPadding="2" |
CellSpacing="2" |
EnableEmbeddedSkins="False" |
GridLines="None" |
GroupingEnabled="True" |
HeaderStyle-Height="20" |
Height="470px" |
ItemStyle-HorizontalAlign="Center" |
OnSortCommand="RadGrid1_SortCommand" |
OnNeedDataSource="RadGrid1_NeedDataSource" |
OnItemDataBound="RadGrid1_ItemDataBound" |
ShowFooter="True" |
ShowHeader="True" |
ShowGroupPanel="True" |
ShowStatusBar="True" |
Skin="MySkin" |
Width="100%" |
Runat="server"> |
<MasterTableView AllowMultiColumnSorting="True" DataKeyNames="COLUMN1, COLUMN2" TableLayout="Fixed" HeaderStyle-Wrap="false" > |
<Columns> |
<telerik:GridClientSelectColumn UniqueName="ClientSelectColumn" HeaderStyle-Width="25" /> |
<telerik:GridBoundColumn DataField="COLUMN1" Visible="False" /> |
<telerik:GridBoundColumn DataField="COLUMN2" Visible="False" /> |
<telerik:GridBoundColumn DataField="COLUMN3" Visible="False" /> |
<telerik:GridBoundColumn DataField="COLUMN4" HeaderText="Column 4" HeaderButtonType="TextButton" HeaderStyle-Width="200px" ItemStyle-HorizontalAlign="Left" SortExpression="COLUMN4" /> |
<telerik:GridBoundColumn DataField="COLUMN5" HeaderText="Column 5" HeaderStyle-Width="100" SortExpression="COLUMN5" /> |
<telerik:GridBoundColumn DataField="COLUMN6" HeaderText="Column 6" HeaderButtonType="TextButton" ItemStyle-HorizontalAlign="Center" SortExpression="COLUMN6" /> |
<telerik:GridBoundColumn DataField="COLUMN7" HeaderText="Column 7" HeaderButtonType="TextButton" ItemStyle-HorizontalAlign="Center" SortExpression="COLUMN7" /> |
<telerik:GridTemplateColumn DataField="COLUMN8" HeaderText="Column 8" ItemStyle-HorizontalAlign="left" SortExpression="COLUMN8" > |
<ItemTemplate> |
<asp:Image ID="ImageErrorMessage" Visible="false" runat="server" /> |
<asp:Label ID="LabelRefreshStatus" runat="server" /> |
<telerik:RadToolTip ID="RadToolTipMessage" TargetControlID="LabelRefreshStatus" RelativeTo="Element" Position="BottomLeft" runat="server" /> |
<telerik:RadToolTip ID="RadToolTipImage" TargetControlID="ImageErrorMessage" RelativeTo="Element" Position="BottomLeft" runat="server" /> |
</ItemTemplate> |
</telerik:GridTemplateColumn> |
<telerik:GridTemplateColumn DataField="COLUMN9" HeaderText="Column 9" ItemStyle-HorizontalAlign="center" SortExpression="COLUMN9" > |
<ItemTemplate> |
<asp:Label ID="LabelBatchType" runat="server" /> |
</ItemTemplate> |
</telerik:GridTemplateColumn> |
<telerik:GridBoundColumn DataField="COLUMN10" HeaderText="Column 10" HeaderButtonType="TextButton" ItemStyle-HorizontalAlign="Center" DataFormatString="{0:MM/dd/yyyy}" SortExpression="COLUMN10"/> |
<telerik:GridBoundColumn DataField="COLUMN11" HeaderText="Column 11" HeaderButtonType="TextButton" ItemStyle-HorizontalAlign="Left" SortExpression="COLUMN11" /> |
<telerik:GridBoundColumn DataField="COLUMN12" HeaderText="Column 12" HeaderButtonType="TextButton" ItemStyle-HorizontalAlign="Left" SortExpression="COLUMN12" /> |
<telerik:GridBoundColumn DataField="COLUMN13" HeaderText="Column 13" HeaderButtonType="TextButton" HeaderStyle-Width="200" ItemStyle-HorizontalAlign="Left" SortExpression="COLUMN13" /> |
<telerik:GridBoundColumn DataField="COLUMN14" HeaderText="Column 14" HeaderButtonType="TextButton" HeaderStyle-Width="150px" ItemStyle-HorizontalAlign="center" HeaderStyle-Wrap="false" DataFormatString="{0:MM/dd/yyyy}" SortExpression="CREDIT_DATE" /> |
<telerik:GridBoundColumn DataField="COLUMN15" HeaderText="Column 15" HeaderButtonType="TextButton" HeaderStyle-Width="200" ItemStyle-HorizontalAlign="Left" SortExpression="COLUMN15" /> |
<telerik:GridBoundColumn DataField="COLUMN16" HeaderText="Column 16" HeaderButtonType="TextButton" ItemStyle-HorizontalAlign="center" SortExpression="COLUMN16" /> |
<telerik:GridBoundColumn DataField="COLUMN17" HeaderText="Column 17" HeaderButtonType="TextButton" ItemStyle-HorizontalAlign="Left" SortExpression="COLUMN17" /> |
<telerik:GridBoundColumn DataField="COLUMN18" HeaderText="Column 18" HeaderButtonType="TextButton" ItemStyle-HorizontalAlign="Center" DataFormatString="{0:MM/dd/yyyy}" SortExpression="COLUMN18" /> |
</Columns> |
<HeaderStyle Width="100px" /> |
</MasterTableView> |
<ClientSettings AllowColumnsReorder="True" AllowDragToGroup="True" ReorderColumnsOnClient="True" AllowRowHide="True"> |
<Resizing AllowColumnResize="True" AllowRowResize="False" ResizeGridOnColumnResize="False" ClipCellContentOnResize="True" EnableRealTimeResize="False" /> |
<Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="True" FrozenColumnsCount="2" /> |
<Selecting AllowRowSelect="True" /> |
</ClientSettings> |
</telerik:RadGrid> |
ListBLL listInfo = new ListBLL(); |
DataTable dataTable = new DataTable(); |
dataTable = listInfo.BatchStatusSearch(parameter1, parameter2, parameter3); |
ViewState["MyDataSource"] = dataTable |
RadGrid1.DataSource = dataTable |
RadGrid1.DataBind(); |