<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE html> <html lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <!-- sql-programming.qdoc --> <title>Creating Data-Aware Forms | Qt SQL 5.12.6</title> <link rel="stylesheet" type="text/css" href="style/offline-simple.css" /> <script type="text/javascript"> document.getElementsByTagName("link").item(0).setAttribute("href", "style/offline.css"); // loading style sheet breaks anchors that were jumped to before // so force jumping to anchor again setTimeout(function() { var anchor = location.hash; // need to jump to different anchor first (e.g. none) location.hash = "#"; setTimeout(function() { location.hash = anchor; }, 0); }, 0); </script> </head> <body> <div class="header" id="qtdocheader"> <div class="main"> <div class="main-rounded"> <div class="navigationbar"> <table><tr> <td >Qt 5.12</td><td ><a href="qtsql-index.html">Qt SQL</a></td><td >Creating Data-Aware Forms</td></tr></table><table class="buildversion"><tr> <td id="buildversion" width="100%" align="right"><a href="qtsql-index.html">Qt 5.12.6 Reference Documentation</a></td> </tr></table> </div> </div> <div class="content"> <div class="line"> <div class="content mainContent"> <link rel="prev" href="sql-presenting.html" /> <p class="naviNextPrevious headerNavi"> <a class="prevPage" href="sql-presenting.html">Presenting Data in a Table View</a> </p><p/> <div class="sidebar"><div class="sidebar-content" id="sidebar-content"></div></div> <h1 class="title">Creating Data-Aware Forms</h1> <span class="subtitle"></span> <!-- $$$sql-forms.html-description --> <div class="descr"> <a name="details"></a> <p>Using the SQL models described above, the contents of a database can be presented to other model/view components. For some applications, it is sufficient to present this data using a standard item view, such as <a href="../qtwidgets/qtableview.html">QTableView</a>. However, users of record-based applications often require a form-based user interface in which data from a specific row or column in a database table is used to populate editor widgets on a form.</p> <p>Such data-aware forms can be created with the <a href="../qtwidgets/qdatawidgetmapper.html">QDataWidgetMapper</a> class, a generic model/view component that is used to map data from a model to specific widgets in a user interface.</p> <p><a href="../qtwidgets/qdatawidgetmapper.html">QDataWidgetMapper</a> operates on a specific database table, mapping items in the table on a row-by-row or column-by-column basis. As a result, using <a href="../qtwidgets/qdatawidgetmapper.html">QDataWidgetMapper</a> with an SQL model is as simple as using it with any other table model.</p> <p class="centerAlign"><img src="images/qdatawidgetmapper-simple.png" alt="" /></p><p>The <a href="qtsql-books-example.html">Books</a> example shows how information can be presented for easy access by using <a href="../qtwidgets/qdatawidgetmapper.html">QDataWidgetMapper</a> and a set of simple input widgets.</p> </div> <!-- @@@sql-forms.html --> <p class="naviNextPrevious footerNavi"> <a class="prevPage" href="sql-presenting.html">Presenting Data in a Table View</a> </p> </div> </div> </div> </div> </div> <div class="footer"> <p> <acronym title="Copyright">©</acronym> 2019 The Qt Company Ltd. Documentation contributions included herein are the copyrights of their respective owners.<br/> The documentation provided herein is licensed under the terms of the <a href="http://www.gnu.org/licenses/fdl.html">GNU Free Documentation License version 1.3</a> as published by the Free Software Foundation.<br/> Qt and respective logos are trademarks of The Qt Company Ltd. in Finland and/or other countries worldwide. All other trademarks are property of their respective owners. </p> </div> </body> </html>