Database connection With the AHMI

[Ibrahim]

Hi,

any instructions plz about the AdvancedHMI connecting with database(Mysql or ms access) for the newbies.

many thnks

Ibrahim

[Archie]

Here are a few steps to start with:

The first thing you will need to do is to setup the database connection. and create a DataSet. In Visual Studio, go to View->Other Windows->Data Sources. Once that window opens, click Add New Data Source

Once the Wizard opens up, select Database, then Dataset. From there follow the wizard to connect to your database and select the tables you wish to use.

After that you can drag from the Data Sources window directly to the form to make a codeless database app.

[Mikefly95]

If you are going to use MySQL you will need to install and reference the .net connector.

https://dev.mysql.com/downloads/connector/net/6.9.html