<telerik:RadAjaxLoadingPanel runat="server" ID="LoadingPanel1"> </telerik:RadAjaxLoadingPanel>
<telerik:RadAjaxManager runat="server" ID="RadAjaxManager1" OnAjaxRequest="RadAjaxManager1_AjaxRequest">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="tabMain">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="tabMain"></telerik:AjaxUpdatedControl>
<telerik:AjaxUpdatedControl ControlID="RadMultiPage1" LoadingPanelID="LoadingPanel1">
</telerik:AjaxUpdatedControl>
</UpdatedControls>
</telerik:AjaxSetting>
<telerik:AjaxSetting AjaxControlID="RadMultiPage1"><UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="RadMultiPage1" LoadingPanelID="LoadingPanel1">
</telerik:AjaxUpdatedControl>
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager><telerik:RadTabStrip ID="tabMain" runat="server" SelectedIndex="0" onTabClick="tabMain_SelectedTabChanged" MultiPageID="RadMultiPage1" OnClientTabSelecting="onTabSelecting" Orientation="HorizontalTop"></telerik:RadTabStrip>
<telerik:RadMultiPage ID="RadMultiPage1" runat="server" SelectedIndex="0" OnPageViewCreated="RadMultiPage1_PageViewCreated"> </telerik:RadMultiPage>
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
AddTab("Tab1")
AddPageView("Tab2")
AddTab("Tab3"
AddTab("Tab4"
AddTab("Tab5"
end if
end sub
Private Sub AddTab(ByVal tabName As String)
Dim tab As RadTab = New RadTab
tab.Text = tabName
tabMain.Tabs.Add(tab)
End Sub
Protected Sub RadMultiPage1_PageViewCreated(ByVal sender As Object, ByVal e As RadMultiPageEventArgs) Handles RadMultiPage1.PageViewCreated
Dim userControlName As String = "\CompanyDetails\" & e.PageView.ID & "_Tab.ascx"
Dim userControl As Control = Page.LoadControl(userControlName)
userControl.ID = e.PageView.ID & "_userControl"
e.PageView.Controls.Add(userControl)
RadMultiPage1.FindPageViewByID(e.PageView.ID).Selected = True
End Sub
Protected Sub tabMain_SelectedTabChanged(ByVal sender As Object, ByVal e As RadTabStripEventArgs) Handles tabMain.TabClick
AddPageView(e.Tab.Text)
e.Tab.PageView.Selected = True
End Sub
Private Sub AddPageView(ByVal pageViewID As String)
If RadMultiPage1.FindPageViewByID(pageViewID) Is Nothing Then
Dim pageView As New RadPageView()
pageView.ID = pageViewID.Replace(" ", "") '"RadMultiPage1" '
RadMultiPage1.PageViews.Add(pageView)
pageView.Selected = True
End If
End Sub

Hi,
Using VS 2010 with RadControls for ASP.NET AJAX Q1 2013 SP2.
Possible after Export i.e. Radbutton (ExportToExcel) inside CommandItemTemplate, automatically Rebind the Grid and Select the 1st row in current page?
Example: Refer to attached, prior to exporting to Excel, Row with Order id 10276, Customer Id TORTU is selected.
I would like immediately after Export, row with Order Id 10269 with CustomerID WHITC from current page ( (i.e. page# 2 of entire Grid) will be automatically selected.
Below is my Grid Declaration as well as code.
Thanks
gc_0620
______
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server"> <telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxy1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="RadGrid1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManagerProxy> <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" Width="43%" Height="16px"> </telerik:RadAjaxPanel> <asp:ValidationSummary ID="ValidationSummary1" ShowMessageBox="true" ShowSummary="false" runat="server" /> <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"> </telerik:RadCodeBlock> <br /> <telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" CellSpacing="0" AllowAutomaticUpdates="true" AllowAutomaticInserts="true" OnItemDataBound="RadGrid1_ItemDataBound" OnPreRender="RadGrid1_PreRender" DataSourceID="LinqDataSource1" GridLines="None" Skin="Office2010Silver" AutoGenerateEditColumn="True"> <ClientSettings> <Selecting AllowRowSelect="True" /> </ClientSettings> <MasterTableView AutoGenerateColumns="False" CommandItemDisplay="Top" DataSourceID="LinqDataSource1" DataKeyNames="OrderID"> <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings> <RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column"> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column"> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> <Columns> <telerik:GridBoundColumn DataField="OrderID" DataType="System.Int32" FilterControlAltText="Filter OrderID column" HeaderText="OrderID" ReadOnly="True" SortExpression="OrderID" UniqueName="OrderID"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CustomerID" FilterControlAltText="Filter CustomerID column" HeaderText="CustomerID" ReadOnly="True" SortExpression="CustomerID" UniqueName="CustomerID"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="EmployeeID" DataType="System.Int32" FilterControlAltText="Filter EmployeeID column" HeaderText="EmployeeID" ReadOnly="True" SortExpression="EmployeeID" UniqueName="EmployeeID"> </telerik:GridBoundColumn> </Columns> <EditFormSettings> <EditColumn FilterControlAltText="Filter EditCommandColumn column"> </EditColumn> </EditFormSettings> <PagerStyle PageSizeControlType="RadComboBox"></PagerStyle> <CommandItemTemplate> <table align="right"> <tr> <td> <asp:CheckBox ID="CheckBox2" Text="Ignore paging (exports all pages)" runat="server"> </asp:CheckBox> </td> <td> <telerik:RadButton ID="ExportToExcel" runat="server" Text="Excel Export" Skin="Office2010Silver" ToggleType="CustomToggle" ForeColor="#009900" ButtonType="LinkButton" OnClick="Button_Export_To_Excel_Click"> </telerik:RadButton> </td> <td> <telerik:RadButton ID="RadButtonAdd" runat="server" Text="New" ButtonType="LinkButton" Skin="Office2010Silver" ToggleType="CustomToggle" ForeColor="#009900" CommandName="InitInsert"> </telerik:RadButton> </td> <td> <telerik:RadButton ID="RadButtonRefresh" runat="server" Text="Refresh Grid" ButtonType="LinkButton" CommandName="Rebind" Skin="Office2010Silver" ToggleType="CustomToggle" ForeColor="#009900"> </telerik:RadButton> </td> </tr> </table> </CommandItemTemplate> </MasterTableView> <PagerStyle PageSizeControlType="RadComboBox"></PagerStyle> <FilterMenu EnableImageSprites="False"> </FilterMenu> </telerik:RadGrid> <asp:LinqDataSource ID="LinqDataSource1" runat="server" ContextTypeName="DataClassesDataContext" EntityTypeName="" Select="new (OrderID, CustomerID, EmployeeID)" TableName="Orders" EnableDelete="True" EnableInsert="True" EnableUpdate="True" Where="OrderID <= @OrderID"> <WhereParameters> <asp:Parameter DefaultValue="10285" Name="OrderID" Type="Int32" /> </WhereParameters> </asp:LinqDataSource> <br /></asp:Content>
protected void SetGridSettings() { GridSettingsPersister LoadPersister = new GridSettingsPersister(RadGrid1); if (Session["qa_home_filter"] == null) { } else { string settings = (string)Session["qa_home_filter"]; LoadPersister.LoadSettings(settings); } } protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // BOM to Create/Maintain Current Filter Settings SetGridSettings(); // BOM to Create/Maintain Current Filter Settings // BOM to Retrieve Page Index after call back from another page int CurrentPageIndex = 0; if (Session["DefaultCurrentPageIndex"] != null) { int.TryParse(Convert.ToString(Session["DefaultCurrentPageIndex"]), out CurrentPageIndex); Session["DefaultCurrentPageIndex"] = null; } RadGrid1.CurrentPageIndex = CurrentPageIndex; } } protected void RadGrid1_PreRender(object sender, EventArgs e) { GridSettingsPersister SavePersister = new GridSettingsPersister(RadGrid1); Session["qa_home_filter"] = SavePersister.SaveSettings(); if (!isSelected && Session["selIndex"] != null && Session["SessionOrderid"] == null) //if (!isSelected && Session["selIndex"] != null) { RadGrid1.MasterTableView.Items[(int)Session["selIndex"]].Selected = true; Session["selIndex"] = null; } else if (!isSelected && Session["SessionOrderid"] == null && RadGrid1.MasterTableView.Items.Count > 0) { RadGrid1.MasterTableView.Items[0].Selected = true; //Panelotherinfo.Visible = true; } else if (!isSelected && (Session["SessionOrderid"] != null)) { string curItem = Session["SessionOrderid"].ToString(); foreach (GridItem item in RadGrid1.MasterTableView.Items) { if (item is GridDataItem) { GridDataItem dataItem = (GridDataItem)item; if (curItem.Equals(dataItem.OwnerTableView.DataKeyValues[dataItem.ItemIndex]["OrderID"].ToString())) { dataItem.Selected = true; break; } } } Session["SessionOrderid"] = null; } isSelected = false; if (rowindex > -1) { GridDataItem item = RadGrid1.Items[rowindex]; item.Selected = true; rowindex = -1; } } bool isSelected; int rowindex = -1; protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item is GridEditableItem && e.Item.IsInEditMode) // Common for all: Insert/Edit/Preview in Main Client { if (!e.Item.OwnerTableView.IsItemInserted) { Session["selIndex"] = e.Item.ItemIndex; } e.Item.Selected = true; isSelected = true; } } protected void Button_Export_To_Excel_Click(object sender, System.EventArgs e) { ConfigureExport(); RadGrid1.Rebind(); RadGrid1.ExportSettings.Excel.Format = GridExcelExportFormat.Biff; //RadGrid1.MasterTableView.ExportToExcel(); RadGrid1.MasterTableView.ExportToExcel(); } public void ConfigureExport() { foreach (GridFilteringItem filter in RadGrid1.MasterTableView.GetItems(GridItemType.FilteringItem)) { filter.Display = false; } RadGrid1.ExportSettings.ExportOnlyData = true; RadGrid1.ExportSettings.OpenInNewWindow = true; GridItem commandItem = RadGrid1.MasterTableView.GetItems(GridItemType.CommandItem)[0]; CheckBox Check_Box2 = (CheckBox)commandItem.FindControl("CheckBox2"); if (Check_Box2.Checked) RadGrid1.AllowPaging = false; else RadGrid1.AllowPaging = true; }
<telerik:RadGrid ID="radABCReportGrid" runat="server" Width="100%" AutoGenerateColumns="true" Skin="Default" Visible="true" BackColor="White"><ExportSettings ExportOnlyData="True" IgnorePaging="True" OpenInNewWindow="true"><Csv ColumnDelimiter="VerticalBar" RowDelimiter="Comma" EncloseDataWithQuotes="true" /><Pdf PageHeight="210mm" PageWidth="297mm" DefaultFontFamily="Arial Unicode MS" PageBottomMargin="10mm" PageTopMargin="10mm" PageLeftMargin="10mm" PageRightMargin="10mm"></Pdf></ExportSettings></telerik:RadGrid>