PgSqlParameterCollection Class
Collects all parameters relevant to a
PgSqlCommand as well as their respective mappings to
System.Data.DataSet columns.
The following example adds instance of
PgSqlParameter to collection.
|
|---|
public void AddPgSqlParameters()
{
// Create pgSqlConnection and pgSqlCommand.
pgSqlCommand.CommandText = "DELETE Test.Dept WHERE DeptNo = :DeptNo";
pgSqlCommand.Parameters.Add("DeptNo", PgSqlType.Int).Value = 50;
pgSqlCommand.ExecuteNonQuery();
} |
|
|---|
Public Sub AddPgSqlParameters()
// Create pgSqlConnection and pgSqlCommand.
pgSqlCommand.CommandText = "DELETE Test.Dept WHERE DeptNo = :DeptNo"
pgSqlCommand.Parameters.Add("DeptNo", PgSqlType.Int).Value = 50
pgSqlCommand.ExecuteNonQuery()
End Sub 'AddPgSqlParameters |