
June 2nd, 2003, 08:52 PM
|
|
Registered User
|
|
Join Date: Jun 2003
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
SQLOLEDB connection error.. help~
I encounter with the problem of connection my data in sql server 2000. I wondering y all the data i retrieve is in this kind of format.. <br>System.Data.Common.DbDataRecord<br>but not the exact value. I am stuck here.. Can somemore help me out.. <br><br>tat is my code in web.config<br>add key="MyDbCon" value="Provider=SQLOLEDB;User ID=sa;Password=fyp;Data Source=dolphin;Initial Catalog=OnlineBookStore"<br><br>tat is my code in Global.asax.vb<br>Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)<br> ' Fires when the application is started<br> Application("SQLConnectionString") = ConfigurationSettings.AppSettings("MyDbCon")<br>End Sub<br><br>and lastly is my code in signup.aspx.vb to retrive the data<br>Sub GetProfession()<br> Dim objReader As OleDbDataReader<br> Dim objConnection As New OleDbConnection(Application("SQLConnectionString"))<br><br> Dim objProfession As New OleDbCommand("select profession_description from profession order by profession_Description", objConnection)<br> Try<br> objProfession.Connection.Open()<br> ddlProfession.DataSource = objProfession.ExecuteReader<br> Catch ex As Exception<br> End Try<br> ddlProfession.DataBind()<br> objProfession.Connection.Close()<br> End Sub<br><br>thanks for reply~ ur kindly helping will be highly appreciated..
|