如何使用DataSet内的DataTable创建图表 [英] How to Create Charts With DataTables Inside DataSet

问题描述

大家好，有谁知道如何在数据集中创建不同数据表的不同图表？假设我在数据集中有3个数据表，我想用1个chart = 1datatable数据创建3个图表。我尝试了不同的方法，但无法让它工作..



这是我到目前为止我的代码所做的：

hi all, does anyone know how can I create different charts with different datatables inside dataset? Let's say I have 3 datatables inside dataset, I want to create 3 charts out with 1 chart=1datatable data. I tried different ways but could not get it work..

This is what I have done so far for my codes:

Chart Chart2 = new Chart();
                    Chart2.DataSource = ds;
                    Chart2.Width = 600;
                    Chart2.Height = 350;

                    Chart2.Series.Add(new Series());
                    Chart2.Series[0].ChartType = SeriesChartType.BoxPlot;
                    foreach (DataTable dt in ds.Tables)
                    {
                        List<object> lst2 = dt.AsEnumerable().ToList<object>();

                        foreach (DataRow row in dt.Rows)
                            Chart2.Series[0].Points.AddXY(row["DEPARTMENT"], new object[] { row["MAX"], row["MIN"], row["AVG"], row["PERCENTILE25"], row["PERCENTILE50"], row["PERCENTILE75"] });
                    }

                    Chart2.Series[0].Color = Color.White;
                    Chart2.Series[0].BorderColor = Color.MidnightBlue;
                    Chart2.Series[0].ChartType = SeriesChartType.BoxPlot;

                    //if (dt.Rows.Count > 0)
                    //{
                    //    string title2 = (tg2.Rows[0]["TITLE"].ToString());
                    //    Chart2.Titles.Add(title2);
                    //}
                    //create chartareas
                    ChartArea ca2 = new ChartArea();
                    //ca.Name = "ChartArea3";
                    ca2.AxisX = new Axis();
                    ca2.AxisY = new Axis();
                    Chart2.ChartAreas.Add(ca2);

                    //databind
                    Chart2.DataBind();
                    Chart2.Visible = true;

                    AjaxControlToolkit.TabPanel panel = new AjaxControlToolkit.TabPanel();
                    panel.HeaderText += item.Text;
                    container.Tabs.Add(panel);
                    //panel.Controls.Add(tabContent);
                    panel.Controls.Add(Chart2);

创建图表后，我想将它们添加到选项卡小组。



感谢有人能为我提供指导，让我继续。非常感谢!!

After creating the charts, I would like to add them to the tab panel.

Appreciate if someone can provide me guidance on this for me to continue. Thanks a lot!!

推荐答案

检查 BoxPlot图表类型 [ ^ ]

这篇关于如何使用DataSet内的DataTable创建图表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！