How to get dynamic data from the database and display chart

First design your aspx by dragging and droping asp.net chart control , this will make following mark up

then in your cs page code like this
/*CODE*/

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindChart();

}

private void BindChart()

{

DataSet ds = new DataSet();

DataTable dt = new DataTable();

conn.Open();

string cmdstr = "select * from Sales";

SqlDataAdapter adp = new SqlDataAdapter(cmdstr, conn );

adp.Fill(ds);

dt = ds.Tables[0];

string[] x = new string[dt.Rows.Count];

int[] y = new int[dt.Rows.Count];

for (int i = 0; i < dt.Rows.Count; i++)

{

x[i] = dt.Rows[i][1].ToString();

y[i] = Convert.ToInt32(dt.Rows[i][2]);

}

Chart1.Series[0].Points.DataBindXY(x,y);

Chart1.Series[0].PostBackValue = "#VALX";

Chart1.Series[0].IsValueShownAsLabel = true;

Chart1.Series[0].LabelFormat = "##,###";

Chart1.Series[0].ChartType = SeriesChartType.Column;

Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;

Chart1.Legends[0].Enabled = true;

ViewState["mode"] = "abx";

}

private void BindNewChart(string year)

{

DataSet ds = new DataSet();

DataTable dt = new DataTable();

conn.Open();

string cmdstr = "select * from Sales where Year = " + year;

SqlDataAdapter adp = new SqlDataAdapter(cmdstr, conn);

adp.Fill(ds);

dt = ds.Tables[0];

string[] x = new string[dt.Rows.Count];

int[] y = new int[dt.Rows.Count];

for (int i = 0; i < dt.Rows.Count; i++)

{

x[i] = dt.Rows[i][1].ToString();

y[i] = Convert.ToInt32(dt.Rows[i][2]);

}

Chart1.Series[0].Points.DataBindXY(x, y);

Chart1.Series[0].ChartType = SeriesChartType.Column;

Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;

Chart1.Legends[0].Enabled = true;

ViewState["mode"] = "abx";

}

protected void Chart1_Click(object sender, ImageMapEventArgs e)

{

lblValue.Text = e.PostBackValue.ToString();

BindNewChart(lblValue.Text);

}

Please accept answer this will work fine.

2 Replies

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

Munesh Sharma12y ago
GO HERE

http://dotnet-munesh.blogspot.in/2014/04/how-to-link-chart-graph-with-database.html
0
Digvijay Raghav12y ago
First design your aspx by dragging and droping asp.net chart control , this will make following mark up

then in your cs page code like this
/*CODE*/
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindChart();
}

}

private void BindChart()
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
conn.Open();
string cmdstr = "select * from Sales";
SqlDataAdapter adp = new SqlDataAdapter(cmdstr, conn );
adp.Fill(ds);
dt = ds.Tables[0];
string[] x = new string[dt.Rows.Count];
int[] y = new int[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
x[i] = dt.Rows[i][1].ToString();
y[i] = Convert.ToInt32(dt.Rows[i][2]);
}

Chart1.Series[0].Points.DataBindXY(x,y);

Chart1.Series[0].PostBackValue = "#VALX";
Chart1.Series[0].IsValueShownAsLabel = true;
Chart1.Series[0].LabelFormat = "##,###";
Chart1.Series[0].ChartType = SeriesChartType.Column;
Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
Chart1.Legends[0].Enabled = true;
ViewState["mode"] = "abx";

}
private void BindNewChart(string year)
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
conn.Open();
string cmdstr = "select * from Sales where Year = " + year;
SqlDataAdapter adp = new SqlDataAdapter(cmdstr, conn);
adp.Fill(ds);
dt = ds.Tables[0];
string[] x = new string[dt.Rows.Count];
int[] y = new int[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
x[i] = dt.Rows[i][1].ToString();
y[i] = Convert.ToInt32(dt.Rows[i][2]);
}
Chart1.Series[0].Points.DataBindXY(x, y);

Chart1.Series[0].ChartType = SeriesChartType.Column;
Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
Chart1.Legends[0].Enabled = true;
ViewState["mode"] = "abx";

}

protected void Chart1_Click(object sender, ImageMapEventArgs e)
{
lblValue.Text = e.PostBackValue.ToString();
BindNewChart(lblValue.Text);
}

Please accept answer this will work fine.

0