//表格数据绑定
gridControl1.DataSource = ds.Tables[0];
//图形报表数据绑定
DataView dv = new DataView(ds.Tables[0]);
chartControl1.DataSource = dv;
//chartControl1.SeriesDataMember = ds.Tables[0].Columns["性别"].Caption;
//for (int i = 0; i < ds.Tables[0].Columns.Count-1; i++)
//{
// chartControl1.SeriesTemplate.ArgumentDataMember = ds.Tables[0].Columns[i].ToString();
// chartControl1.SeriesTemplate.ValueDataMembers.AddRange(new string[] { ds.Tables[0].Columns[i].ToString() });
//}
//chartControl1.SeriesTemplate.View =new StackedBarSeriesView();
// Create the first full-stacked bar series and add points to it.
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;
gridControl1.DataSource = ds.Tables[0];
//图形报表数据绑定
DataView dv = new DataView(ds.Tables[0]);
chartControl1.DataSource = dv;
//chartControl1.SeriesDataMember = ds.Tables[0].Columns["性别"].Caption;
//for (int i = 0; i < ds.Tables[0].Columns.Count-1; i++)
//{
// chartControl1.SeriesTemplate.ArgumentDataMember = ds.Tables[0].Columns[i].ToString();
// chartControl1.SeriesTemplate.ValueDataMembers.AddRange(new string[] { ds.Tables[0].Columns[i].ToString() });
//}
//chartControl1.SeriesTemplate.View =new StackedBarSeriesView();
// Create the first full-stacked bar series and add points to it.
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;