Devexpress中PIE案列

 public partial class WebForm4 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string sql = string.Format("select * from a_Stu");
            CreatePie(MyService.SqlHelper.ExecuteDataSet(CommandType.Text, sql));
        }
        public void CreatePie(DataSet ds) {
            Series Series1 = new Series("OnePie", ViewType.Pie);
            //面板添加一个Series  类型Pie
            WebControl.Series.Add(Series1);
            SeriesPoint [] sp=new SeriesPoint[ds.Tables[0].Rows.Count];
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                sp[i] = new SeriesPoint(ds.Tables[0].Rows[i]["name"].ToString(), ds.Tables[0].Rows[i]["age"].ToString());
            }
            Series1.Points.AddRange(sp);
            //设置百分比
           Series1.Label.PointOptions.ValueNumericOptions.Format = NumericFormat.Percent;
            //设置显示名称及数据
            Series1.LegendPointOptions.PointView = PointView.ArgumentAndValues;

            //显示饼图数据位置
            ((PieSeriesLabel)Series1.Label).Position = PieSeriesLabelPosition.TwoColumns;
        }
    }

 

posted @ 2015-06-25 17:26  徐铭洋  阅读(946)  评论(0编辑  收藏  举报