棘手问题

[huangweifmn]

怎么根据数据库表里的数据处理成图形数据

[H463428621]

//ReportChart.ChartAreas.Clear();
//ReportChart.Series.Clear();
//ReportChart.Titles.Clear();
//ReportChart.Legends.Clear();

//ChartArea defaultChartArea = new ChartArea("DefaultChartArea");
//Legend defaultLegend = new Legend("DefaultLegend");
//defaultLegend.LegendStyle = LegendStyle.Table;
//defaultLegend.Docking = Docking.Bottom;
//defaultLegend.TableStyle = LegendTableStyle.Auto;
//defaultLegend.Alignment = System.Drawing.StringAlignment.Near;
//Title defaultTitle = new Title(txtChartTitle.Text);
//ReportChart.ChartAreas.Add(defaultChartArea);
//ReportChart.Titles.Add(defaultTitle);
//ReportChart.Legends.Add(defaultLegend);
//ReportChart.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(243)), ((System.Byte)(223)), ((System.Byte)(193)));
//ReportChart.BackGradientStyle = GradientStyle.TopBottom;
//ReportChart.BorderlineColor = System.Drawing.Color.FromArgb(((System.Byte)(181)), ((System.Byte)(64)), ((System.Byte)(1)));
//ReportChart.BorderlineDashStyle = ChartDashStyle.Solid;
//ReportChart.BorderlineWidth = 2;
//ReportChart.BorderSkin.SkinStyle = BorderSkinStyle.Emboss;

////设置图形
//Series series = new Series();
//string[] chartY = txtChartY.Text.Split(',');
//DataSet ds = new DataSet();
//DataView dataView;
//try
//{
// string sql = rtbChart.Text.Replace("\n", " ");
// dataView = BizCreateTable.GetDataView(sql);
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message, "异常提示!", MessageBoxButton.OK);
// return;
//}
//switch (txtType.Text)
//{
// case "柱形图":
// foreach (var item in chartY)
// {
// series = new Series(item);
// series.Points.DataBindXY(dataView, txtChartX.Text, dataView, item);
// series.IsValueShownAsLabel = true;
// series.LegendText = item;
// series.ChartArea = "DefaultChartArea";
// series.ChartType = SeriesChartType.Column;
// ReportChart.Series.Add(series);
// }
// break;
// case "折线图":
// foreach (var item in chartY)
// {
// series = new Series(item);
// series.Points.DataBindXY(dataView, txtChartX.Text, dataView, item);
// series.IsValueShownAsLabel = true;
// series.LegendText = item;
// series.ChartArea = "DefaultChartArea";
// series.ChartType = SeriesChartType.Line;
// ReportChart.Series.Add(series);
// }
// break;
// case "饼图":
// series["PieDrawingStyle"] = "Default";//Default,SoftEdge,Concave
// series["PieLabelStyle"] = "Inside"; //Inside,Outside,Disabled
// ReportChart.Legends[0].Enabled = false;
// series.Points.DataBindXY(dataView, txtChartX.Text, dataView,txtChartY.Text);
// series.ChartArea = "DefaultChartArea";
// series.ChartType = SeriesChartType.Pie;
// ReportChart.Series.Add(series);
// break;
// case "条形图":
// foreach (var item in chartY)
// {
// series = new Series(item);
// series.Points.DataBindXY(dataView, txtChartX.Text, dataView, item);
// series.IsValueShownAsLabel = true;
// series.LegendText = item;
// series.ChartArea = "DefaultChartArea";
// series.ChartType = SeriesChartType.Bar;
// ReportChart.Series.Add(series);
// }
// break;
// case "堆积条形图":
// foreach (var item in chartY)
// {
// series = new Series(item);
// series.Points.DataBindXY(dataView, txtChartX.Text, dataView, item);
// series.IsValueShownAsLabel = true;
// series.LegendText = item;
// series.ChartArea = "DefaultChartArea";
// series.ChartType = SeriesChartType.StackedBar;
// ReportChart.Series.Add(series);
// }
// break;
// case "面积图":
// foreach (var item in chartY)
// {
// series = new Series(item);
// series.Points.DataBindXY(dataView, txtChartX.Text, dataView, item);
// series.IsValueShownAsLabel = true;
// series.LegendText = item;
// series.ChartArea = "DefaultChartArea";
// series.ChartType = SeriesChartType.Area;
// ReportChart.Series.Add(series);
// }
// break;
// case "雷达图":
// foreach (var item in chartY)
// {
// series = new Series(item);
// series.Points.DataBindXY(dataView, txtChartX.Text, dataView, item);
// series.IsValueShownAsLabel = true;
// series.LegendText = item;
// series.ChartArea = "DefaultChartArea";
// series.ChartType = SeriesChartType.Radar;
// ReportChart.Series.Add(series);
// }
// break;
//}

[快溜]

获取数据库数据绑定chart控件。