or
I'm using RadGrid (RadGrid.Net2 (I know I should upgrade to a newer version, but that is not an option here..)). One of it's features is to export data to excel. Withgrid.MasterTableView.ExportToExcel(); an excel file is created with filtered and sorted data from the grid (all pages). How can i grab this data?
grd.ExportSettings.ExportOnlyData = true;
grd.ExportSettings.IgnorePaging = true;
grd.MasterTableView.ExportToExcel();
I want to grab the same data as the grid is writing to excel but can't figure out how to do this..
grd.MasterTableView.GetExportDataAsDataTable() would be perfect ;)
<telerik:RadPanelBar ID="RadPanelBar1" Runat="server"> <Items> <telerik:RadPanelItem runat="server" Text="Root RadPanelItem1"> </telerik:RadPanelItem> <telerik:RadPanelItem runat="server" Text="Root RadPanelItem2" Selected="True"> </telerik:RadPanelItem> <telerik:RadPanelItem runat="server" Text="Root RadPanelItem3"> <ContentTemplate> <asp:FormView ID="FormView1" runat="server" DataSourceID="LinqDataSourcePayee" DataKeyNames="id"> <EditItemTemplate> firstName: <asp:TextBox ID="firstNameTextBox" runat="server" Text='<%# Bind("firstName") %>' /> <br /> lastName: <asp:TextBox ID="lastNameTextBox" runat="server" Text='<%# Bind("lastName") %>' /> <br /> <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update" /> <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" /> </EditItemTemplate> <ItemTemplate> firstName: <asp:Label ID="firstNameLabel" runat="server" Text='<%# Bind("firstName") %>' /> <br /> lastName: <asp:Label ID="lastNameLabel" runat="server" Text='<%# Bind("lastName") %>' /> <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit" /> </ItemTemplate> </asp:FormView> </ContentTemplate> </telerik:RadPanelItem> </Items> </telerik:RadPanelBar>protected void Page_Load(object sender, EventArgs e){ RadPanelBar1.Items[0].Visible = RadPanelBar1.Items[0].Enabled =false;}