5.3 Parameterized Queries

Table of Contents Previous Next


5 Using the .NET Connector : 5.3 Parameterized Queries

A parameterized query is a query with one or more parameter markers embedded in the SQL statement. Before executing a parameterized query, you must supply a value for each marker found in the text of the SQL statement.
As demonstrated in the following example, you must declare the data type of each parameter specified in the parameterized query by creating an EDBParameter object and adding that object to the command's parameter collection. Then, you must specify a value for each parameter by calling the parameter's Value() function.
The example demonstrates use of a parameterized query with an UPDATE statement that increases an employee salary:

5 Using the .NET Connector : 5.3 Parameterized Queries

Table of Contents Previous Next