bar chart not displaying

Hi, kindly asking for help.Am using ajax toolkit to draw a bar chart from the database but once i run my web page it does not display..the problem is on the line code i have highlighted in red...help me wat to set to make it visible..

this is my code;

public void BindGrid()
{
string query = "select Customer, COUNT([Total Amount]) [Total Amount] from CustomerDebts group by Customer";
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.ToInt32(dt.Rows[i][1]);
}
BarChart1.Series.Add(new AjaxControlToolkit.BarChartSeries { Data = y });
BarChart1.CategoriesAxis = string.Join(",", x);
if (x.Length > 3)
{
BarChart1.ChartWidth = (x.Length * 150).ToString();
}
BarChart1.Visible=

}
private static DataTable GetData(string query)
{
DataTable dt = new DataTable();
string constr = TraceBizCommon.Configuration.ConfigSettings.ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(query))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
sda.SelectCommand = cmd;
sda.Fill(dt);
}
}
return dt;
}
}

Hi John,

Have you tried to execute by commenting "BarChart1.Visible=" line ?

I think in your case it's not needed.

Below code works for me:

protected void BindChart()
{
SqlConnection conn = new SqlConnection("Data Source=TEST;Initial Catalog=Northwind;Integrated Security=True");
DataSet ds = new DataSet();
DataTable dt = new DataTable();
conn.Open();
string cmdstr = "select top 10 Employee, COUNT(ProjectName) [Total Project] from [EmployeeProject] group by Employee";
SqlCommand cmd = new SqlCommand(cmdstr, conn);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(ds);
dt = ds.Tables[0];
string category="";
decimal[] values = new decimal[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
category = category + "," + dt.Rows[i]["Employee"].ToString();
values[i] = Convert.ToDecimal(dt.Rows[i]["Total Project"]);
}
BarChart1.CategoriesAxis = category.Remove(0, 1);
BarChart1.Series.Add(new AjaxControlToolkit.BarChartSeries { Data = values, BarColor="#2fd1f9", Name = "EmployeeProject" });
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nakul Chaudhari8y ago
Hi John,

Have you tried to execute by commenting "BarChart1.Visible=" line ?
I think in your case it's not needed.

Below code works for me:
protected void BindChart()
    {
        SqlConnection conn = new SqlConnection("Data Source=TEST;Initial Catalog=Northwind;Integrated Security=True");
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        conn.Open();
        string cmdstr = "select top 10 Employee, COUNT(ProjectName) [Total Project] from [EmployeeProject] group by Employee";
        SqlCommand cmd = new SqlCommand(cmdstr, conn);
        SqlDataAdapter adp = new SqlDataAdapter(cmd);
        adp.Fill(ds);
        dt = ds.Tables[0];

        string category="";
        decimal[] values = new decimal[dt.Rows.Count];
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            category = category + "," + dt.Rows[i]["Employee"].ToString();
            values[i] = Convert.ToDecimal(dt.Rows[i]["Total Project"]);
        }
        BarChart1.CategoriesAxis = category.Remove(0, 1);
        BarChart1.Series.Add(new AjaxControlToolkit.BarChartSeries { Data = values, BarColor="#2fd1f9", Name = "EmployeeProject" });
    }