<%@ Page Language="C#" Inherits="Telerik.GridExamplesCSharp.Exporting.ExportToExcel.DefaultCS"CodeFile="DefaultCS.aspx.cs" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<%@ Register TagPrefix="qsf" Namespace="Telerik.QuickStart" %>
<!DOCTYPE html>
<html xmlns='http://www.w3.org/1999/xhtml'>
<head runat="server">
<title>Telerik ASP.NET Example</title>
</head>
<body>
<form id="form1" runat="server">
<telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
<telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" />
<div class="demo-container no-bg">
<telerik:RadButton RenderMode="Lightweight" ID="RadButton1" runat="server" Text="Export All Grids"
Height="30px" OnClick="RadButton1_Click">
<Icon PrimaryIconCssClass="p-i-file-xlsx"></Icon>
</telerik:RadButton>
<br />
<br />
<telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" CellSpacing="0"
DataSourceID="SqlDataSource1" GridLines="None" PageSize="3"
OnColumnCreated="RadGrids_ColumnCreated">
<ExportSettings IgnorePaging="true" ExportOnlyData="true">
<Excel Format="Xlsx" WorksheetName="Orders" AutoFitColumnWidth="AutoFitExpandOnly" />
</ExportSettings>
<MasterTableView DataSourceID="SqlDataSource1" DataKeyNames="OrderID">
</MasterTableView>
</telerik:RadGrid>
<br />
<telerik:RadGrid ID="RadGrid2" runat="server" AllowPaging="True" CellSpacing="0"
DataSourceID="SqlDataSource2" GridLines="None" PageSize="3"
OnColumnCreated="RadGrids_ColumnCreated">
<ExportSettings IgnorePaging="true" ExportOnlyData="true">
<Excel Format="Xlsx" WorksheetName="Customers" AutoFitColumnWidth="AutoFitExpandOnly" />
</ExportSettings>
<MasterTableView DataSourceID="SqlDataSource2" DataKeyNames="CustomerID">
</MasterTableView>
</telerik:RadGrid>
<br />
<telerik:RadGrid ID="RadGrid3" runat="server" AllowPaging="True" CellSpacing="0"
DataSourceID="SqlDataSource3" GridLines="None" PageSize="3"
OnColumnCreated="RadGrids_ColumnCreated">
<ExportSettings IgnorePaging="true" ExportOnlyData="true">
<Excel Format="Xlsx" WorksheetName="Products" AutoFitColumnWidth="AutoFitExpandOnly" />
</ExportSettings>
<MasterTableView DataSourceID="SqlDataSource3" DataKeyNames="ProductID">
</MasterTableView>
</telerik:RadGrid>
</div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT [OrderID], [OrderDate], [Freight], [ShipName], [ShipCountry] FROM [Orders]"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT [CustomerID], [ContactName], [CompanyName], [ContactTitle], [Country] FROM [Customers]"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource3" runat="server"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT [ProductID], [ProductName], [SupplierID], [CategoryID], [UnitPrice] FROM [Products]"></asp:SqlDataSource>
</form>
</body>
</html>