Download the Solution Example here: GettingDataFromDBDatasetGetDataFromDB.rardbSln
Solution Name: GetDataFromDB
Software Version: v10.0.6
Keywords: Dataset. Database. Data.
Solution Summary
This solution example shows how to display Data from a Database according to the selected row in a DataGrid component.
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.
Reference Information
See "Datasets and SQL" for more information.