Click here to Skip to main content
15,890,506 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have to draw graph yearly ,monthly graph from data base have yearly data
how can i make multiple series graph by selecting years
Posted
Updated 14-Jan-15 21:58pm
v2
Comments
Zoltán Zörgő 15-Jan-15 3:41am    
On what, with what, what is the sampling you need to use?
Saqib Abbas 15-Jan-15 3:43am    
using Visual studio
i have date on x aaxis n value on y axis
Saqib Abbas 15-Jan-15 3:47am    
This is my code

SqlConnection con1 = new SqlConnection(@"Data Source=SAQIB-PC\SQLEXPRESS;Initial Catalog=HDRO_SAMPLE;Integrated Security=True");
SqlCommand cmd = new SqlCommand("SELECT * from sl_years", con1);
SqlDataReader r = null;
con1.Open();
r = cmd.ExecuteReader();
while (r.Read())
{
//string strdt = (string)r["YR_START"];
//string enddt = (string)r["YR_END"];

DateTime strdt = Convert.ToDateTime(r["YR_START"]);
DateTime enddt = Convert.ToDateTime(r["YR_END"]);


r.Close();

sqlstr1 = @"SELECT DISTINCT MEAS_DATE=convert(varchar(2),MEAS_DATE,110) ,SM=sum(GHEIGHT) FROM T_MEAS_DATE
where MEAS_DATE>='" + strdt + "' and MEAS_DATE<='" + enddt + "' Group by convert(varchar(2),MEAS_DATE,110) order by convert(varchar(2),MEAS_DATE,110)";

// MEAS_DATE >= '2014-01-01' AND MEAS_DATE <= '2014-12-31'";
// // @"SELECT SUM(GHEIGHT), MONTH(MEAS_DATE) FROM T_MEAS_DATE
// // GROUP BY MEAS_DATE";
// //WHERE MEAS_DATE >= '2014-01-01' AND MEAS_DATE <= '2014-01-31'";
//string sqlstr1 = "SELECT *FROM [selected year]";


SqlDataAdapter myCommand1 = new SqlDataAdapter(sqlstr1, con1);



std = new DataSet();



myCommand1.Fill(std);



DataView source1 = new DataView(std.Tables[0]);

chart1.DataBind();






// chart1.Series.Add("2013");
// chart1.Series["2013"].IsValueShownAsLabel = true;
// chart1.Series["2013"].Color = Color.PaleGreen;

// chart1.Series["2013"].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;

chart1.Series["2013"].YValueMembers = "SM";
chart1.Series["2013"].XValueMember = "MEAS_DATE";

chart1.ChartAreas[0].AxisX.Minimum = 0;
chart1.ChartAreas[0].AxisX.Maximum = 13;
chart1.ChartAreas[0].AxisX.Interval = 1;

chart1.ChartAreas[0].AxisX.LabelStyle.Format = "MM-YYYY";


}


}

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900