</ 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 6 of 8: Setting C1TileControl's Property Mappings</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="Databinding TutorialCreatingaComplex.html">Databinding Tutorial - Creating a Complex Databound TileControl</a> > Step 6 of 8: Setting C1TileControl's Property Mappings</td></tr></table></div> <div id="BodyContent"> <p class="MsoBodyText"><span style="mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">In this step you will add the property mappings to the PropertyMapping class using the <b style="mso-bidi-font-weight: normal;">C1TileControl.PropertyMappings</b> collection editor at design time.</span></p> <p style="mso-list: l0 level1 lfo2;" class="C1HNumber">Select the C1TileControl on the form. In the C1TileControl’s Properties window click on the ellipsis button next to the <b style="mso-bidi-font-weight: normal;">PropertyMappings</b> property. The <b style="mso-bidi-font-weight: normal;">C1TileControl.PropertyMappings Collection Editor</b> appears.</p> <ol> <li> <div> Click Add. A C1.Win.C1Tile.PropertyMapping item will appear like the following. </div> </li> </ol> <blockquote style="margin-right: 0px;" dir="ltr"> <p><img border="0" alt="" src="DocumentsGraphics/C1TileControl.PropertyMappingsCollEditor.png"></p> </blockquote> <ol style="counter-reset: item 2;" start="3"> <li> <div> Set the [*]->[None] member PropertyMapping.DataField to ProductID and PropertyMapping.TileProperty to Tag. </div> </li> <li>Click Add and set the [*]->[None] [1] properties to the following:</li> </ol> <ul> <li style="list-style: none; display: inline"> <div style="margin-left: 4em"> <ul> <li> <div style="mso-list: l0 level1 lfo1;" class="C1HNumber"> <span class="LinkProperty">PropertyMapping.DataField</span> to CategoryID </div> </li> </ul> </div> </li> <li> <div style="text-indent: -0.25in; margin-left: 0.75in; mso-list: l1 level1 lfo2; tab-stops: list .75in;" class="C1HBullet2"> PropertyMapping.Lookup.DataSource to dataSet11 </div> </li> <li> <div style="text-indent: -0.25in; margin-left: 0.75in; mso-list: l1 level1 lfo2; tab-stops: list .75in;" class="C1HBullet2"> PropertyMapping.Lookup.DisplayMember to Categories.CategoryName </div> </li> <li> <div style="text-indent: -0.25in; margin-left: 0.75in; mso-list: l1 level1 lfo2; tab-stops: list .75in;" class="C1HBullet2"> PropertyMapping.Lookup.ValueMember to Categories.CategoryID </div> </li> <li> <div style="text-indent: -0.25in; margin-left: 0.75in; mso-list: l1 level1 lfo2; tab-stops: list .75in;" class="C1HBullet2"> The CategoryID is a foreign key pointing to a category record in the Categories table. Here we create a lookup table which takes the CategoryID value in the Products record, and uses that value to navigate the relationship and return the more readable, category name. </div> </li> <li> <div style="text-indent: -0.25in; margin-left: 0.75in; mso-list: l1 level1 lfo2; tab-stops: list .75in;" class="C1HBullet2"> <span class="LinkProperty">PropertyMapping.TileProperty</span> to Group </div> </li> </ul> <blockquote style="margin-right: 0px;" dir="ltr"> <blockquote style="margin-right: 0px;" dir="ltr"> <p>This will display the categories name for each group of tiles. For example, Beverages, Condiments, Dairy Products, etc.</p> </blockquote> </blockquote> <ol style="counter-reset: item 4;" start="5"> <li> <div> Click Add and set the [*]->[None] [2] properties to the following: </div> </li> <li> <div> <span class="LinkProperty">PropertyMapping.DataField</span> to ProductName </div> </li> <li> <div> <span class="LinkProperty">PropertyMapping.TileProperty</span> to Text </div> </li> <li> <div class="C1HContinue2"> This will display the product’s name on each tile. For example, Chai, Chang, etc. </div> </li> <li> <div style="mso-list: l0 level1 lfo1;" class="C1HNumber"> Click Add and set the [*]->[None] [3] properties to the following: </div> <div style="margin-left: 2em"> <ul> <li> <div style="mso-list: l0 level1 lfo1;" class="C1HNumber"> <span class="LinkProperty">PropertyMapping.DataField</span> to SupplierID </div> </li> <li> <div style="mso-list: l0 level1 lfo1;" class="C1HNumber"> PropertyMapping.Lookup.DataSource to dataSet11 </div> </li> <li> <div style="mso-list: l0 level1 lfo1;" class="C1HNumber"> PropertyMapping.Lookup.DisplayMember to Suppliers.Country </div> </li> <li> <div style="mso-list: l0 level1 lfo1;" class="C1HNumber"> PropertyMapping.Lookup.ValueMember to Suppliers.SupplierID </div> </li> <li> <div style="mso-list: l0 level1 lfo1;" class="C1HNumber"> <span class="LinkProperty">PropertyMapping.TileProperty</span> to Text1 </div> </li> </ul> </div> </li> <li> <div class="C1HContinue2"> This will assign the country name to each tile. </div> </li> <li> <div> Click Add and set the [*]->[None] [4] properties to the following: </div> </li> </ol> <div style="margin-left: 6em"> <ul> <li>PropertyMapping.DataField</li> <li>PropertyMapping.Lookup.DataSource to dataSet11</li> <li>PropertyMapping.Lookup.DataMember to Suppliers.Country</li> <li>PropertyMapping.Lookup.ValueMember to Suppliers.SupplierID</li> <li>PropertyMapping.TileProperty to IntValue</li> </ul> <p> </p> </div> <ol style="counter-reset: item 11;" start="12"> <li>Click Add and set the [*]->[None] [5] properties to the following:</li> <li><span class="LinkProperty">PropertyMapping.DataField</span> to Discontinue.</li> </ol> <div style="margin-left: 6em"> <ul> <li> <div style="mso-list: l0 level1 lfo1;" class="C1HNumber"> <span class="LinkProperty">PropertyMapping.TileProperty</span> to BackColor. </div> </li> </ul> </div> <p class="C1HContinue">The property mappings appear like the following in the members list:</p> <p class="C1HContinue"><img border="0" alt="" src="DocumentsGraphics/ComplexTutPropertyMappings.png"></p> <p style="mso-list: l0 level1 lfo1;" class="C1HNumber"> </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>