CreateParameter Method (PgSqlCommand)
Creates a new instance of a
PgSqlParameter object.
This sample shows how to create a parameter using
CreateParameter function.
|
|---|
Public void CreateParam(PgSqlConnection pgSqlConnection)
{
PgSqlCommand pgSqlCommand = new PgSqlCommand("SELECT * FROM Test.Dept WHERE DeptNo=:Deptno",pgSqlConnection);
PgSqlParameter myParam = pgSqlCommand.CreateParameter();
myParam.PgSqlType = Devart.Data.PostgreSql.PgSqlType.Int;
myParam.Value = 10;
myParam.ParameterName = "Deptno";
pgSqlCommand.Parameters.Add(myParam);
pgSqlConnection.Open();
PgSqlDataReader pgSqlReader = null;
try
{
pgSqlReader = pgSqlCommand.ExecuteReader();
while (pgSqlReader.Read())
{
Console.WriteLine(pgSqlReader.GetInt32(0) + ", " + pgSqlReader.GetString(1) + ", " + pgSqlReader.GetString(2));
}
}
finally
{
pgSqlReader.Close();
pgSqlConnection.Close();
}
} |
|
|---|
Public Sub CreateParam(ByVal pgSqlConnection As PgSqlConnection)
Dim pgSqlCommand As New PgSqlCommand("SELECT * FROM Test.Dept WHERE DeptNo=:Deptno", pgSqlConnection)
Dim myParam As PgSqlParameter = pgSqlCommand.CreateParameter()
myParam.PgSqlType = Devart.Data.PostgreSql.PgSqlType.Int
myParam.Value = 10
myParam.ParameterName = "Deptno"
pgSqlCommand.Parameters.Add(myParam)
pgSqlConnection.Open()
Dim pgSqlReader As PgSqlDataReader = Nothing
Try
pgSqlReader = pgSqlCommand.ExecuteReader()
While pgSqlReader.Read()
Console.WriteLine(pgSqlReader.GetInt32(0).ToString() + ", " _
+ pgSqlReader.GetString(1) + ", " _
+ pgSqlReader.GetString(2))
End While
Finally
pgSqlReader.Close()
pgSqlConnection.Close()
End Try
End Sub |