</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle">ComponentOne True DBGrid Pro 8</div> <div id="PageTitle"><div id="PageTitleText">Refetching Data from the Data Source</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="databaseprogrammingtechniques.html">Database Programming Techniques</a> > Refetching Data from the Data Source</td></tr></table></div> <div id="BodyContent"> <p>Normally, you need not be concerned with the mechanics of data retrieval. True DBGrid retrieves data automatically as needed, in blocks of ten rows, and only gathers data for visible columns. However, in some cases, you can improve performance by fetching only the data for a single (changed) row, column, or cell using one of the following methods:</p> <table cellspacing="0" cellpadding="0" border="0"> <tbody> <tr> <td valign="top" width="99"> <p><a href="javascript:TL_1019522.HHClick()">RefetchRow</a></p> </td> <td valign="top" width="460"> <p>Given a bookmark, this <a href="javascript:TL_1019523.HHClick()">TDBGrid</a> control method repopulates the specified row from the data source.</p> </td> </tr> <tr> <td valign="top" width="99"> <p><a href="javascript:TL_1019524.HHClick()">RefetchCol</a></p> </td> <td valign="top" width="460"> <p>Given a column index, this <a href="javascript:TL_1019525.HHClick()">TDBGrid</a> control method repopulates the specified column from the data source.</p> </td> </tr> <tr> <td valign="top" width="99"> <p><a href="javascript:TL_1019526.HHClick()">RefetchCell</a></p> </td> <td valign="top" width="460"> <p>Given a bookmark, this <a href="javascript:TL_1019527.HHClick()">Column</a> object method repopulates the specified cell from the data source.</p> </td> </tr> </tbody> </table> <p>These methods repaint the affected cells, firing all events necessary for redisplay. However, they do not force the data source control to refresh its own data from the underlying database. You must use data control methods or options to accomplish this.</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/255792-activex-documentation">Documentation Feedback</a> </div> </body> </html>