UltraWebChart - how to add data from a datasource

100

Alejandro posted over 16 years ago

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" >

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

<body>

<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">

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

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint> </Points>

</igchartprop:numericseries>

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

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint> </Points>

</igchartprop:numericseries>

</Series>

<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>

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

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

<Labels ItemFormatString="<ITEM_LABEL>" HorizontalAlign="Near" VerticalAlign="Center" Orientation="VerticalRightFacing">

</Labels>

</igchartprop:AxisItem>

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

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

</Labels>

</igchartprop:AxisItem>

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

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

</Labels>

</igchartprop:AxisItem>

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

</Labels>

</igchartprop:AxisItem>

</Axes>

</igchartprop:chartarea>

</ChartAreas>

</CompositeChart>

</ColorModel>

<igchartprop:gradienteffect></igchartprop:gradienteffect>

</Effects>

<Axis>

<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="<ITEM_LABEL>"

Orientation="VerticalLeftFacing" VerticalAlign="Center">

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

Orientation="VerticalLeftFacing" VerticalAlign="Center">

</Layout>

</SeriesLabels>

</Layout>

</Labels>

</X>

<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="<DATA_VALUE:00.##>"

Orientation="Horizontal" VerticalAlign="Center">

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

Orientation="Horizontal" VerticalAlign="Center">

</Layout>

</SeriesLabels>

</Layout>

</Labels>

</Y>

<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="<DATA_VALUE:00.##>"

Orientation="Horizontal" VerticalAlign="Center">

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

Orientation="Horizontal" VerticalAlign="Center">

</Layout>

</SeriesLabels>

</Layout>

</Labels>

</Y2>

<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="<ITEM_LABEL>"

Orientation="VerticalLeftFacing" VerticalAlign="Center">

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

Orientation="VerticalLeftFacing" VerticalAlign="Center">

</Layout>

</SeriesLabels>

</Layout>

</Labels>

</X2>

<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>

</SeriesLabels>

</Layout>

</Labels>

</Z>

<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>

</SeriesLabels>

</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 "COMMPAPER""></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" >

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

<body>

<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">

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

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint> </Points>

</igchartprop:numericseries>

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

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint>

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

</igchartprop:NumericDataPoint> </Points>

</igchartprop:numericseries>

</Series>

<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>

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

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

<Labels ItemFormatString="<ITEM_LABEL>" HorizontalAlign="Near" VerticalAlign="Center" Orientation="VerticalRightFacing">

</Labels>

</igchartprop:AxisItem>

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

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

</Labels>

</igchartprop:AxisItem>

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

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

</Labels>

</igchartprop:AxisItem>

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

</Labels>

</igchartprop:AxisItem>

</Axes>

</igchartprop:chartarea>

</ChartAreas>

</CompositeChart>

</ColorModel>

<igchartprop:gradienteffect></igchartprop:gradienteffect>

</Effects>

<Axis>

<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="<ITEM_LABEL>"

Orientation="VerticalLeftFacing" VerticalAlign="Center">

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

Orientation="VerticalLeftFacing" VerticalAlign="Center">

</Layout>

</SeriesLabels>

</Layout>

</Labels>

</X>

<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="<DATA_VALUE:00.##>"

Orientation="Horizontal" VerticalAlign="Center">

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

Orientation="Horizontal" VerticalAlign="Center">

</Layout>

</SeriesLabels>

</Layout>

</Labels>

</Y>

<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="<DATA_VALUE:00.##>"

Orientation="Horizontal" VerticalAlign="Center">

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

Orientation="Horizontal" VerticalAlign="Center">

</Layout>

</SeriesLabels>

</Layout>

</Labels>

</Y2>

<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="<ITEM_LABEL>"

Orientation="VerticalLeftFacing" VerticalAlign="Center">

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

Orientation="VerticalLeftFacing" VerticalAlign="Center">

</Layout>

</SeriesLabels>

</Layout>

</Labels>

</X2>

<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>

</SeriesLabels>

</Layout>

</Labels>

</Z>

<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>

</SeriesLabels>

</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 "COMMPAPER""></asp:SqlDataSource>

</div>

</form> </body>

</html>

Parents

28496

Offline David Negley posted over 16 years ago

The Series DataSources must be set in code; there is no design-time support for these properties right now.
Cancel
Reply

Cancel

Reply

100

Alejandro posted over 16 years ago in reply to David Negley

I have a table with a string, a number, and another number to populate the composite graph. what's the code to bind the results from that query to my existing composite graph? thanks.
Cancel
Reply

Cancel

Children

100

Alejandro posted over 16 years ago in reply to Travis

That usually means that there's no data coming from the datatable, you may not have binded it correctly. Ignore the "you need at least one numeric column" -- if there's no data since then there is no numeric column, so that's where that comes from..

I finally got mine to work a couple of days ago, here the code, I hope this helps:
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.OracleClient
Imports insidecf
Imports Infragistics.UltraChart.Shared.Styles
Imports Infragistics.UltraChart.Resources.Appearance
Imports Infragistics.UltraChart.Core.Layers

Partial Public Class _index
Inherits System.Web.UI.Page
Private Shared Function GetNumericSeriesPar(ByVal dt_in As DataTable) As NumericSeries
Dim series As New NumericSeries()
series.Label = "Maturity Date"

' this code populates the series from an external data source

series.Data.DataSource = dt_in

series.Data.LabelColumn = "Label Column"

series.Data.ValueColumn = "Value Column"
Return series
End Function
Private Shared Function GetNumericSeriesYield(ByVal dt_in As DataTable) As NumericSeries
Dim series As New NumericSeries()

series.Label = "Series Yield"

series.Data.DataSource = dt_in
series.Data.LabelColumn = "Label Column"

series.Data.ValueColumn = "Value Column"
Return seriesEnd Function

Protected Sub UltraChart1_ChartDataClicked(ByVal sender As Object, ByVal e As Infragistics.UltraChart.Shared.Events.ChartDataEventArgs) Handles UltraChart1.ChartDataClicked
End Sub

Public Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles UltraChart1.Load, Me.Load

'Dim upload_id As String

'upload_id = Request.QueryString("asofdate")

'upload_id = "10/07/2008"
Dim connection As OracleConnection
Dim command As OracleCommand
Dim adapter As OracleDataAdapter
' Dim ds As DataSet

Try

If Not IsPostBack Then

Dim connString As String
Dim sr As New System.IO.StreamReader("C:\commercialpaper.ini")Dim ds As New DataSet
connString = sr.ReadLine()
connection = New OracleConnection(connString)
connection.Open()
command = New OracleCommand

With command
.Connection = connection

.CommandType = CommandType.StoredProcedure

.CommandText = "P_COMMPAPER.CPR_GET_DATA_MAIN"

'.Parameters.Add(New OracleParameter("upload_id_in", OracleType.VarChar)).Direction = ParameterDirection.Input
.Parameters.Add(New OracleParameter("data_cursor", OracleType.Cursor)).Direction = ParameterDirection.Output
.Parameters.Add(New OracleParameter("data_cursor_p", OracleType.Cursor)).Direction = ParameterDirection.Output
.Parameters.Add(New OracleParameter("data_cursor_y", OracleType.Cursor)).Direction = ParameterDirection.Output
'.Parameters("upload_id_in").Value = upload_id

End With
adapter = New OracleDataAdapter(command)
adapter.Fill(ds)

Repeater1.DataSource = ds.Tables(0)

Repeater1.DataBind()
Me.UltraChart1.ChartType = ChartType.Composite
Dim myChartArea As New ChartArea()
Me.UltraChart1.CompositeChart.ChartAreas.Add(myChartArea)Dim axis1 As New AxisItem()
axis1.OrientationType = AxisNumber.X_Axis

axis1.DataType = AxisDataType.String

axis1.SetLabelAxisType = SetLabelAxisType.GroupBySeries

'axis1.Visible = False

axis1.Labels.ItemFormatString = "<ITEM_LABEL>"

axis1.Labels.Orientation = TextOrientation.VerticalRightFacing

axis1.Labels.HorizontalAlign = Drawing.StringAlignment.Center

axis1.Labels.VerticalAlign = Drawing.StringAlignment.Center

'axis1.Extent = 80

axis1.TickmarkStyle = AxisTickStyle.DataInterval

axis1.TickmarkInterval = "1"

'axis1.TickmarkStyle = AxisTickStyle.Smart

'axis1.TickmarkInterval = "0"

myChartArea.Axes.Add(axis1)
Dim axis2 As New AxisItem()
axis2.OrientationType = AxisNumber.Y_Axis

axis2.DataType = AxisDataType.Numeric

axis2.SetLabelAxisType = SetLabelAxisType.GroupBySeries

axis2.Labels.ItemFormatString = "<DATA_VALUE:$0,000,000>"

axis2.Labels.HorizontalAlign = Drawing.StringAlignment.Near

axis2.Labels.VerticalAlign = Drawing.StringAlignment.Center

axis2.TickmarkStyle = AxisTickStyle.Smart

axis2.LineThickness = 1

axis2.LineColor = Drawing.Color.Black

'axis2.Extent = 120

'axis2.TickmarkInterval = "20000000"

myChartArea.Axes.Add(axis2)

Dim axis3 As New AxisItem()
axis3.OrientationType = AxisNumber.X_Axis

axis3.DataType = AxisDataType.String

axis3.SetLabelAxisType = SetLabelAxisType.ContinuousData

axis3.Visible = False

axis3.Labels.HorizontalAlign = Drawing.StringAlignment.Near

axis3.Labels.VerticalAlign = Drawing.StringAlignment.Center

axis3.Labels.Orientation = TextOrientation.VerticalRightFacing

axis3.LineColor = Drawing.Color.Black

axis3.LineThickness = 1

axis3.TickmarkInterval = "1"

axis3.Labels.ItemFormatString = "<ITEM_LABEL>"

'axis3.Labels.Orientation = TextOrientation.VerticalLeftFacing

'axis3.TickmarkInterval = "0"

myChartArea.Axes.Add(axis3)

Dim axis4 As New AxisItem()
axis4.OrientationType = AxisNumber.Y2_Axis

axis4.DataType = AxisDataType.Numeric

axis4.SetLabelAxisType = SetLabelAxisType.GroupBySeries

axis4.Labels.ItemFormatString = "<DATA_VALUE:0.##>"

axis4.Labels.HorizontalAlign = Drawing.StringAlignment.Near

axis4.Labels.VerticalAlign = Drawing.StringAlignment.Center

axis4.Labels.Orientation = TextOrientation.Horizontal

axis4.LineColor = Drawing.Color.Black

axis4.LineThickness = 1

axis4.TickmarkStyle = AxisTickStyle.DataInterval

axis4.TickmarkInterval = ".0343"

myChartArea.Axes.Add(axis4)
Dim seriesPar As NumericSeries = GetNumericSeriesPar(ds.Tables(1))
Dim seriesYield As NumericSeries = GetNumericSeriesYield(ds.Tables(2))
Me.UltraChart1.CompositeChart.Series.Add(seriesPar)
Me.UltraChart1.CompositeChart.Series.Add(seriesYield)

'Me.UltraChart2.CompositeChart.Series.Add(seriesPar)

'Me.UltraChart2.CompositeChart.Series.Add(seriesYield)
Dim myColumnLayer As New ChartLayerAppearance()
myColumnLayer.ChartType = ChartType.ColumnChart

myColumnLayer.ChartArea = myChartArea

myColumnLayer.AxisX = axis1

myColumnLayer.AxisY = axis2

myColumnLayer.Series.Add(seriesPar)
Dim myLineLayer As New ChartLayerAppearance()
myLineLayer.ChartType = ChartType.LineChart

myLineLayer.AxisX = axis3

myLineLayer.AxisY = axis4

myLineLayer.ChartArea = myChartArea

myLineLayer.Series.Add(seriesYield)

Dim myLegend As New CompositeLegend()
myLegend.ChartLayers.Add(myColumnLayer)

'myLegend.Bounds = New Rectangle(0, 75, 20, 25)

myLegend.BoundsMeasureType = MeasureType.Percentage

myLegend.PE.ElementType = PaintElementType.Gradient

myLegend.PE.FillGradientStyle = GradientStyle.ForwardDiagonal

'myLegend.PE.Fill = Color.CornflowerBlue

'myLegend.PE.FillStopColor = Color.Transparent

myLegend.Border.CornerRadius = 10

myLegend.Border.Thickness = 0

'Me.UltraChart1.CompositeChart.Legends.Add(myLegend)

' Me.UltraChart1.Axis.Y.MajorGridLines.Visible = False

' Me.UltraChart1.Axis.Y.MinorGridLines.Visible = False

' Me.UltraChart1.Axis.X.MajorGridLines.Visible = False

' Me.UltraChart1.Axis.X.MinorGridLines.Visible = False
Me.UltraChart1.LineChart.DrawStyle = Infragistics.UltraChart.[Shared].Styles.LineDrawStyle.Dash
Me.UltraChart1.CompositeChart.ChartLayers.Add(myColumnLayer)
Me.UltraChart1.CompositeChart.ChartLayers.Add(myLineLayer)

ds = Nothing

connection.Close()

End If
Catch ex As Exception
connection.Close()

Finally

adapter = Nothing

command = Nothing

connection = Nothing

End Try
End Sub

Protected Sub Repeater1_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.RepeaterCommandEventArgs) Handles Repeater1.ItemCommandEnd Sub

End Class
Cancel
Reply

Cancel
28496

Offline David Negley posted over 16 years ago in reply to Travis

there are a couple potential causes to this problem, so some sample code or sample data might help. one suggestion- make sure the columns in your DataTable have their DataType property set to some numeric type.
Cancel
Reply

Cancel
2349

Travis posted over 16 years ago in reply to David Negley

What does the following mean:
Line Chart Error: You must have at least one row and one numeric column

I am just setting my datasource to my table and binding. Do I need to do more? This is ultrawebchart product btw
Cancel
Reply

Cancel
28496

Offline David Negley posted over 16 years ago in reply to Alejandro

NumericSeries mySeries = new NumericSeries();
mySeries.Data.DataSource = myTable;
mySeries.Data.ValuesColumn = "ValuesA";
mySeries.Data.LabelsColumn = "Label";

NumericSeries mySeries2 = new NumericSeries();
mySeries2.Data.DataSource = myTable;
mySeries.Data.ValuesColumn = "ValuesB";
mySeries.Data.LabelsColumn = "Label";
Cancel
Reply

Cancel