ASP.NET WebForm Chart图表多条折线动态绑定怎么搞

吃瓜日常 2018-12-24 09:02:59

一条数据绑定一次的代码先奉上

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=10.119.8.11;Initial Catalog=SHWIP;Persist Security Info=True;User ID=shwip;Password=shwip";

            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);

            Chart1.DataSource = 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);

        }