如何使用Winforms中的c#代码将数据绑定到Winforms中的数据透视网格?

Question

我想使用不是 SqlDataSource 的代码将数据绑定到透视网格。

private void Report_Summary_Load(object sender,EventArgs e)
{
string cs= configuraitonManager.connectionString["connectionStringDatabase"].connectionString;
using(SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("spStoredProcedureTest",con);
cmd.CommandType = CommandType.StoredProcedure;
con.open();
SqlDataReader sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
pivotGrid.DataSource = ds;
PivotGridField Name = new PivotGridField("Name",PivotArea.RowArea);
PivotGrid.Fields.AddRange(new PivotGridField[] {Name});
Name.AreaIndex = 0;
// My pivot grid name is  "pivotGridDemo"
//How to bind the data to the data area,column area and Row area
}
}

我有 5 个字段

姓名，标准，城市，年龄，年份

我想在行区域中设置名称和城市，在列区域中设置城市，在数据区域中设置年龄和DobYear

更新

上面的代码正在添加名称是行字段。但不显示记录

Answer 1

试试这个：

pivotGrid.DataSource = ds.Tables[0];
PivotGridField fieldCity  = new PivotGridField("City", PivotArea.ColumnArea);
fieldCity.Caption = "City";
PivotGridField fieldName = new PivotGridField("Name", PivotArea.RowArea);
fieldBureau.Caption = "Name";
PivotGridField fieldCity = new PivotGridField("City", PivotArea.RowArea);
fieldBureau.Caption = "City";
PivotGridField fieldAge  = new PivotGridField("Age", PivotArea.DataArea);   
fieldQte.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
fieldAge.AreaIndex = 0;
PivotGridField fieldDobYear  = new PivotGridField("DobYear ", PivotArea.DataArea);  
pivotGrid.Fields.AddRange(new PivotGridField[] { fieldCity, fieldName , fieldAge  , fieldDobYear   });