vb与oracle数据库连接,vb.net 如何与oracle数据库连接

vb.net 如何与oracle数据库连接

在web.config中配置：

’连接Oracle

Dim strConnect As String = System.Web.Configuration.WebConfigurationManager.ConnectionStrings("conn").ToString()

Dim conn As OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(strConnect)

’返回数据

Public Function getTable(ByVal sql)

conn.Open()

Dim comm As OleDb.OleDbCommand = New OleDb.OleDbCommand(sql, conn)

Dim da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(comm)

Dim dt As System.Data.DataTable = New System.Data.DataTable()

da.Fill(dt)

conn.Close()

Return dt

End Function

’返回受影响的行数

Public Function impactDate(ByVal sql)

conn.Open()

Dim comm As OleDb.OleDbCommand = New OleDb.OleDbCommand(sql, conn)

Dim i As Integer = comm.ExecuteNonQuery

Return i

End Function