FlexPivot gives you the flexibility of customizing your data source, and of choosing how you want to connect to accomplish data binding—with or without code. For very large data sets, you might want to try the C1DataEngine, which makes it easy to connect with FlexPivot and draw millions of records in little time.
To connect to C1DataEngine, you'll need a little code. For this example, we used C#:
Initialize a C1DataEngine using the following code within the form's constructor.
//initialize C1DataEngine C1.DataEngine.Workspace.Init(dataPath);
This code initializes the dataPath folder where the C1DataEngine stores data in files. This folder is initially empty and fills with files automatically when data is added to the data engine.
Add the following code to connect to the database using a standard ADO.NET command.
//connecting to database using ADO.NET command var command = new SqlCommand(sqlStatement, connection); var connector = new C1.DataEngine.DbConnector(connection, command); connector.GetData(tableName);
Connect the FlexPivotPage control to the data engine using the code given below.
You successfully connected FlexPivot to a C1DataEngine. To update your data, check out the documentation.
You can get your FlexPivot application up and running using design-time settings without having to code. This gets you analyzing your data faster without using your valuable time coding.
The C1FlexPivotPage control docks to fill the form in the designer as shown in the image below.
From the Configuration Wizard, you'll be able to select the Invoices view for data binding as shown in the image below.
Check out the FlexPivot documentation »
Find more information on FlexPivot »