报表统计(五) 访问数据库

public partial class Chartdb3 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                CreateTempChart();
            }
        }
        public DataTable GetTempData()
        {
            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=DEMO;Integrated Security=True");
            string strSql = "SELECT * FROM ChartDB";
            SqlDataAdapter da = new SqlDataAdapter(strSql, con);
            DataSet ds = new DataSet();
            da.Fill(ds);
            if (ds == null || ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0)
            {
                return new DataTable();
            }
            return ds.Tables[0];
        }
        public void CreateTempChart()
        {
            DataTable dt = GetTempData();
            Chart1.Width = 600;
            Chart1.Height = 400;
            Chart1.ChartAreas[0].AxisY.Title = "销售收入";
            Chart1.ChartAreas[0].AxisX.Title = "销售人员";
            Series s1 = new Series();
            s1.ChartType = SeriesChartType.Line;
            s1.MarkerStyle = MarkerStyle.Triangle;
            s1.MarkerSize = 6;
            s1.Color = Color.Green;
            s1.IsVisibleInLegend = true;
            Chart1.Series.Add(s1);
            Series s2 = new Series();
            s2.ChartType = SeriesChartType.Line;
            s2.MarkerStyle = MarkerStyle.Square;
            s2.MarkerSize = 6;
            s2.IsVisibleInLegend = true;
            s2.Color = Color.Yellow;
            Chart1.Series.Add(s2);
            Series s3 = new Series();
            s3.Color = Color.Tomato;
            s3.ChartType = SeriesChartType.Line;
            s3.MarkerSize = 6;
            s3.MarkerStyle = MarkerStyle.Diamond;
            s3.IsVisibleInLegend = true;
            Chart1.Series.Add(s3);
            for (int i = 0; i < 3; i++)
            {
                Legend l = new Legend();
                l.Docking = Docking.Bottom;
                l.LegendStyle = LegendStyle.Row;
                l.Alignment = StringAlignment.Center;
                this.Chart1.Legends.Add(l);
            }
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                this.Chart1.Series[0].Points.AddXY(dt.Rows[i]["Worker"].ToString(), dt.Rows[i]["ProductPrice"].ToString());
                Chart1.Series[0].ToolTip = "销售人员:\t#VALX\n收入:\t#VALY";
                this.Chart1.Series[1].Points.AddXY(dt.Rows[i]["Worker"].ToString(), dt.Rows[i]["YearPrice"].ToString());
                Chart1.Series[1].ToolTip = "销售人员:\t#VALX\n年收入:\t#VALY";
                this.Chart1.Series[2].Points.AddXY(dt.Rows[i]["Worker"].ToString(), dt.Rows[i]["MonthPrice"].ToString());
                Chart1.Series[2].ToolTip = "销售人员:\t#VALX\n月收入:\t#VALY";
            }
            Chart1.Series[0].LegendText = "收入";
            Chart1.Series[1].LegendText = "年收入";
            Chart1.Series[2].LegendText = "月收入";
        }
    }