报表统计(七) 访问数据库 利用XValueMember,YValueMembers绑定

public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                CreateChart();
            }
        }

        public DataTable GetTempData()
        {
            string strSql = "SELECT * FROM ChartDB";
            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=DEMO;Integrated Security=True");
            SqlDataAdapter da = new SqlDataAdapter(strSql, con);
            DataSet ds = new DataSet();
            da.Fill(ds);
            return ds.Tables[0];
        }

        public void CreateChart()
        {
            Chart1.Width = 600;
            Chart1.Height = 400;
            Chart1.ChartAreas[0].AxisX.LineWidth = 3;
            Chart1.ChartAreas[0].AxisY.LineWidth = 3;
            Chart1.DataSource = GetTempData();
            Series s1 = new Series();
            s1.IsValueShownAsLabel = true;
            s1.ChartType = SeriesChartType.Line;
            s1.MarkerStyle = MarkerStyle.Circle;
            s1.MarkerSize = 6;
            Chart1.Series.Add(s1);
            Series s2 = new Series();
            s2.ChartType = SeriesChartType.Line;
            s2.MarkerStyle = MarkerStyle.Cross;
            s2.MarkerSize = 6;
            s2.IsValueShownAsLabel = true;
            Chart1.Series.Add(s2);
            Legend l = new Legend();
            l.Docking = Docking.Bottom;
            l.Alignment = System.Drawing.StringAlignment.Center;
            l.LegendStyle = LegendStyle.Row;
            Chart1.Legends.Add(l);
            Legend l2 = new Legend();
            l2.Docking = Docking.Bottom;
            l2.Alignment = System.Drawing.StringAlignment.Center;
            l2.LegendStyle = LegendStyle.Row;
            Chart1.Legends.Add(l2);
            Legend l1 = new Legend();
            l1.LegendStyle = LegendStyle.Row;
            l1.Docking = Docking.Bottom;
            l1.Alignment = System.Drawing.StringAlignment.Center;
            Chart1.Legends.Add(l1);
            Chart1.Series[0].ChartType = SeriesChartType.Line;
            Chart1.Series[0].XValueMember = "Worker";
            Chart1.Series[0].YValueMembers = "ProductPrice";
            Chart1.Series[0].LegendText = "日收入";
            Chart1.Series[1].XValueMember = "Worker";
            Chart1.Series[1].YValueMembers = "YearPrice";
            Chart1.Series[1].LegendText = "年收入";
            Chart1.Series[2].XValueMember = "Worker";
            Chart1.Series[2].YValueMembers = "MonthPrice";
            Chart1.Series[2].LegendText = "月收入";
            Chart1.DataBind();
        }
    }