In this article we will explain how to connect to the database, get the table created there and how you can set it.
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.
