vb.net连接oracle数据库

一、连接的网页参考
http://www.connectionstrings.com/

二、连接代码

1、 Dim myConnection As OleDbConnection
        Dim myOracleDataAdapter As OleDbDataAdapter

        myConnection = New OleDbConnection("Provider=OraOLEDB.Oracle.1;Data Source=home2;user id=system;password=a1b2c3d4")
        myOracleDataAdapter = New OleDbDataAdapter("select * from member", myConnection)

        Dim myDataSet As DataSet = New DataSet
        Dim myDataRow As DataRow
        myOracleDataAdapter.Fill(myDataSet, "member")
        MessageBox.Show(myDataSet.Tables("member").Rows(0)(0))

 

2、' Dim myconnectionstring As String '定义字符串
        ' Dim myconn As OleDbConnection '定义连接符
        'myconnectionstring = "Provider=OraOLEDB.Oracle;User ID=system;Data Source=home2;Password=a1b2c3d4"
        'myconn = New OleDbConnection(myconnectionstring)
        ' myconn.Open()
        ' MessageBox.Show("nnn")
        '这里开始读取
        ' myconn.Close()

视频教程

http://www.ibook8.com/tech/vs2005.html