Having Probelms With ASP Web Page

Hello Programmers Heaven Member,

I developed this web page using web matrix some three months ago, since then I have been unable to retrieve data from my database. Can someone look at the lines of code below I tell me where I went wrong.

Function GetBusinessDataSet() As System.Data.DataSet
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=cacoweda.mdb;"

Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString)

Dim queryString As String = "SELECT [Business].[BusinessName], [Business].[ContactName], [B"& _
"usiness].[Description], [Business].[Address], [Business].[City], [Business].[PostCode]"& _
", [Business].[Phone], [Business].[Mobile], [Business].[E-mail], [Busi"& _
"ness].[WebSiteAddress] FROM [Business] WHERE ([Business].[BusinessName] = [Business"& _
Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection

Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter
dataAdapter.SelectCommand = dbCommand
Dim dataSet As System.Data.DataSet = New System.Data.DataSet

Return dataSet

End Function

The Full URL of my site is http://www.cacoweda.org.uk/search.aspx

Thanking you all for your assistance.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!