<%@ Page Title="" Language="C#" MasterPageFile="~/Wijmo.Master" AutoEventWireup="true" CodeBehind="MultipleAxisDataBinding.aspx.cs" Inherits="ControlExplorer.C1CompositeChart.MultipleAxisDataBinding" %>
<%@ Register Assembly="C1.Web.Wijmo.Controls.4" Namespace="C1.Web.Wijmo.Controls.C1Chart" TagPrefix="wijmo" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
	<wijmo:C1CompositeChart runat="server" ID="CompositeChart1" Culture="en-US" DataSourceID="AccessDataSource1" Height="475" Width="756">
		<DataBindings>
			<wijmo:C1CompositeChartBinding Type="Column" YField="Sales" XField="CategoryName" />
			<wijmo:C1CompositeChartBinding Type="Line" YField="Sales1" XField="CategoryName" />
			<wijmo:C1CompositeChartBinding Type="Area" YField="Sales" XField="CategoryName" YAxis="1" />
		</DataBindings>
		<YAxes>
			<wijmo:CompositeChartYAxis Text="Y1 Axis" Compass="East" Max="150000" Min="0">
				<Height Value="200" />
			</wijmo:CompositeChartYAxis>
			<wijmo:CompositeChartYAxis Text="Y2 Axis" Compass="East" Max="140000">
				<Height IsAuto="true" />
			</wijmo:CompositeChartYAxis>
		</YAxes>
	</wijmo:C1CompositeChart>
	<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/C1NWind.mdb" SelectCommand="select top 6 CategoryName, sum(ProductSales) as Sales, sum(ProductSales) + 20000 as Sales1 from (SELECT DISTINCTROW Categories.CategoryName as CategoryName, Products.ProductName, Sum([Order Details Extended].ExtendedPrice) AS ProductSales
FROM Categories INNER JOIN (Products INNER JOIN (Orders INNER JOIN [Order Details Extended] ON Orders.OrderID = [Order Details Extended].OrderID) ON Products.ProductID = [Order Details Extended].ProductID) ON Categories.CategoryID = Products.CategoryID
WHERE (((Orders.OrderDate) Between #1/1/95# And #12/31/95#))
GROUP BY Categories.CategoryID, Categories.CategoryName, Products.ProductName
ORDER BY Products.ProductName) group by CategoryName;"></asp:AccessDataSource>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ControlOptions" runat="server">
</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="Description" runat="server">
	 <p>
        This sample shows how to bind data to <b>C1CompositeChart</b> control to render composite chart with multiple axes.
    </p>
</asp:Content>
