Parameters
- i
Return Value
The value of the specified column.
static void GetMyDecimal(OracleConnection myConnection) { OracleCommand cmd = new OracleCommand("SELECT * FROM Test.AllTypes"); cmd.Connection = myConnection; myConnection.Open(); try { OracleDataReader reader = cmd.ExecuteReader(); reader.Read(); decimal recievedDecimal = reader.GetDecimal(reader.GetOrdinal("DecimalCol")); reader.Close(); } finally { myConnection.Close(); } }
Shared Sub GetMyDecimal(ByVal myConnection As OracleConnection) Dim cmd As New OracleCommand("SELECT * FROM Test.AllTypes") cmd.Connection = myConnection myConnection.Open() Try Dim reader As OracleDataReader = cmd.ExecuteReader reader.Read() Dim recievedDecimal As Decimal = reader.GetDecimal(reader.GetOrdinal("DecimalCol")) reader.Close() Finally myConnection.Close() End Try End Sub