手动添加DataTable
- DataTable dt = new DataTable("Table1");
- dt.Columns.Add("id",typeof(Int16));
- dt.Columns.Add("name",typeof(String));
- dt.Columns.Add("address",typeof(String));
- dt.Columns.Add("city",typeof(String));
- dt.Rows.Add(new object[]{1,"张三","闵行","剑川"});
- dt.Rows.Add(new object[]{2,"李四","徐汇","东川"});
- dt.Rows.Add(new object[]{ 3, "王五", "闵行","卢恒" });
using System;
using System.Data;
using System.Windows.Forms;
using DevExpress.XtraCharts;
// ...
案例
private DataTable CreateChartData() {
// Create an empty table.
DataTable table = new DataTable("Table1");
// Add three columns to the table.
table.Columns.Add("Month", typeof(String));
table.Columns.Add("Section", typeof(String));
table.Columns.Add("Value", typeof(Int32));
// Add data rows to the table.
table.Rows.Add(new object[] { "Jan", "Section1", 10 });
table.Rows.Add(new object[] { "Jan", "Section2", 20 });
table.Rows.Add(new object[] { "Feb", "Section1", 20 });
table.Rows.Add(new object[] { "Feb", "Section2", 30 });
table.Rows.Add(new object[] { "March", "Section1", 15 });
table.Rows.Add(new object[] { "March", "Section2", 25 });
return table;
}
private void Form1_Load(object sender, EventArgs e) {
// Create a chart.
ChartControl chart = new ChartControl();
// Generate a data table and bind the chart to it.
chart.DataSource = CreateChartData();
// Specify data members to bind the chart's series template.
chart.SeriesDataMember = "Month";
chart.SeriesTemplate.ArgumentDataMember = "Section";
chart.SeriesTemplate.ValueDataMembers.AddRange(new string[] {"Value"});
// Specify the template's series view.
chart.SeriesTemplate.View = new StackedBarSeriesView();
// Specify the template's name prefix.
chart.SeriesNameTemplate.BeginText = "Month: ";
// Dock the chart into its parent, and add it to the current form.
chart.Dock = DockStyle.Fill;
this.Controls.Add(chart);
}
浙公网安备 33010602011771号