or
<MasterTableView DataSourceID="dsMain" DataKeyNames="ID, ParentID" AllowSorting="True" HierarchyLoadMode="ServerBind" GroupLoadMode="Server"><DetailTables><telerik:GridTableView DataSourceID="dsSub" DataKeyNames="ID, ParentID" Width="100%" AutoGenerateColumns="True" > <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="ID" MasterKeyField="ID"> </telerik:GridRelationFields></ParentTableRelation> </telerik:GridTableView> </DetailTables>
<asp:ObjectDataSource id="dsMain" runat="server" selectmethod="GetRootCategories" deletemethod="DeleteCategory" typename="Ascent.Catalog.Model.DataModel.Categories"> <deleteparameters> <asp:Parameter Name="ID" Type="Int32"/> </deleteparameters> </asp:ObjectDataSource> <asp:ObjectDataSource id="dsSub" runat="server" selectmethod="GetSubCategoriesByParentCategoryId" deletemethod="DeleteCategory" typename="Ascent.Catalog.Model.DataModel.Categories"> <deleteparameters> <asp:Parameter Name="ID" Type="Int32"/> </deleteparameters> <SelectParameters> <asp:SessionParameter Name="pID" SessionField="ID" Type="Int32"></asp:SessionParameter> </SelectParameters> </asp:ObjectDataSource>Case "ExportToExcel"RadGrid1.ExportSettings.ExportOnlyData = True
RadGrid1.ExportSettings.IgnorePaging = True
RadGrid1.ExportSettings.OpenInNewWindow = TrueRadGrid1.MasterTableView.ExportToExcel()