In this tutorial we will learn how to read and write data from/into a database.
We will work with the database on the Microsoft SQL Server database server.
We will connect to the database using the object PmaAdo, create a table in it
and add records to it. We will then display these records in the table in the application panel.
Subsequently, we will edit the displayed records and write them back into the database.
Video list:
Tutorial 7.1 Databases - Introduction
In the video we create a table in SQL database and fill it with data
Tutorial 7.2 Databases - Reading and displaying data from the database
In the video we read data from the database table and display it in the table in the panel
Tutorial 7.3 Databases - Writing data into a database
In the video we change the data in the table in the panel and save the changes into the database table