dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleCommand Class / CreateParameter Method
Example

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

    Return Value

    A OracleParameter object.
    Remarks
    This method is a strongly-typed version of System.Data.IDbCommand.CreateParameter. See OracleParameter to find out more ways to create a parameter.
    Example
    This sample shows how to create a parameter using CreateParameter function.
    Public void CreateParam(OracleConnection oracleConnection)
    {
      OracleCommand oracleCommand = new OracleCommand("SELECT * FROM Test.Dept WHERE DeptNo=:Deptno",oracleConnection);
      OracleParameter myParam = oracleCommand.CreateParameter();
      myParam.OracleDbType = Devart.Data.Oracle.OracleDbType.Integer;
      myParam.Value = 10;
      myParam.ParameterName = "Deptno";
      oracleCommand.Parameters.Add(myParam);
      oracleConnection.Open();
      OracleDataReader oracleReader = null; 
      try
      {
        oracleReader = oracleCommand.ExecuteReader(); 
        while (oracleReader.Read())
        {
          Console.WriteLine(oracleReader.GetInt32(0) + ", " + oracleReader.GetString(1) + ", " + oracleReader.GetString(2));
        }
      }
      finally
      {
        oracleReader.Close();
        oracleConnection.Close();
      }
    }
    Public Sub CreateParam(ByVal oracleConnection As OracleConnection)
      Dim oracleCommand As New OracleCommand("SELECT * FROM Test.Dept WHERE DeptNo=:Deptno", oracleConnection)
      Dim myParam As OracleParameter = oracleCommand.CreateParameter()
      myParam.OracleDbType = Devart.Data.Oracle.OracleDbType.Integer
      myParam.Value = 10
      myParam.ParameterName = "Deptno"
      oracleCommand.Parameters.Add(myParam)
      oracleConnection.Open()
      Dim oracleReader As OracleDataReader = Nothing
      Try
        oracleReader = oracleCommand.ExecuteReader()
        While oracleReader.Read()
          Console.WriteLine(oracleReader.GetInt32(0).ToString() + ", " _
            + oracleReader.GetString(1) + ", " _
            + oracleReader.GetString(2))
        End While
      Finally
        oracleReader.Close()
        oracleConnection.Close()
      End Try
    End Sub
    See Also