SQLiteParameterCollection Class
Collects all parameters relevant to a
SQLiteCommand as well as their respective mappings to
System.Data.DataSet columns.
The following example adds instance of
SQLiteParameter to collection.
|
|---|
public void AddSQLiteParameters()
{
// Create sqLiteConnection and sqLiteCommand.
sqLiteCommand.CommandText = "DELETE Dept WHERE DeptNo = :DeptNo";
sqLiteCommand.Parameters.Add("DeptNo", SQLiteType.Int32).Value = 50;
sqLiteCommand.ExecuteNonQuery();
} |
|
|---|
Public Sub AddSQLiteParameters()
// Create sqLiteConnection and sqLiteCommand.
sqLiteCommand.CommandText = "DELETE Dept WHERE DeptNo = :DeptNo"
sqLiteCommand.Parameters.Add("DeptNo", SQLiteType.Int32).Value = 50
sqLiteCommand.ExecuteNonQuery()
End Sub 'AddSQLiteParameters |