SQLTeam.com | Weblogs | Forums

Execution of embedded SQL C-program in the backend


#1

When a C program is written using Embedded SQL, (e.g.: assume that a table is created with values inserted into it), how it gets executed in the back-end before displaying the output table in the front-end?
This question may seem theoretical but can anyone help me get an answer?


#2

Assuming your C program is Visual C and you are using .NET libraries:

  1. Establish a connection using SQLConnection
  2. Open the connection
  3. Build a SQLCommand object on the connection
  4. Point the SQLCommand to your query string
  5. Execute the SqlCommand
  6. Process the results.

#3

Thank you for your explanation @gbritton