VB.Net链接Oracle的两种方法。
链接Oracle有两种方法,一种是Oracle官网提供的链接方式,第二种是利用Oledb的方式链接
两种代码大同小异。但是一并贴出来大家看看。
其实还有很多方法,比如ODBC之类的方法,这里我没有机会尝试,以后补齐。
Imports System.Data
Imports Oracle.DataAccess.Client
Imports System.Data.OleDb
Imports System.Windows.Forms
------------Oracle官方链接方法---------------------------
Dim oradb As String = "Data Source=OraDb_192.168.1.148;User
Id=scott;Password=tiger;"
Dim conn As New OracleConnection(oradb) ' VB.NET
conn.Open()
Dim cmd As New OracleCommand
cmd.Connection = conn
cmd.CommandText = "select user from user_users"
cmd.CommandType = CommandType.Text
Dim dr As OracleDataReader = cmd.ExecuteReader()
dr.Read()
label1.Text = dr.Item("user") ' or dr.Item(0)
Console.WriteLine(dr.Item(0))
conn.Dispose()
Console.ReadLine()
-------------------VB.Net链接Oracle方法--------------------------------------
Dim myConnection As OleDbConnection
Dim myOracleDataAdapter As OleDbDataAdapter
myConnection = New OleDbConnection("Provider=OraOLEDB.Oracle.1;Data
_