Connecting to Oracle8i
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"
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
GridView1.AutoGenerateColumns = True
GridView1.DataSource = dbDataSet
GridView1.DataMember = "names"
any help at all would be really appreciated, as this is driving me mad.