Hello,
I followed the article found in below link. When i run the page, only one line gets generated according to the values retireved last.
Thanks in advance
http://aspsnippets.com/Articles/ASPNet-AJAX-Line-Chart-Control-Multiple-Series-Populate-from-Database-example.aspx
C#
string query = string.Format("SELECT CHAR(CDATE, ISO),CSCUNITPRICE FROM UNITZ.DAILYLOG where fundcode = 'BAL'");
DataTable dt = GetData(query);
string[] x = new string[dt.Rows.Count];
decimal[] y = new decimal[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
x[i] = dt.Rows[i][0].ToString();
y[i] = Convert.ToDecimal(dt.Rows[i][1]);
}
LineChart1.Series.Add(new AjaxControlToolkit.LineChartSeries { Name = "BAL", Data = y });
query = string.Format("SELECT CHAR(CDATE, ISO),CSCUNITPRICE FROM UNITZ.DAILYLOG where fundcode = 'SEC'");
dt = GetData(query);
for (int i = 0; i < dt.Rows.Count; i++)
{
x[i] = dt.Rows[i][0].ToString();
y[i] = Convert.ToDecimal(dt.Rows[i][1]);
}
LineChart1.Series.Add(new AjaxControlToolkit.LineChartSeries { Name = "SEC", Data = y });
query = string.Format("SELECT CHAR(CDATE, ISO),CSCUNITPRICE FROM UNITZ.DAILYLOG where fundcode = 'GRW'");
dt = GetData(query);
for (int i = 0; i < dt.Rows.Count; i++)
{
x[i] = dt.Rows[i][0].ToString();
y[i] = Convert.ToDecimal(dt.Rows[i][1]);
}
LineChart1.Series.Add(new AjaxControlToolkit.LineChartSeries { Name = "GRW", Data = y });
LineChart1.CategoriesAxis = string.Join(",", x);
LineChart1.ChartTitle = string.Format("Price Progress");
LineChart1.Visible = true;
ASPX Page
<cc1:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</cc1:ToolkitScriptManager>
<hr />
<cc1:LineChart ID="LineChart1" runat="server" ChartHeight="600" ChartWidth="750"
ChartType="Basic" ChartTitleColor="#0E426C" Visible="false" CategoryAxisLineColor="#D08AD9"
ValueAxisLineColor="#D08AD9" BaseLineColor="#A156AB">
</cc1:LineChart>