Get And Set Table in Database

In this article we will explain how to connect to the database, get the table created there and how you can set it.

image

Step 1: Database opens with Open Connection component.

Step 2: The table in the database is transferred to the data with Execute query component.

Step 3: The row number of the drawn table is learned with Get size component.

Step 4: A sub process is added to create a loop to enter each line into the database.

Step 5: The rows of the Ad column in the dataset are read and write to the variable with Get action component.

Step 6: The rows of the Soyad column in the dataset are read and write to the variable with Get action component.

Step 7: The rows of the Şirket Adı column in the dataset are read and write to the variable with Get action component.

Step 8: The rows of the Meslek column in the dataset are read and write to the variable with Get action component.

Step 9: The variables received are inserted in the sql language with Execute update component.

Step 10: Database closes with Close connection component.