This question is locked. New answers and comments are not allowed.
i have bind my chart control with the database table
u can see the picture here http://www.c-sharpcorner.com/Forums/ShowMessages.aspx?ThreadID=68854
DataSet ds = new DataSet();
SqlConnection con = new SqlConnection("Data Source =.\\SQLEXPRESS;Initial Catalog = schoolmgt; password=; Integrated Security = true;");
con.Open();
SqlCommand cmd = new SqlCommand("select Paper1,Paper2,Paper3,Paper4,Paper5 from Student_Exams_Marks_Detail where S_ID='" + comboBox3.Text + "'and Section='"+comboBox2.Text+"' and Class='"+comboBox1.Text+"' ", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds, "v");
radChart1.PlotArea.XAxis.AxisLabel.TextBlock.Text = "Years";
radChart1.DataSource = ds.Tables["v"];
radChart2.DataSource = ds.Tables["v"];
radChart3.DataSource = ds.Tables["v"];
radChart4.DataSource = ds.Tables["v"];
// MessageBox.Show(ds.Tables["v"].Rows[0][1].ToString());
//radChart1.Skin = "LightBlue";
radChart1.DataBind();
radChart2.DataBind();
radChart3.DataBind();
radChart4.DataBind();
radChart2.ChartTitle.TextBlock.Text = "MY chart";
ChartSeries s1 = new ChartSeries();
s1.Name = "vikas"; /////////// this is not working
The problem is that the series name are according to database table , but i want to put diff lables , how can i do this for more clearly understand my problme u can see picture
here
http://www.c-sharpcorner.com/Forums/ShowMessages.aspx?ThreadID=68854
u can see the picture here http://www.c-sharpcorner.com/Forums/ShowMessages.aspx?ThreadID=68854
DataSet ds = new DataSet();
SqlConnection con = new SqlConnection("Data Source =.\\SQLEXPRESS;Initial Catalog = schoolmgt; password=; Integrated Security = true;");
con.Open();
SqlCommand cmd = new SqlCommand("select Paper1,Paper2,Paper3,Paper4,Paper5 from Student_Exams_Marks_Detail where S_ID='" + comboBox3.Text + "'and Section='"+comboBox2.Text+"' and Class='"+comboBox1.Text+"' ", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds, "v");
radChart1.PlotArea.XAxis.AxisLabel.TextBlock.Text = "Years";
radChart1.DataSource = ds.Tables["v"];
radChart2.DataSource = ds.Tables["v"];
radChart3.DataSource = ds.Tables["v"];
radChart4.DataSource = ds.Tables["v"];
// MessageBox.Show(ds.Tables["v"].Rows[0][1].ToString());
//radChart1.Skin = "LightBlue";
radChart1.DataBind();
radChart2.DataBind();
radChart3.DataBind();
radChart4.DataBind();
radChart2.ChartTitle.TextBlock.Text = "MY chart";
ChartSeries s1 = new ChartSeries();
s1.Name = "vikas"; /////////// this is not working
The problem is that the series name are according to database table , but i want to put diff lables , how can i do this for more clearly understand my problme u can see picture
here
http://www.c-sharpcorner.com/Forums/ShowMessages.aspx?ThreadID=68854