110,534
社区成员
发帖
与我相关
我的任务
分享
protected void Chart1_Load1(object sender, EventArgs e)
{
Chart1.Titles.Add("折线图报表");
Chart1.ChartAreas[0].AxisX.Title = "日期时间";//设置X轴的标题
Chart1.ChartAreas[0].AxisY.Title = "产品水平";//设置Y轴的标题
Chart1.ChartAreas[0].AxisY.Interval = 10;//设置X轴间距,这样的话,就间距固定为10
string constr = "Data Source=;Initial Catalog=;Persist Security Info=True;User ID=;Password=";
SqlConnection con = new SqlConnection(constr);
//打开连接;
con.Open();
//第一条数据
string sql = "SELECT * FROM APiece WHERE APiece.Piece_PId=1";
DataTable ds = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(sql, con);
sda.Fill(ds);
Series ss = new Series("产品1"); //这里 dt1 ,dt2 任意取名称,但要唯一
ss.Points.DataBind(ds.AsEnumerable(), "Piece_Time", "Piece_Level", "");
ss.XValueType = ChartValueType.DateTime; //设置X轴
ss.ChartType = SeriesChartType.Spline; //设置Y轴为折线
Chart1.Series.Add(ss);
//第二条数据
string sql1 = "SELECT * FROM APiece WHERE APiece.Piece_PId=2";
DataTable ds1 = new DataTable();
SqlDataAdapter sda1 = new SqlDataAdapter(sql1, con);
sda1.Fill(ds1);
Chart1.DataSource = ds1;
Series ss2 = new Series("产品2");
ss2.Points.DataBind(ds1.AsEnumerable(), "Piece_Time", "Piece_Level", "");
ss2.XValueType = ChartValueType.DateTime; //设置X轴
ss2.ChartType = SeriesChartType.Spline; //设置Y轴为折线
Chart1.Series.Add(ss2);
//第三条数据
string sql2 = "SELECT * FROM APiece WHERE APiece.Piece_PId=3";
DataTable ds2 = new DataTable();
SqlDataAdapter sda2 = new SqlDataAdapter(sql2, con);
sda2.Fill(ds2);
Chart1.DataSource = ds2;
Series ss3 = new Series("产品3");
ss3.Points.DataBind(ds2.AsEnumerable(), "Piece_Time", "Piece_Level", "");
ss3.XValueType = ChartValueType.DateTime; //设置X轴
ss3.ChartType = SeriesChartType.Spline; //设置Y轴为折线
Chart1.Series.Add(ss3);