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

2024年3月9日发(作者：)

如何与oracle数据库连接

如何与oracle数据库连接

在中配置：

<connectionStrings>

<add name="conn" connectionString ="Provider=服务器名;Data Source=数

据库名;User ID=用户名;Password=密码;"/>

</connectionStrings>

’连接Oracle

Dim strConnect As String =

tionStrings("conn").

ToString()

Dim conn As onnection = New

onnection(strConnect)

’返回数据

Public Function getTable(ByVal sql)

()

Dim comm As ommand = New ommand(sql,

conn)

Dim da As ataAdapter = New

ataAdapter(comm)

Dim dt As ble = New ble()

(dt)

()

Return dt

End Function

’返回受影响的行数

Public Function impactDate(ByVal sql)

()

Dim comm As ommand = New ommand(sql,

conn)

Dim i As Integer = eNonQuery

Return i

End Function