Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info

...

icon

...

false

...

Download the

...

Solution Example:

Solution file: GetDataFromDB.dbSln
Database file: GetDataFromDB.db


  • Solution Name:

...

  • Get Data From DB
  • Software Version:

...

  • v10

...

  • Keywords:

...

  • DataGrid. Database.

...

  • Datasets.

...


Summary

This solution

...

demonstrates how to

...

populate a DataGrid with information stored in databases.

Image Added


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

...

...

(SQL Queries) for more information.


In this section

...

:

Page Tree
rootSolution Examples
spacesV10