public void ReadMyData(string myConnString) { string mySelectQuery = "SELECT DeptNo, DName FROM Test.Dept"; OracleConnection myConnection = new OracleConnection(myConnString); OracleCommand myCommand = new OracleCommand(mySelectQuery,myConnection); myConnection.Open(); OracleDataReader myReader; myReader = myCommand.ExecuteReader(); // Always call Read before accessing data. while (myReader.Read()) { Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1)); } // always call Close when done reading. myReader.Close(); // Close the connection when done with it. myConnection.Close(); }
Public Sub ReadMyData(myConnString As String) Dim mySelectQuery As String = "SELECT DeptNo, DName FROM Test.Dept" Dim myConnection As New OracleConnection(myConnString) Dim myCommand As New OracleCommand(mySelectQuery, myConnection) myConnection.Open() Dim myReader As OracleDataReader myReader = myCommand.ExecuteReader() ' Always call Read before accessing data. While myReader.Read() Console.WriteLine(myReader.GetInt32(0).ToString() + ", " _ + myReader.GetString(1)) End While ' always call Close when done reading. myReader.Close() ' Close the connection when done with it. myConnection.Close() End Sub