VB.NET Connect Oracle

使用Oracle连接数据库

最新推荐文章于 2024-02-29 08:58:01 发布

最新推荐文章于 2024-02-29 08:58:01 发布 · 251 阅读

文章标签：

#VB.NET #VB #.net #Oracle #SQL

.NET 专栏收录该内容

9 篇文章

订阅专栏

本文介绍了一个使用Oracle客户端连接Oracle数据库并执行SQL查询的例子。通过VB.NET代码实现与Oracle数据库的交互，具体展示了如何配置连接字符串、打开连接、执行查询及处理结果。

Prerequisites: Install oracle9/10g Client. configure the TNSNAME.ora

Connect oracle database case by OracleConnection:

Private Sub BtnOracle_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnOracle.Click

        Dim OracleConn As New OracleConnection
        Dim OracleCom As New OracleCommand
        OracleConn.ConnectionString = "user id=RCOTRPR1;data source='a3cotr.ncs.com';password=RCOTRPR1"
        Dim branch As String
        branch = TxtBranch.Text

        Try
            OracleConn.Open()
            Dim sql As String = "select branchname from cots_tab_branch where branch =" & branch
            Dim cmd As New OracleCommand(sql, OracleConn)
            cmd.CommandType = CommandType.Text

            Dim dr As OracleDataReader = cmd.ExecuteReader()
            dr.Read()
            MessageBox.Show(dr.Item("branchname"), "oracle")
        Catch ex As Exception
            MessageBox.Show(ex.Message.ToString())

Finally
OracleConn.Dispose()

End Try

End Sub