You can populate FlexPivot with data by binding the FlexPivotPage control with a data source. For this, you can use a data table or a data engine as the data source for binding to the FlexPivot. Let us discuss how you can bind the FlexPivot to a data table and a data engine in the following sections.

Bind FlexPivot to DataTable

To bind the FlexPivot to a data table, follow these steps:

1. Establish a connection to the C1NWind database using the OLE DB provider connection string, as shown in the following code:
   

   C#	コードのコピー
   //データベースへの接続を確立し、データを取得します OleDbConnection oconn = new OleDbConnection(); oconn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=..\..\Documents\ComponentOne Samples\Common\C1NWind.mdb"; var da = new OleDbDataAdapter("select * from Invoices", oconn);

2. Fetch the data from the database to the data table using the following code:
   

   C#	コードのコピー
   var dt = new DataTable(); da.Fill(dt);

3. Bind the datatable to FlexPivot's FlexPivotEngine using the FlexPivotPanel.FlexPivotEngine property as shown in the following code:
   

   C#	コードのコピー
   flexPivotPage.FlexPivotPanel.FlexPivotEngine.BeginUpdate(); flexPivotPage.DataSource = dt.DefaultView; flexPivotPage.FlexPivotPanel.FlexPivotEngine.EndUpdate();

Bind FlexPivot to DataEngine

To bind the FlexPivot to a data table, follow these steps:

1. Establish a connection to the C1NWind database using the OLE DB provider connection string, as shown in the following code:
   

   C#	コードのコピー
   //データベースへの接続を確立し、データを取得します OleDbConnection oconn = new OleDbConnection(); oconn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=..\..\Documents\ComponentOne Samples\Common\C1NWind.mdb"; var da = new OleDbDataAdapter("select * from Invoices", oconn);

2. Fetch the data from the database to the data table using the following code:
   

   C#	コードのコピー
   var dt = new DataTable(); da.Fill(dt); dt.TableName = "Invoices";

3. Initialize the DataEngine workspace for storing DataEngine data using the following code:
   

   C#	コードのコピー
   string dataPath = Path.Combine(Directory.GetCurrentDirectory(), "Data"); //DataEngineデータを保存します flexPivotPage.FlexPivotPanel.Workspace.Init(dataPath); BindToDataEngine();

4. Import the data from the data table to the DataEngine's datatable using the following code:
   

   C#	コードのコピー
   //DataEngineデータテーブルにデータをインポートします C1.DataEngine.DbConnector.GetData(flexPivotPage.FlexPivotPanel.Workspace, dt.CreateDataReader(), dt.TableName);

5. Bind the datatable to FlexPivot's FlexPivotEngine using the FlexPivotPanel.FlexPivotEngine property as shown in the following code:
   

   C#	コードのコピー
   //FlexPivotをデータが設定たされたDataEngineに接続します var fPanel = flexPivotPage.FlexPivotPanel; fPanel.FlexPivotEngine.BeginUpdate(); fPanel.ConnectDataEngine(dt.TableName); fPanel.FlexPivotEngine.EndUpdate();