</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle">FlexReport for WPF </div> <div id="PageTitle"><div id="PageTitleText">Retrieving Data from a Database</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="WorkingwithFlexReport.html">Working with FlexReport</a> > <a href="DataBindinginFlexReport.html">Data Binding in FlexReport</a> > Retrieving Data from a Database</td></tr></table></div> <div id="BodyContent"> <p>For retrieving the report data in FlexReport, following DataSource properties of <a href="C1.WPF.FlexReport.4~C1.WPF.FlexReport.C1FlexReport.html">C1FlexReport</a> should be set:</p> <ul> <li>ConnectionString</li> <li>RecordSource</li> </ul> <p>To set data source, use the following code:</p> <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-261e8673-e257-4e07-be26-cb32ca538f78">Visual Basic</a></li> </ul> <div id="TabContent-261e8673-e257-4e07-be26-cb32ca538f78" class="FilteredContent code"> <pre> <span style="COLOR: #0000ff">Dim</span> rep <span style="COLOR: #0000ff">As</span> <span style="COLOR: #0000ff">New</span> C1FlexReport() <span style="COLOR: #008000">'initialize DataSource </span><span style="COLOR: #0000ff">Dim</span> ds <span style="COLOR: #0000ff">As</span> DataSource = rep.DataSource ds.ConnectionString = <span style="COLOR: #800000">"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\...\ComponentOne Samples\Common\C1NWind.mdb;"</span> ds.RecordSource = <span style="COLOR: #800000">"Employees"</span> </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-dd6a1ead-93e0-46c8-8adc-ae0f7b70218e">C#</a></li> </ul> <div id="TabContent-dd6a1ead-93e0-46c8-8adc-ae0f7b70218e" class="FilteredContent code"> <pre> C1FlexReport rep = <span style="COLOR: #0000ff">new</span> C1FlexReport(); <span style="COLOR: #008000">//initialize DataSource </span>DataSource ds = rep.DataSource; ds.ConnectionString = <span style="COLOR: #800000">@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\...\ComponentOne Samples\Common\C1NWind.mdb;"</span>; ds.RecordSource = <span style="COLOR: #800000">"Employees"</span>; </pre> </div> </div> </div> </div> <p>If these properties are set, <strong>C1FlexReport</strong> initializes the data source and uses them to load the data from the database automatically.</p> <a name="seealsobookmark"></a> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright © <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 href="http://our.componentone.com/groups/" target="_blank">Product Support Forum</a> | <a href="http://feedback.componentone.com/forums/272000-wpf-and-silverlight-documentation" target="_blank">Documentation Feedback</a> </div> </body> </html>