or
<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Default" IsSticky="true" style="position:absolute; top:0; left:0; height:100; width;"> </telerik:RadAjaxLoadingPanel> <telerik:RadAjaxManager ID="AjaxManager" runat="server" DefaultLoadingPanelID="RadAjaxLoadingPanel1"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="btnAddTeachingActivity"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="windowExistingActivity" LoadingPanelID="RadAjaxLoadingPanel1" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="radioExisitingActivity"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="windowExistingActivity" /> <telerik:AjaxUpdatedControl ControlID="windowAddTeachingActivity" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager><telerik:RadButton ID="btnAddTeachingActivity" runat="server" Text="Add Teaching Activity" OnClick="btnAddTeachingActivity_Click"> <Icon PrimaryIconUrl="template/Icons/add.png" /> </telerik:RadButton><telerik:RadWindow ID="windowExistingActivity" runat="server" IconUrl="template/icons/add.png" Title="Add New Teaching Activity" Behaviors="Close, Move" Modal="true" VisibleStatusbar="false" AutoSize="false" Width="500px" Height="200px" > <ContentTemplate> <div class="roundGrayBox" style="width: 435px; margin-left: 10px; margin-right: 10px; margin-top: 15px;"> <asp:Panel ID="pnlExisitingActivityQuestion" runat="server"> <h2>Have you entered this teaching activity into the system previously?</h2> <asp:RadioButtonList ID="radioExisitingActivity" runat="server" AutoPostBack="true" OnSelectedIndexChanged="radioExisitingActivity_SelectedIndexChanged"> <asp:ListItem Text="Yes" /> <asp:ListItem Text="No" /> </asp:RadioButtonList> </asp:Panel> <asp:Panel ID="pnlExisitingActivitySelection" runat="server" Visible="false"> <h2>Select Exisiting Activity</h2> <table width="100%"> <tr> <td>Academic Year:</td> <td> <telerik:RadComboBox ID="ddlExisitingActivityYear" runat="server" Width="150px"> </telerik:RadComboBox> </td> </tr> <tr> <td>Activitiy:</td> <td> <telerik:RadComboBox ID="ddlExisitingActivities" runat="server" Width="100%"> </telerik:RadComboBox> </td> </tr> </table> <telerik:RadButton ID="btnExisitingActivity" runat="server" Text="Start With Exisiting Activity" /> </asp:Panel> </div> </ContentTemplate> </telerik:RadWindow>protected void btnAddTeachingActivity_Click(object sender, EventArgs e) { windowExistingActivity.VisibleOnPageLoad = true; } protected void radioExisitingActivity_SelectedIndexChanged(object sender, EventArgs e) { if (radioExisitingActivity.SelectedValue == "Yes") { windowExistingActivity.VisibleOnPageLoad = true; pnlExisitingActivitySelection.Visible = true; pnlExisitingActivityQuestion.Visible = false; } else { hiddenTeachingActivityId.Value = ""; windowAddTeachingActivity.Title = "Add Teaching Activity"; windowAddTeachingActivity.IconUrl = "template/icons/add.png"; windowAddTeachingActivity.VisibleOnPageLoad = true; txtContactHours.Value = null; txtNumberOfLeaners.Value = null; txtTitle.Text = ""; ddlAcademicYear.SelectedIndex = 0; ddlLearners.ClearSelection(); ddlLocation.SelectedIndex = 0; ddlSemester.SelectedIndex = 0; ddlStrategy.SelectedIndex = 0; }<telerik:RadGrid ID="myRadGrid" runat="server" Width="95%" BorderWidth="1px" CellPadding="6" GridLines="None" BorderColor="#404040" Skin="Web20" ShowFooter="true"> <MasterTableView AutoGenerateColumns="false" DataKeyNames="intIssuedID" HierarchyDefaultExpanded="false" HierarchyLoadMode="ServerBind" Name="MasterGrid" BorderColor="#404040" Font-Size="10" Font-Names="Veranda,arial,sans-serif" HeaderStyle-HorizontalAlign="Center" GridLines="Both" BorderWidth="1px"><ItemStyle HorizontalAlign="Center" /> <AlternatingItemStyle BackColor="#B0C4DE" HorizontalAlign="Center" /><HeaderStyle ForeColor="White" Font-Bold="true" BorderColor="#404040" BorderWidth="1px" /> <Columns> <telerik:GridBoundColumn DataField="strAssetNum" HeaderText="ASSET TAG #" /> <telerik:GridBoundColumn DataField="Equip" HeaderText="EQUIPMENT" /> <telerik:GridBoundColumn DataField="dt_Issued" HeaderText="DT_ISSUED" /> <telerik:GridBoundColumn DataField="strLocation" HeaderText="LOCATION" /> <telerik:GridTemplateColumn HeaderText="ISSUED TO"> <ItemTemplate> <asp:HyperLink NavigateUrl='<%# Bind("strEmail", "mailto:{0}") %>' Text='<%# Bind("IssuedTo") %>' runat="server" ID="hlEmail"></asp:HyperLink> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="ftQTY" HeaderText="QTY" /> </Columns> </MasterTableView> </telerik:RadGrid>I have a RadGrid that I have over a million records on. Currently I use a select * to display everything in the grid, so people can click next, put in a search in the filter, etc.It otherwise works perfect for me.
Under heavy load, I was wondering if there is a more efficient way to use the RadGrid, so instead of doing a select * for all the records, I can select 20 records, but still have the filters on top and the search capacity to search all million records if someone does it at the top.
Thanks!
if
(tabStrip.Tabs.Count > 1)
{
tabStrip.Tabs[0].Selected = true;
tabStrip.Tabs[0].PageView.Selected = true;
}