</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle">TileControl for WinForms</div> <div id="PageTitle"><div id="PageTitleText">Step 2 of 4: Configuring a Data Connection and Data Adapter</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="Data Binding Overview.html">Data Binding Overview</a> > <a href="DatabindingTutorialCreatingaSimpleDataBound.html">Databinding Tutorial - Creating a Simple Databound TileControl</a> > Step 2 of 4: Configuring a Data Connection and Data Adapter</td></tr></table></div> <div id="BodyContent"> <p class="MsoBodyText">In this step, you will add one data adapter for the table: products.</p> <ol> <li> <div style="mso-list: l0 level1 lfo2;" class="C1HNumber"> From the Toolbox, double-click the OleDbDataAdapter component. If it’s not in the toolbox, right-click and select <strong>Choose Items</strong>. On the .NET Framework Components tab in the dialog box, select <strong>OleDbDataAdapter</strong>. The OleDbDataAdapter appears in the component tray and the <strong>Data Adapter Configuration Wizard</strong> appears. </div> </li> <li> <div style="mso-list: l0 level1 lfo1;" class="C1HNumber"> In the Data Adapter Configuration Wizard, choose the connection you wish to use for the data adapter from the drop-down listbox (in this case, <strong>C:\Users\UserName\Documents\ComponentOne Samples\Common\C1NWind.mdb</strong>) and then click <strong>Next</strong>. </div> </li> <li> <div style="mso-list: l0 level1 lfo1;" class="C1HNumber"> <span style='mso-bidi-font-family: "Times New Roman";'><span style="mso-list: Ignore;"><span style='font: 7pt/normal "Times New Roman"; font-size-adjust: none; font-stretch: normal;'> </span></span></span>The Use SQL Statements is selected by default, click <strong>Next</strong>. </div> </li> <li> <div style="mso-list: l0 level1 lfo1;" class="C1HNumber"> Copy and paste the following SQL statement in the textbox of the <strong>Data Adapter Configuration Wizard</strong>: </div> </li> </ol> <blockquote style="margin-right: 0px;" dir="ltr"> <p class="C1HContinue">SELECT<span style="mso-spacerun: yes;"> </span> Products.*</p> <p class="C1HContinue">FROM<span style="mso-spacerun: yes;"> </span> Products</p> </blockquote> <ol style="counter-reset: item 4;" start="5"> <li> <div style="mso-list: l0 level1 lfo1;" class="C1HNumber"> Click <strong>Next</strong>. </div> </li> <li> <div style="mso-list: l0 level1 lfo1;" class="C1HNumber"> Click <strong>Finish</strong>. </div> </li> </ol> <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>