手动添加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, "王五", "闵行","卢恒" });

 

DataSet 手动添加同理

 

 

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);}