or
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server"></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server"> <p></p> <script type="text/javascript" language="javascript"> </script> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <telerik:RadSplitter ID="RadSplitter1" runat="server" Skin="Vista" Width="100%" Height="550px"> <telerik:RadPane ID="LeftPane" runat="server" Width="350" MinWidth="200"> left panel </telerik:RadPane> <telerik:RadSplitBar ID="RadSplitBar1" runat="server" CollapseMode="Forward"/> <telerik:RadPane ID="RightPane" runat="server" Scrolling="None" OnclientResized="afterResize"> right panel </telerik:RadPane> </telerik:RadSplitter> </asp:Content>| <telerik:RadGrid ID="RadGrid1" OnSortCommand="RadGrid1_SortCommand" OnPageIndexChanged="RadGrid1_PageIndexChanged" OnNeedDataSource="RadGrid1_NeedDataSource" |
| AllowSorting="True" PageSize="15" AllowPaging="True" runat="server" EnableEmbeddedSkins="false" |
| Skin="EasyEcomm" AutoGenerateColumns="true" ExportSettings-ExportOnlyData="false" ExportSettings-FileName="SqlExport" |
| ExportSettings-OpenInNewWindow="true"> |
| <PagerStyle Mode="Slider" /> |
| <ClientSettings EnableRowHoverStyle="true"> |
| </ClientSettings> |
| </telerik:RadGrid> |
| <asp:Label ID="SqlStatementLabel" runat="server" Text=""></asp:Label><br /> |
| <div class="bottom_left_div" runat="server" id="ButtonsDiv"> |
| <br /> |
| <asp:Button ID="BackButton" runat="server" Text="<< Back" OnClick="BackButton_Click" /><asp:Button |
| ID="ExportCSVButton" runat="server" Text="Export to CSV" OnClick="ExportCSVButton_Click" /> |
| <asp:Button |
| ID="ExportXLSButton" runat="server" Text="Export to XLS" OnClick="ExportXLSButton_Click" /> |
| <asp:Button |
| ID="ExportWRDButton" runat="server" Text="Export to Word" OnClick="ExportWRDButton_Click" /> |
| <asp:Button |
| ID="ExportPDFButton" runat="server" Text="Export to PDF" OnClick="ExportPDFButton_Click" /> |
| </div> |
| protected void ExportCSVButton_Click(object sender, EventArgs e) |
| { |
| RadGrid1.MasterTableView.AllowPaging = false; |
| RadGrid1.MasterTableView.Rebind(); |
| RadGrid1.ExportSettings.IgnorePaging = true; |
| RadGrid1.MasterTableView.ExportToCSV(); |
| } |
| protected void ExportXLSButton_Click(object sender, EventArgs e) |
| { |
| RadGrid1.MasterTableView.AllowPaging = false; |
| RadGrid1.MasterTableView.Rebind(); |
| RadGrid1.ExportSettings.IgnorePaging = true; |
| RadGrid1.MasterTableView.ExportToExcel(); |
| } |
| protected void ExportWRDButton_Click(object sender, EventArgs e) |
| { |
| RadGrid1.MasterTableView.AllowPaging = false; |
| RadGrid1.MasterTableView.Rebind(); |
| RadGrid1.ExportSettings.IgnorePaging = true; |
| RadGrid1.MasterTableView.ExportToWord(); |
| } |
| protected void ExportPDFButton_Click(object sender, EventArgs e) |
| { |
| RadGrid1.ExportSettings.Pdf.PageHeight = Unit.Parse("162mm"); |
| RadGrid1.ExportSettings.Pdf.PageWidth = Unit.Parse("600mm"); |
| RadGrid1.MasterTableView.AllowPaging = false; |
| RadGrid1.MasterTableView.Rebind(); |
| RadGrid1.ExportSettings.IgnorePaging = true; |
| RadGrid1.MasterTableView.ExportToPdf(); |
| } |