chartControl数据绑定
根据数据表的不同建立
一、如果X轴是列名就如下:
DataView dv = new DataView(ds.Tables[0]);
chartControl1.DataSource = dv;
chartControl1.Series.Clear();
for (int i = 0; i < ds.Tables[0].Columns.Count - 1; i++)
{
for (int m = 0; m < ds.Tables[0].Rows.Count; m++)
{
Series series1 = new Series(ds.Tables[0].Columns[i].ToString(),ViewType.StackedBar3D);
series1.Points.Add(new SeriesPoint(ds.Tables[0].Columns[i].ToString(), new double[] { Convert.ToDouble(ds.Tables[0].Rows[m][ds.Tables[0].Columns[i].ToString()]) }));
chartControl1.Series.Add(series1);
}
}
chartControl1.Legend.Visible = false;//不现实指示图
实例:
string sqlStr="select * from 医院收入费用表";//表结构:字段名为各个部门名称,记录为double数值
ds = dservice.CustomSelect("Flow", sqlStr);//连接数据库,经过封装的
DataView dv = new DataView(ds.Tables[0]);
chartControl1.DataSource = dv;
chartControl1.Series.Clear();
for (int i = 0; i < ds.Tables[0].Columns.Count - 1; i++)
{
for (int m = 0; m < ds.Tables[0].Rows.Count; m++)
{
Series series1 = new Series(ds.Tables[0].Columns[i].ToString(), ViewType.StackedBar);
series1.Points.Add(new SeriesPoint(ds.Tables[0].Columns[i].ToString(), new double[] { Convert.ToDouble(ds.Tables[0].Rows[m][ds.Tables[0].Columns[i].ToString()]) }));
chartControl1.Series.Add(series1);
}
}
chartControl1.Legend.Visible = false;//不显示指示图
new double[] { }多数据的作用
二、如果X轴是某一列:
string sqlStr="select * from 收费详情";//表结构:字段名为各个部门、收入、日期
ds = dservice.CustomSelect("Flow", sqlStr);//连接数据库,经过封装的
DataView dv = new DataView(ds.Tables[0]);
chartControl1.DataSource = dv;
chartControl1.SeriesDataMember = "O";
chartControl1.SeriesTemplate.ArgumentDataMember = "M";
chartControl1.SeriesTemplate.ValueDataMembers.AddRange(new string[] { "N" });
chartControl1.SeriesTemplate.View = new StackedBarSeriesView();
其中O M N为数据集ds中的列名称
实例:
DataView dv = new DataView(ds.Tables[0]);
chartControl1.DataSource = dv;
chartControl1.SeriesDataMember = "部门";//数据表示的部门
chartControl1.SeriesTemplate.ArgumentDataMember = "日期";//X轴显示
chartControl1.SeriesTemplate.ValueDataMembers.AddRange(new string[] { "收入" });//显示的数据
chartControl1.SeriesTemplate.View = new StackedBarSeriesView();
三、标题设置:
ChartTitle chartTitle1 = new DevExpress.XtraCharts.ChartTitle();
chartTitle1.Text = "收入详情";
chartTitle1.Font = new Font("宋体", 18F, System.Drawing.FontStyle.Bold);
chartControl1.Titles.Clear();
chartControl1.Titles.Add(chartTitle1);
四、图形设置:
DevExpress.XtraCharts.LineSeriesView barseriesview1 = new DevExpress.XtraCharts.LineSeriesView();
chartControl1.SeriesTemplate.View = barseriesview1;
最近刚刚接触,我也是个新手,就知道这么多,分享一下,因为我在网上找了好久都没找到多少可用的资源!