报表统计(八) 访问数据库 Position

 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.BackColor = Color.Azure;
            Chart1.ChartAreas[0].AxisX.LineWidth = 3;
            Chart1.ChartAreas[0].AxisX.MajorGrid.LineColor = Color.Red;
            Chart1.ChartAreas[0].AxisY.MajorGrid.LineColor = Color.Red;
            Chart1.ChartAreas[0].AxisY.LineWidth = 1;
            Chart1.ChartAreas[0].Position.X = 2;
            Chart1.ChartAreas[0].Position.Y = 2;
            Chart1.ChartAreas[0].Position.Height = 98;
            Chart1.ChartAreas[0].Position.Width = 98;
            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.Right;
            l.Alignment = System.Drawing.StringAlignment.Center;
            l.LegendStyle = LegendStyle.Column;
            l.BackColor = Color.LightGoldenrodYellow;
            l.Position.X = 86;
            l.Position.Y = 5;
            l.Position.Height = 20;
            l.Position.Width = 12;
            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[0].ToolTip = "#VALX\t#VALY";
            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();
        }
    }