dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlCommand Class / CreateParameter Method
Example

On this page
    CreateParameter Method (PgSqlCommand)
    On this page
    Creates a new instance of a PgSqlParameter object.
    Creates a new instance of a PgSqlParameter object.
    Syntax
    'Declaration
     
    Public Shadows Function CreateParameter() As PgSqlParameter
    public new PgSqlParameter CreateParameter()

    Return Value

    A PgSqlParameter object.
    Remarks
    This method is a strongly-typed version of System.Data.IDbCommand.CreateParameter. See PgSqlParameter to find out more ways to create a parameter.
    Example
    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
    See Also