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 sqConnection and sqCommand.
sqCommand.CommandText = "DELETE Dept WHERE DeptNo = :DeptNo";
sqCommand.Parameters.Add("DeptNo", SQLiteType.Int32).Value = 50;
sqCommand.ExecuteNonQuery();
}
Public Sub AddSQLiteParameters()
// Create sqConnection and sqCommand.
sqCommand.CommandText = "DELETE Dept WHERE DeptNo = :DeptNo"
sqCommand.Parameters.Add("DeptNo", SQLiteType.Int32).Value = 50
sqCommand.ExecuteNonQuery()
End Sub 'AddSQLiteParameters