'Declaration Public Shadows Function CreateParameter() As OracleParameter
public new OracleParameter CreateParameter()
Return Value
A OracleParameter object.
'Declaration Public Shadows Function CreateParameter() As OracleParameter
public new OracleParameter CreateParameter()
Public void CreateParam(OracleConnection myConnection) { OracleCommand myCommand = new OracleCommand("SELECT * FROM Test.Dept WHERE DeptNo=:Deptno",myConnection); OracleParameter myParam = myCommand.CreateParameter(); myParam.OracleDbType = Devart.Data.Oracle.OracleDbType.Integer; myParam.Value = 10; myParam.ParameterName = "Deptno"; myCommand.Parameters.Add(myParam); myConnection.Open(); OracleDataReader myReader = null; try { myReader = myCommand.ExecuteReader(); while (myReader.Read()) { Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1) + ", " + myReader.GetString(2)); } } finally { myReader.Close(); myConnection.Close(); } }
Public Sub CreateParam(ByVal myConnection As OracleConnection) Dim myCommand As New OracleCommand("SELECT * FROM Test.Dept WHERE DeptNo=:Deptno", myConnection) Dim myParam As OracleParameter = myCommand.CreateParameter() myParam.OracleDbType = Devart.Data.Oracle.OracleDbType.Integer myParam.Value = 10 myParam.ParameterName = "Deptno" myCommand.Parameters.Add(myParam) myConnection.Open() Dim myReader As OracleDataReader = Nothing Try myReader = myCommand.ExecuteReader() While myReader.Read() Console.WriteLine(myReader.GetInt32(0).ToString() + ", " _ + myReader.GetString(1) + ", " _ + myReader.GetString(2)) End While Finally myReader.Close() myConnection.Close() End Try End Sub