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 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 |