Forums Ultimate UI for ASP.NET Web Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Alejandro
100
UltraWebChart - how to add data from a datasource
posted

 

Does anyone have an example of how I can replace the data in the series (which in inputted manually from the chart wizard) with the data from the datasouce?  I set up the data source and it works but I don't know what the appropiate control markup is to populate the chart with the data from the database...any help would be appreciated.

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<%@ Register Assembly="Infragistics35.WebUI.UltraWebChart.v8.2, Version=8.2.20082.1000, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb"

Namespace="Infragistics.WebUI.UltraWebChart" TagPrefix="igchart" %>

<%@ Register Assembly="Infragistics35.WebUI.UltraWebChart.v8.2, Version=8.2.20082.1000, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb"

Namespace="Infragistics.UltraChart.Resources.Appearance" TagPrefix="igchartprop" %>

<%@ Register Assembly="Infragistics35.WebUI.UltraWebChart.v8.2, Version=8.2.20082.1000, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb"

Namespace="Infragistics.UltraChart.Data" TagPrefix="igchartdata" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" >

<head id="Head1" runat="server">

<title>Untitled Page</title> </head>

<body>

<form id="form1" runat="server">

<div>

<igchart:UltraChart ID="UltraChart1" runat="server" BackgroundImageFileName="" BorderColor="Black"

BorderWidth="1px" ChartType="Composite" EmptyChartText="Data Not Available. Please call UltraChart.Data.DataBind() after setting valid Data.DataSource"

Version="8.2" Width="571px" DataSourceID="commpaper">

<CompositeChart>

<Series>

 

<igchartprop:numericseries key="series1"><Points>

<igchartprop:NumericDataPoint Value="72088000" Label="09/03/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="55000000" Label="09/04/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="91217000" Label="09/05/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="63147000" Label="09/08/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="117245000" Label="09/09/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="119227000" Label="09/10/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="42652000" Label="09/12/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="19239000" Label="09/16/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="42881000" Label="09/17/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="81059000" Label="09/18/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="63321000" Label="09/19/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="27058000" Label="09/23/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="61100000" Label="09/25/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="60105000" Label="10/01/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="111230000" Label="10/06/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="54638000" Label="10/08/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="26877000" Label="10/10/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="39324000" Label="10/16/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="35213000" Label="10/27/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="60516000" Label="11/03/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint> </Points>

</igchartprop:numericseries>

<igchartprop:numericseries key="series2"><Points>

<igchartprop:NumericDataPoint Value="2.205391" Label="09/03/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.214154" Label="09/04/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.211008667" Label="09/05/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.204581" Label="09/08/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.218386667" Label="09/09/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.212411667" Label="09/10/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.184895" Label="09/12/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.204446" Label="09/16/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.205932" Label="09/17/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.205796" Label="09/18/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.195744" Label="09/19/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.204716" Label="09/23/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.2060665" Label="09/25/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.15373" Label="10/01/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.2230665" Label="10/06/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.214991333" Label="10/08/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.186735" Label="10/10/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.218034" Label="10/16/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.258894" Label="10/27/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.17814" Label="11/03/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint> </Points>

</igchartprop:numericseries>

</Series>

<ChartLayers>

<igchartprop:chartlayerappearance axisxkey="axis1" axisykey="axis2" chartareakey="area1"

charttype="ColumnChart" key="chartLayer1" serieslist="series1"><ChartTypeAppearances>

<igchartprop:ColumnChartAppearance></igchartprop:ColumnChartAppearance>

</ChartTypeAppearances>

</igchartprop:chartlayerappearance>

<igchartprop:chartlayerappearance axisxkey="axis4" axisykey="axis3" chartareakey="area1"

charttype="LineChart" key="chartLayer2" serieslist="series2"><ChartTypeAppearances>

<igchartprop:LineChartAppearance Thickness="2" StartStyle="SquareAnchor" HighLightLines="True"></igchartprop:LineChartAppearance>

</ChartTypeAppearances>

</igchartprop:chartlayerappearance>

</ChartLayers>

<ChartAreas>

<igchartprop:chartarea key="area1"><Axes>

<igchartprop:AxisItem Key="axis1" OrientationType="X_Axis" DataType="String" SetLabelAxisType="GroupBySeries" TickmarkInterval="0">

<MajorGridLines Visible="True" DrawStyle="Dot" Color="Gainsboro" Thickness="1" AlphaLevel="255"></MajorGridLines>

<MinorGridLines Visible="False" DrawStyle="Dot" Color="LightGray" Thickness="1" AlphaLevel="255"></MinorGridLines>

<Labels ItemFormatString="&lt;ITEM_LABEL&gt;" HorizontalAlign="Near" VerticalAlign="Center" Orientation="VerticalRightFacing">

<SeriesLabels HorizontalAlign="Center" VerticalAlign="Center" Orientation="Horizontal"></SeriesLabels>

</Labels>

</igchartprop:AxisItem>

<igchartprop:AxisItem Key="axis2" OrientationType="Y_Axis" DataType="Numeric" SetLabelAxisType="GroupBySeries" TickmarkStyle="Smart" TickmarkInterval="20000000">

<MajorGridLines Visible="True" DrawStyle="Dot" Color="Gainsboro" Thickness="1" AlphaLevel="255"></MajorGridLines>

<MinorGridLines Visible="False" DrawStyle="Dot" Color="LightGray" Thickness="1" AlphaLevel="255"></MinorGridLines>

<Labels ItemFormatString="&lt;DATA_VALUE:00.##&gt;" HorizontalAlign="Near" VerticalAlign="Center" Orientation="Horizontal">

<SeriesLabels HorizontalAlign="Center" VerticalAlign="Center" Orientation="Horizontal"></SeriesLabels>

</Labels>

</igchartprop:AxisItem>

<igchartprop:AxisItem Key="axis3" OrientationType="Y2_Axis" DataType="Numeric" SetLabelAxisType="GroupBySeries" TickmarkStyle="Smart" TickmarkInterval="0.02">

<MajorGridLines Visible="True" DrawStyle="Dot" Color="Gainsboro" Thickness="1" AlphaLevel="255"></MajorGridLines>

<MinorGridLines Visible="False" DrawStyle="Dot" Color="LightGray" Thickness="1" AlphaLevel="255"></MinorGridLines>

<Labels ItemFormatString="&lt;DATA_VALUE:00.##&gt;" HorizontalAlign="Near" VerticalAlign="Center" Orientation="Horizontal">

<SeriesLabels HorizontalAlign="Center" VerticalAlign="Center" Orientation="Horizontal"></SeriesLabels>

</Labels>

</igchartprop:AxisItem>

<igchartprop:AxisItem Key="axis4" OrientationType="X_Axis" DataType="String" SetLabelAxisType="ContinuousData" TickmarkInterval="0">

<MajorGridLines Visible="True" DrawStyle="Dot" Color="Gainsboro" Thickness="1" AlphaLevel="255"></MajorGridLines>

<MinorGridLines Visible="False" DrawStyle="Dot" Color="LightGray" Thickness="1" AlphaLevel="255"></MinorGridLines>

<Labels ItemFormatString="" HorizontalAlign="Near" VerticalAlign="Center" Orientation="Horizontal">

<SeriesLabels HorizontalAlign="Center" VerticalAlign="Center" Orientation="Horizontal"></SeriesLabels>

</Labels>

</igchartprop:AxisItem>

</Axes>

<PE Fill="LightYellow"></PE> <GridPE ElementType="None"></GridPE>

</igchartprop:chartarea>

</ChartAreas>

</CompositeChart>

<ColorModel AlphaLevel="150" ColorBegin="Pink" ColorEnd="DarkRed" ModelStyle="CustomLinear">

</ColorModel>

<Effects>

<Effects>

<igchartprop:gradienteffect></igchartprop:gradienteffect>

</Effects>

</Effects>

<Axis>

<PE ElementType="None" Fill="Cornsilk" />

<X LineThickness="1" TickmarkInterval="0" TickmarkStyle="Smart" Visible="True">

<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"

Visible="True" />

<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"

Visible="False" />

<Labels Font="Verdana, 7pt" FontColor="DimGray" HorizontalAlign="Near" ItemFormatString="&lt;ITEM_LABEL&gt;"

Orientation="VerticalLeftFacing" VerticalAlign="Center">

<SeriesLabels Font="Verdana, 7pt" FontColor="DimGray" FormatString="" HorizontalAlign="Near"

Orientation="VerticalLeftFacing" VerticalAlign="Center">

<Layout Behavior="Auto">

</Layout>

</SeriesLabels>

<Layout Behavior="Auto">

</Layout>

</Labels>

</X>

<Y LineThickness="1" TickmarkInterval="0.1" TickmarkStyle="Smart" Visible="True">

<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"

Visible="True" />

<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"

Visible="False" />

<Labels Font="Verdana, 7pt" FontColor="DimGray" HorizontalAlign="Far" ItemFormatString="&lt;DATA_VALUE:00.##&gt;"

Orientation="Horizontal" VerticalAlign="Center">

<SeriesLabels Font="Verdana, 7pt" FontColor="DimGray" FormatString="" HorizontalAlign="Far"

Orientation="Horizontal" VerticalAlign="Center">

<Layout Behavior="Auto">

</Layout>

</SeriesLabels>

<Layout Behavior="Auto">

</Layout>

</Labels>

</Y>

<Y2 LineThickness="1" TickmarkInterval="0" TickmarkStyle="Smart" Visible="False">

<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"

Visible="True" />

<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"

Visible="False" />

<Labels Font="Verdana, 7pt" FontColor="Gray" HorizontalAlign="Near" ItemFormatString="&lt;DATA_VALUE:00.##&gt;"

Orientation="Horizontal" VerticalAlign="Center">

<SeriesLabels Font="Verdana, 7pt" FontColor="Gray" FormatString="" HorizontalAlign="Near"

Orientation="Horizontal" VerticalAlign="Center">

<Layout Behavior="Auto">

</Layout>

</SeriesLabels>

<Layout Behavior="Auto">

</Layout>

</Labels>

</Y2>

<X2 LineThickness="1" TickmarkInterval="0" TickmarkStyle="Smart" Visible="False">

<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"

Visible="True" />

<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"

Visible="False" />

<Labels Font="Verdana, 7pt" FontColor="Gray" HorizontalAlign="Far" ItemFormatString="&lt;ITEM_LABEL&gt;"

Orientation="VerticalLeftFacing" VerticalAlign="Center">

<SeriesLabels Font="Verdana, 7pt" FontColor="Gray" FormatString="" HorizontalAlign="Far"

Orientation="VerticalLeftFacing" VerticalAlign="Center">

<Layout Behavior="Auto">

</Layout>

</SeriesLabels>

<Layout Behavior="Auto">

</Layout>

</Labels>

</X2>

<Z LineThickness="1" TickmarkInterval="0" TickmarkStyle="Smart" Visible="False">

<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"

Visible="True" />

<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"

Visible="False" />

<Labels Font="Verdana, 7pt" FontColor="DimGray" HorizontalAlign="Near" ItemFormatString=""

Orientation="Horizontal" VerticalAlign="Center">

<SeriesLabels Font="Verdana, 7pt" FontColor="DimGray" HorizontalAlign="Near" Orientation="Horizontal"

VerticalAlign="Center">

<Layout Behavior="Auto">

</Layout>

</SeriesLabels>

<Layout Behavior="Auto">

</Layout>

</Labels>

</Z>

<Z2 LineThickness="1" TickmarkInterval="0" TickmarkStyle="Smart" Visible="False">

<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"

Visible="True" />

<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"

Visible="False" />

<Labels Font="Verdana, 7pt" FontColor="Gray" HorizontalAlign="Near" ItemFormatString=""

Orientation="Horizontal" VerticalAlign="Center">

<SeriesLabels Font="Verdana, 7pt" FontColor="Gray" HorizontalAlign="Near" Orientation="Horizontal"

VerticalAlign="Center">

<Layout Behavior="Auto">

</Layout>

</SeriesLabels>

<Layout Behavior="Auto">

</Layout>

</Labels>

</Z2>

</Axis>

</igchart:UltraChart>

 

<asp:SqlDataSource ID="commpaper" runat="server"

ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"

SelectCommand="SELECT PAR_AMT, YIELD FROM &quot;COMMPAPER&quot;"></asp:SqlDataSource>

 

</div>

</form>

</body>

</html> <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<%@ Register Assembly="Infragistics35.WebUI.UltraWebChart.v8.2, Version=8.2.20082.1000, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb"

Namespace="Infragistics.WebUI.UltraWebChart" TagPrefix="igchart" %>

<%@ Register Assembly="Infragistics35.WebUI.UltraWebChart.v8.2, Version=8.2.20082.1000, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb"

Namespace="Infragistics.UltraChart.Resources.Appearance" TagPrefix="igchartprop" %>

<%@ Register Assembly="Infragistics35.WebUI.UltraWebChart.v8.2, Version=8.2.20082.1000, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb"

Namespace="Infragistics.UltraChart.Data" TagPrefix="igchartdata" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" >

<head id="Head1" runat="server">

<title>Untitled Page</title> </head>

<body>

<form id="form1" runat="server">

<div>

<igchart:UltraChart ID="UltraChart1" runat="server" BackgroundImageFileName="" BorderColor="Black"

BorderWidth="1px" ChartType="Composite" EmptyChartText="Data Not Available. Please call UltraChart.Data.DataBind() after setting valid Data.DataSource"

Version="8.2" Width="571px" DataSourceID="commpaper">

<CompositeChart>

<Series>

 

<igchartprop:numericseries key="series1"><Points>

<igchartprop:NumericDataPoint Value="72088000" Label="09/03/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="55000000" Label="09/04/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="91217000" Label="09/05/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="63147000" Label="09/08/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="117245000" Label="09/09/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="119227000" Label="09/10/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="42652000" Label="09/12/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="19239000" Label="09/16/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="42881000" Label="09/17/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="81059000" Label="09/18/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="63321000" Label="09/19/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="27058000" Label="09/23/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="61100000" Label="09/25/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="60105000" Label="10/01/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="111230000" Label="10/06/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="54638000" Label="10/08/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="26877000" Label="10/10/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="39324000" Label="10/16/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="35213000" Label="10/27/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="60516000" Label="11/03/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint> </Points>

</igchartprop:numericseries>

<igchartprop:numericseries key="series2"><Points>

<igchartprop:NumericDataPoint Value="2.205391" Label="09/03/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.214154" Label="09/04/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.211008667" Label="09/05/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.204581" Label="09/08/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.218386667" Label="09/09/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.212411667" Label="09/10/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.184895" Label="09/12/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.204446" Label="09/16/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.205932" Label="09/17/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.205796" Label="09/18/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.195744" Label="09/19/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.204716" Label="09/23/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.2060665" Label="09/25/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.15373" Label="10/01/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.2230665" Label="10/06/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.214991333" Label="10/08/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.186735" Label="10/10/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.218034" Label="10/16/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.258894" Label="10/27/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint>

<igchartprop:NumericDataPoint Value="2.17814" Label="11/03/2008">

<PE ElementType="None"></PE>

</igchartprop:NumericDataPoint> </Points>

</igchartprop:numericseries>

</Series>

<ChartLayers>

<igchartprop:chartlayerappearance axisxkey="axis1" axisykey="axis2" chartareakey="area1"

charttype="ColumnChart" key="chartLayer1" serieslist="series1"><ChartTypeAppearances>

<igchartprop:ColumnChartAppearance></igchartprop:ColumnChartAppearance>

</ChartTypeAppearances>

</igchartprop:chartlayerappearance>

<igchartprop:chartlayerappearance axisxkey="axis4" axisykey="axis3" chartareakey="area1"

charttype="LineChart" key="chartLayer2" serieslist="series2"><ChartTypeAppearances>

<igchartprop:LineChartAppearance Thickness="2" StartStyle="SquareAnchor" HighLightLines="True"></igchartprop:LineChartAppearance>

</ChartTypeAppearances>

</igchartprop:chartlayerappearance>

</ChartLayers>

<ChartAreas>

<igchartprop:chartarea key="area1"><Axes>

<igchartprop:AxisItem Key="axis1" OrientationType="X_Axis" DataType="String" SetLabelAxisType="GroupBySeries" TickmarkInterval="0">

<MajorGridLines Visible="True" DrawStyle="Dot" Color="Gainsboro" Thickness="1" AlphaLevel="255"></MajorGridLines>

<MinorGridLines Visible="False" DrawStyle="Dot" Color="LightGray" Thickness="1" AlphaLevel="255"></MinorGridLines>

<Labels ItemFormatString="&lt;ITEM_LABEL&gt;" HorizontalAlign="Near" VerticalAlign="Center" Orientation="VerticalRightFacing">

<SeriesLabels HorizontalAlign="Center" VerticalAlign="Center" Orientation="Horizontal"></SeriesLabels>

</Labels>

</igchartprop:AxisItem>

<igchartprop:AxisItem Key="axis2" OrientationType="Y_Axis" DataType="Numeric" SetLabelAxisType="GroupBySeries" TickmarkStyle="Smart" TickmarkInterval="20000000">

<MajorGridLines Visible="True" DrawStyle="Dot" Color="Gainsboro" Thickness="1" AlphaLevel="255"></MajorGridLines>

<MinorGridLines Visible="False" DrawStyle="Dot" Color="LightGray" Thickness="1" AlphaLevel="255"></MinorGridLines>

<Labels ItemFormatString="&lt;DATA_VALUE:00.##&gt;" HorizontalAlign="Near" VerticalAlign="Center" Orientation="Horizontal">

<SeriesLabels HorizontalAlign="Center" VerticalAlign="Center" Orientation="Horizontal"></SeriesLabels>

</Labels>

</igchartprop:AxisItem>

<igchartprop:AxisItem Key="axis3" OrientationType="Y2_Axis" DataType="Numeric" SetLabelAxisType="GroupBySeries" TickmarkStyle="Smart" TickmarkInterval="0.02">

<MajorGridLines Visible="True" DrawStyle="Dot" Color="Gainsboro" Thickness="1" AlphaLevel="255"></MajorGridLines>

<MinorGridLines Visible="False" DrawStyle="Dot" Color="LightGray" Thickness="1" AlphaLevel="255"></MinorGridLines>

<Labels ItemFormatString="&lt;DATA_VALUE:00.##&gt;" HorizontalAlign="Near" VerticalAlign="Center" Orientation="Horizontal">

<SeriesLabels HorizontalAlign="Center" VerticalAlign="Center" Orientation="Horizontal"></SeriesLabels>

</Labels>

</igchartprop:AxisItem>

<igchartprop:AxisItem Key="axis4" OrientationType="X_Axis" DataType="String" SetLabelAxisType="ContinuousData" TickmarkInterval="0">

<MajorGridLines Visible="True" DrawStyle="Dot" Color="Gainsboro" Thickness="1" AlphaLevel="255"></MajorGridLines>

<MinorGridLines Visible="False" DrawStyle="Dot" Color="LightGray" Thickness="1" AlphaLevel="255"></MinorGridLines>

<Labels ItemFormatString="" HorizontalAlign="Near" VerticalAlign="Center" Orientation="Horizontal">

<SeriesLabels HorizontalAlign="Center" VerticalAlign="Center" Orientation="Horizontal"></SeriesLabels>

</Labels>

</igchartprop:AxisItem>

</Axes>

<PE Fill="LightYellow"></PE> <GridPE ElementType="None"></GridPE>

</igchartprop:chartarea>

</ChartAreas>

</CompositeChart>

<ColorModel AlphaLevel="150" ColorBegin="Pink" ColorEnd="DarkRed" ModelStyle="CustomLinear">

</ColorModel>

<Effects>

<Effects>

<igchartprop:gradienteffect></igchartprop:gradienteffect>

</Effects>

</Effects>

<Axis>

<PE ElementType="None" Fill="Cornsilk" />

<X LineThickness="1" TickmarkInterval="0" TickmarkStyle="Smart" Visible="True">

<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"

Visible="True" />

<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"

Visible="False" />

<Labels Font="Verdana, 7pt" FontColor="DimGray" HorizontalAlign="Near" ItemFormatString="&lt;ITEM_LABEL&gt;"

Orientation="VerticalLeftFacing" VerticalAlign="Center">

<SeriesLabels Font="Verdana, 7pt" FontColor="DimGray" FormatString="" HorizontalAlign="Near"

Orientation="VerticalLeftFacing" VerticalAlign="Center">

<Layout Behavior="Auto">

</Layout>

</SeriesLabels>

<Layout Behavior="Auto">

</Layout>

</Labels>

</X>

<Y LineThickness="1" TickmarkInterval="0.1" TickmarkStyle="Smart" Visible="True">

<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"

Visible="True" />

<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"

Visible="False" />

<Labels Font="Verdana, 7pt" FontColor="DimGray" HorizontalAlign="Far" ItemFormatString="&lt;DATA_VALUE:00.##&gt;"

Orientation="Horizontal" VerticalAlign="Center">

<SeriesLabels Font="Verdana, 7pt" FontColor="DimGray" FormatString="" HorizontalAlign="Far"

Orientation="Horizontal" VerticalAlign="Center">

<Layout Behavior="Auto">

</Layout>

</SeriesLabels>

<Layout Behavior="Auto">

</Layout>

</Labels>

</Y>

<Y2 LineThickness="1" TickmarkInterval="0" TickmarkStyle="Smart" Visible="False">

<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"

Visible="True" />

<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"

Visible="False" />

<Labels Font="Verdana, 7pt" FontColor="Gray" HorizontalAlign="Near" ItemFormatString="&lt;DATA_VALUE:00.##&gt;"

Orientation="Horizontal" VerticalAlign="Center">

<SeriesLabels Font="Verdana, 7pt" FontColor="Gray" FormatString="" HorizontalAlign="Near"

Orientation="Horizontal" VerticalAlign="Center">

<Layout Behavior="Auto">

</Layout>

</SeriesLabels>

<Layout Behavior="Auto">

</Layout>

</Labels>

</Y2>

<X2 LineThickness="1" TickmarkInterval="0" TickmarkStyle="Smart" Visible="False">

<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"

Visible="True" />

<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"

Visible="False" />

<Labels Font="Verdana, 7pt" FontColor="Gray" HorizontalAlign="Far" ItemFormatString="&lt;ITEM_LABEL&gt;"

Orientation="VerticalLeftFacing" VerticalAlign="Center">

<SeriesLabels Font="Verdana, 7pt" FontColor="Gray" FormatString="" HorizontalAlign="Far"

Orientation="VerticalLeftFacing" VerticalAlign="Center">

<Layout Behavior="Auto">

</Layout>

</SeriesLabels>

<Layout Behavior="Auto">

</Layout>

</Labels>

</X2>

<Z LineThickness="1" TickmarkInterval="0" TickmarkStyle="Smart" Visible="False">

<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"

Visible="True" />

<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"

Visible="False" />

<Labels Font="Verdana, 7pt" FontColor="DimGray" HorizontalAlign="Near" ItemFormatString=""

Orientation="Horizontal" VerticalAlign="Center">

<SeriesLabels Font="Verdana, 7pt" FontColor="DimGray" HorizontalAlign="Near" Orientation="Horizontal"

VerticalAlign="Center">

<Layout Behavior="Auto">

</Layout>

</SeriesLabels>

<Layout Behavior="Auto">

</Layout>

</Labels>

</Z>

<Z2 LineThickness="1" TickmarkInterval="0" TickmarkStyle="Smart" Visible="False">

<MajorGridLines AlphaLevel="255" Color="Gainsboro" DrawStyle="Dot" Thickness="1"

Visible="True" />

<MinorGridLines AlphaLevel="255" Color="LightGray" DrawStyle="Dot" Thickness="1"

Visible="False" />

<Labels Font="Verdana, 7pt" FontColor="Gray" HorizontalAlign="Near" ItemFormatString=""

Orientation="Horizontal" VerticalAlign="Center">

<SeriesLabels Font="Verdana, 7pt" FontColor="Gray" HorizontalAlign="Near" Orientation="Horizontal"

VerticalAlign="Center">

<Layout Behavior="Auto">

</Layout>

</SeriesLabels>

<Layout Behavior="Auto">

</Layout>

</Labels>

</Z2>

</Axis>

</igchart:UltraChart>

 

<asp:SqlDataSource ID="commpaper" runat="server"

ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"

SelectCommand="SELECT PAR_AMT, YIELD FROM &quot;COMMPAPER&quot;"></asp:SqlDataSource>

 

</div>

</form> </body>

</html>