How to get dynamic data from the database and display chart

Question

Hai i want to show a statistical report on the data by chart nd how would i get the data frm the database and display it in the chart in the c#.net

Munesh Sharma · Answer

GO HERE http://dotnet-munesh.blogspot.in/2014/04/how-to-link-chart-graph-with-database.html

Digvijay Raghav · Answer

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 { x[i] = dt.Rows[i][1].ToString(); y[i] = Convert.ToInt32(dt.Rows[i][2]); } Chart1.Series[0].Points.DataBindXY(xy); 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 { 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.