Inserting a row in a table

Placeholders for parameters in SQL statements are indicated by the ? character. For any INSERT, UPDATE, or DELETE, each ? is referenced according to its ordinal position in the command's parameters collection. For example, the first ? is referred to as 0, and the second as 1.

Prerequisites

There are no prerequisites for this task.

Task

Declare a ULCommand.
ULCommand cmd;

Assign a SQL statement to the ULCommand object.

cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO MyTable(MyColumn) values (?)";

Assign input parameter values for the statement.

The following code shows a string parameter.

String newValue;

cmd.Parameters.Clear();

// assign value
cmd.Parameters.Add("", newValue);

Execute the statement.

The return value indicates the number of rows affected by the statement.
int rowsInserted = cmd.ExecuteNonQuery();
If you are using explicit transactions, commit the change.
myTransaction.Commit();

Results

A new row is added to MyTable where the MyColumn value is set to an empty string.

Discuss this page in DocCommentXchange.