</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle">FlexPivot for WinForms</div> <div id="PageTitle"><div id="PageTitleText">Step 2: Connecting FlexPivotPage Control with DataEngine</div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="FlexPivotforWinFormsQuickStart.html">Quick Start: FlexPivot for WinForms</a> > <a href="UsingFlexPivotControlswithC1DataEngine.html">Using FlexPivot Controls with C1DataEngine</a> > Step 2: Connecting FlexPivotPage Control with DataEngine</td></tr></table></div> <div id="BodyContent"> <p>In the previous step, you created a basic Windows Forms application and added FlexPivotPage control to it. In this step, you begin with connecting the FlexPivotPage control to <a href="C1.DataEngine.4~C1.DataEngine_namespace.html">C1DataEngine</a>.</p> <p>To connect the FlexPivotPage control to C1DataEngine, perform the following steps. </p> <ol> <li>Switch to the code view i.e. Form1.cs and initialize workspace within the form's constructor. <div class="TabContainer TabContainerWidget"> <ul> <li class="FilteredContentVB"><a href="#TabContent-VB">Visual Basic</a></li> <li class="FilteredContentCS"><a href="#TabContent-CS">C#</a></li> </ul> <div id="TabContent-VB" class="FilteredContentVB"> <div class="FilteredContentVB TabContainer TabContainerWidget" data-title="Visual Basic" data-itemid="VB"> <ul> <li><a href="#TabContent-4f14a50a-c143-45d3-a0ec-2c9f97a5c89b">Visual Basic</a></li> </ul> <div id="TabContent-4f14a50a-c143-45d3-a0ec-2c9f97a5c89b" class="FilteredContent code"> <pre> Type your example code here. It will be automatically colorized when you switch <span style="COLOR: #0000ff">to</span> Preview <span style="COLOR: #0000ff">or</span> build the help system. </pre> </div> </div> </div> <div id="TabContent-CS" class="FilteredContentCS"> <div class="FilteredContentCS TabContainer TabContainerWidget" data-title="C#" data-itemid="CS"> <ul> <li><a href="#TabContent-c70fd094-f6db-4e0e-88be-ffe06d1ae49b">C#</a></li> </ul> <div id="TabContent-c70fd094-f6db-4e0e-88be-ffe06d1ae49b" class="FilteredContent code"> <pre> Type your example code here. It will be automatically colorized when you <span style="COLOR: #0000ff">switch</span> to Preview or build the help system. </pre> </div> </div> </div> </div> </li> <li>Initialize full path to the folder where the DataEngine stores data in files, and an SQL connection above the Form's constructor using the following code. <div class="TabContainer TabContainerWidget"> <ul> <li class="FilteredContentVB"><a href="#TabContent-VB">Visual Basic</a></li> <li class="FilteredContentCS"><a href="#TabContent-CS">C#</a></li> </ul> <div id="TabContent-VB" class="FilteredContentVB"> <div class="FilteredContentVB TabContainer TabContainerWidget" data-title="Visual Basic" data-itemid="VB"> <ul> <li><a href="#TabContent-ed877f1f-04d9-4381-87eb-2f7bacb20159">Visual Basic</a></li> </ul> <div id="TabContent-ed877f1f-04d9-4381-87eb-2f7bacb20159" class="FilteredContent code"> <pre> Type your example code here. It will be automatically colorized when you switch <span style="COLOR: #0000ff">to</span> Preview <span style="COLOR: #0000ff">or</span> build the help system. </pre> </div> </div> </div> <div id="TabContent-CS" class="FilteredContentCS"> <div class="FilteredContentCS TabContainer TabContainerWidget" data-title="C#" data-itemid="CS"> <ul> <li><a href="#TabContent-c3a573ca-1c0e-40ca-9269-89f7288b88c2">C#</a></li> </ul> <div id="TabContent-c3a573ca-1c0e-40ca-9269-89f7288b88c2" class="FilteredContent code"> <pre> Type your example code here. It will be automatically colorized when you <span style="COLOR: #0000ff">switch</span> to Preview or build the help system. </pre> </div> </div> </div> </div> <p>Initially, the DataEngine is empty but it automatically fills with files as and when the data is added to it.</p> </li> <li>Initialize a standard connection string to the database file being used. <div class="TabContainer TabContainerWidget"> <ul> <li class="FilteredContentVB"><a href="#TabContent-VB">Visual Basic</a></li> <li class="FilteredContentCS"><a href="#TabContent-CS">C#</a></li> </ul> <div id="TabContent-VB" class="FilteredContentVB"> <div class="FilteredContentVB TabContainer TabContainerWidget" data-title="Visual Basic" data-itemid="VB"> <ul> <li><a href="#TabContent-23b1a5a5-1eb3-4f07-9837-247f7b81c611">Visual Basic</a></li> </ul> <div id="TabContent-23b1a5a5-1eb3-4f07-9837-247f7b81c611" class="FilteredContent code"> <pre> Type your example code here. It will be automatically colorized when you switch <span style="COLOR: #0000ff">to</span> Preview <span style="COLOR: #0000ff">or</span> build the help system. </pre> </div> </div> </div> <div id="TabContent-CS" class="FilteredContentCS"> <div class="FilteredContentCS TabContainer TabContainerWidget" data-title="C#" data-itemid="CS"> <ul> <li><a href="#TabContent-daf30d67-5cc7-47d3-a199-957784e8de8b">C#</a></li> </ul> <div id="TabContent-daf30d67-5cc7-47d3-a199-957784e8de8b" class="FilteredContent code"> <pre> Type your example code here. It will be automatically colorized when you <span style="COLOR: #0000ff">switch</span> to Preview or build the help system. </pre> </div> </div> </div> </div> </li> <li>Switch to the Design view and subscribe <strong>Form1_Load</strong> event from the <strong>Properties</strong> window. </li> <li>Add the following code to the event handler created for <strong>Form1_Load</strong> event in the code view. <div class="TabContainer TabContainerWidget"> <ul> <li class="FilteredContentVB"><a href="#TabContent-VB">Visual Basic</a></li> <li class="FilteredContentCS"><a href="#TabContent-CS">C#</a></li> </ul> <div id="TabContent-VB" class="FilteredContentVB"> <div class="FilteredContentVB TabContainer TabContainerWidget" data-title="Visual Basic" data-itemid="VB"> <ul> <li><a href="#TabContent-70a534bf-6928-45be-83b3-15cc57557bed">Visual Basic</a></li> </ul> <div id="TabContent-70a534bf-6928-45be-83b3-15cc57557bed" class="FilteredContent code"> <pre> Type your example code here. It will be automatically colorized when you switch <span style="COLOR: #0000ff">to</span> Preview <span style="COLOR: #0000ff">or</span> build the help system. </pre> </div> </div> </div> <div id="TabContent-CS" class="FilteredContentCS"> <div class="FilteredContentCS TabContainer TabContainerWidget" data-title="C#" data-itemid="CS"> <ul> <li><a href="#TabContent-fadbf1af-9f68-4cca-823b-70fe20e247dc">C#</a></li> </ul> <div id="TabContent-fadbf1af-9f68-4cca-823b-70fe20e247dc" class="FilteredContent code"> <pre> Type your example code here. It will be automatically colorized when you <span style="COLOR: #0000ff">switch</span> to Preview or build the help system. </pre> </div> </div> </div> </div> </li> </ol> <p>With this, you have successfully connected the FlexPivotPage control to the DataEngine. </p> <a name="seealsobookmark"></a> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright (c) <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved. <script> $(document).ready(function() { if (!(window.self !== window.top)) { // Not running in a frameset // Get the page name var pageName = location.href.substring(location.href.lastIndexOf("/") + 1); if (pageName.indexOf("#") != -1) { pageName = pageName.substring(0, pageName.indexOf("#")); } // Append to webframe.html var framePage = "webframe.html#" + pageName; location.href = framePage; } }); </script></p> <a target="_blank" href="http://our.componentone.com/groups/">Product Support Forum</a> | <a target="_blank" href="http://feedback.componentone.com/forums/255782-winforms-documentation">Documentation Feedback</a> </div> </body> </html>