CreateParameter Method (OracleCommand)
Creates a new instance of a
OracleParameter object.
This sample shows how to create a parameter using
CreateParameter function.
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