[MSChart]交叉表数据图表绑定

来源：互联网发布：access是数据库软件吗编辑：程序博客网时间：2024/06/10 00:51

交叉表数据：

显示结果：

Y轴：良率

X轴：日期（动态）

显示项目：检验项目

 private void PassRateBind(Chart ct,string strSql)        {            DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.conn, CommandType.Text, strSql).Tables[0];            ct.DataBindCrossTable(dt.DefaultView, "检验项目", "日期", "良率", "Tooltip =良率");            ct.Width = 1000;            ct.Height = 400;            for (int i = 0; i < ct.Series.Count; i++)            {                ct.Series[i].ChartType = SeriesChartType.Line;            }                 ct.ChartAreas["ChartArea1"].ShadowColor = Color.Transparent;            ct.ChartAreas["ChartArea1"].BackColor = Color.FromArgb(209, 237, 254);         //该处设置为了由天蓝到白色的逐渐变化            ct.ChartAreas["ChartArea1"].BackGradientStyle = GradientStyle.TopBottom;            ct.ChartAreas["ChartArea1"].BackSecondaryColor = Color.White;            //中间X,Y线条的颜色设置            ct.ChartAreas["ChartArea1"].AxisX.MajorGrid.LineColor = Color.FromArgb(64, 64, 64, 64);            ct.ChartAreas["ChartArea1"].AxisY.MajorGrid.LineColor = Color.FromArgb(64, 64, 64, 64);            //X.Y轴数据显示间隔            ct.ChartAreas["ChartArea1"].AxisX.Interval = 1.0; //X轴数据显示间隔            ct.ChartAreas["ChartArea1"].AxisX.IntervalType = DateTimeIntervalType.Days;            ct.ChartAreas["ChartArea1"].AxisX.IntervalOffset = 0.0;            ct.ChartAreas["ChartArea1"].AxisX.IntervalOffsetType = DateTimeIntervalType.Days;            ct.ChartAreas["ChartArea1"].AxisX.LabelStyle.Format = "M-d";            ct.Palette = ChartColorPalette.Pastel;            ct.DataBind();            ct.ChartAreas["ChartArea1"].AxisX.Title = "日期";            ct.ChartAreas["ChartArea1"].AxisY.Title = "良率";        }

效果：

0 0