Parameters
- i
Return Value
The value to return.
static void GetMyValue(OracleConnection myConnection) { OracleCommand cmd = new OracleCommand("SELECT * FROM Test.AllTypes"); cmd.Connection = myConnection; myConnection.Open(); try { OracleDataReader reader = cmd.ExecuteReader(); reader.Read(); for (short i = 0; i < reader.FieldCount; i++) { if (reader.IsDBNull(i)) Console.WriteLine("NULL"); else { object someValue = reader.GetValue(i); Console.WriteLine(someValue.ToString()); } } reader.Close(); } finally { myConnection.Close(); } }
Shared Sub GetMyValue(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() For i As Short = 0 To reader.FieldCount - 1 If reader.IsDBNull(i) Then Console.WriteLine("NULL") Else Console.WriteLine(reader.GetValue(i).ToString) End If Next i reader.Close() Finally myConnection.Close() End Try End Sub
OracleDataReader Class
OracleDataReader Members
Overload List
GetValueClassGetValueTopic','GetValue.GetValue')">GetValue