Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Visual Basic 2005 Basics If you are new to Visual Basic programming with version 2005, this is the place to start your questions. For questions about the book: Beginning Visual Basic 2005 by Thearon Willis and Bryan Newsome, ISBN: 0-7645-7401-9 please, use this forum instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Basic 2005 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 13th, 2007, 07:33 AM
Registered User
 
Join Date: Feb 2007
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Connecting to Oracle8i

Hi,

having a problem getting my program to display any data from my oracle db. Its a web based app, with the page having only a gridview on it. However when the page opens it displays nothing. The data does exist in the db but for some reason isnt being displayed. I am a complete newbie by the way so please be nice......

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim dbConn As New OracleConnection

        dbConn.ConnectionString = "Data Source=bnp;Persist Security Info=True;User ID=bnp;Password=bnp"
        dbConn.Open()

        Dim dbDataAdapter As New OracleDataAdapter()
        dbDataAdapter.SelectCommand = New OracleCommand()

        dbDataAdapter.SelectCommand.Connection = dbConn
        dbDataAdapter.SelectCommand.CommandText = "Select cu_name from cu_offices where cu_name =WCS"
        dbDataAdapter.SelectCommand.CommandType = CommandType.Text

        Dim dbDataSet As New DataSet

        dbDataAdapter.Fill(dbDataSet, "names")
        GridView1.AutoGenerateColumns = True
        GridView1.DataSource = dbDataSet
        GridView1.DataMember = "names"

    End Sub

any help at all would be really appreciated, as this is driving me mad.

Regards,

David.




Similar Threads
Thread Thread Starter Forum Replies Last Post
Move Data from oracle10g to oracle8i mohammed_aid Oracle 0 December 11th, 2005 02:23 PM
Migration from Oracle8i to Oracle9i muthukumar Oracle 0 November 14th, 2005 12:32 AM
how to configure os authentication in oracle8i?? scorpion Oracle 1 July 5th, 2004 07:07 AM
Help connecting!!! tim33_909 SQL Server 2000 4 November 5th, 2003 01:34 PM
How to create net service name in oracle8i monif Oracle 0 September 11th, 2003 06:07 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.