Oracle question

[icDavid]

Hi VB/Oracle expert!! How can I utilize VB to read Oracle database? Thanks a bunch, icdavid

[Sebzy]

Yep have a look at this Namespace: System.Data.OracleClient OracleConnection http://msdn2.microsoft.com/en-us/library/system.data.oracleclient.oracleconnection.aspx OracleCommand http://msdn2.microsoft.com/en-us/library/y051k82s(en-US,VS.80).aspx OracleCommandBuilder http://msdn2.microsoft.com/en-us/library/0ca0k1ad(en-US,VS.80).aspx Example The following example uses the ExecuteReader method of OracleCommand, along with OracleDataReader and OracleConnection, to select rows from a table. Public Sub ReadMyData(ByVal connectionString As String) Dim queryString As String = "SELECT EmpNo, DeptNo FROM Scott.Emp" Using connection As New OracleConnection(connectionString) Dim command As New OracleCommand(queryString, connection) connection.Open() Dim reader As OracleDataReader = command.ExecuteReader() Try While reader.Read() Console.WriteLine(reader.GetInt32(0) & ", " _ & reader.GetInt32(1)) End While Finally ' always call Close when done reading. reader.Close() End Try End Using End Sub