Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » UltraLite - .NET Programming » UltraLite.NET application development » Data creation and modification using SQL statements » Data modification using INSERT, UPDATE, and DELETE


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.


There are no prerequisites for this task.

  1. Declare a ULCommand.

    ULCommand cmd;
  2. Assign a SQL statement to the ULCommand object.

    cmd = conn.CreateCommand();
    cmd.CommandText = "INSERT INTO MyTable(MyColumn) values (?)";
  3. Assign input parameter values for the statement.

    The following code shows a string parameter.

    String newValue;
    // assign value
    cmd.Parameters.Add("", newValue);
  4. Execute the statement.

    The return value indicates the number of rows affected by the statement.

    int rowsInserted = cmd.ExecuteNonQuery();
  5. If you are using explicit transactions, commit the change.



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