none
Connection VB9 com Oracle 11g RRS feed

  • Question

  • ConnectionString


    How would the connection connectionString for Oracle 11g of the example below.

     

    Public Sub InsertRow(ByVal connectionString As String)
        Dim queryString As String = _
            "INSERT INTO Dept (DeptNo, Dname, Loc) values (50, 'TECHNOLOGY', 'DENVER')"

        Using connection As New OracleConnection(connectionString)
              Dim command As New OracleCommand(queryString)
              command.Connection = connection
              Try
                    connection.Open()
                    command.ExecuteNonQuery()
              Catch ex As Exception
                    Console.WriteLine(ex.Message)
               End Try
          End Using
    End Sub

    Thanks
    Claudinei
    nei.silva@vivax.com.br

     

    Sunday, March 9, 2008 6:17 AM

Answers