Download the Solution Example here: DatasetGetDataFromDB.dbSln
Download the example database from here: DatasetGetDataFromDB-Data.db
Solution Name: GetDataFromDB
Software Version: 10.1
Summary
This solution showcases an example on how to fill DataGrid with information stored in databases.
Technical Information
The Dataset enables connecting to an existing external Database. Different providers can be used and can be simply and quickly configured.
To each external Database the Module Database will communicate, a connection needs to be created with certain parameters. Each connection, created on Datasets → DBs is called this as Dataset DB.
When using SQLite Databases, the Dataset can automatically create the Database if necessary; for other ones, the Database itself must already exist before you set your connection. Users with any Permission groups can create new connections in the solution, but only the Administrator can configure Databases password logins.
To fill the DataGrid, first load an SQLite database under Datasets → DBs. After that, map the data by navigating to Datasets → Tables, using pre-existing Tags along with the "Mapping Name," database, and table name.
Additionally, the Tables tab can be useful for specifying which data is selected through the WhereCondition column. You can also modify access permissions to the table, allowing the client to either Read and Write information, or just Read.
Reference Information
→ See Datasets (SQL Queries) for more information.
In this section: