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"& _
"].[BusinessName])"
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
dataAdapter.Fill(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.
Rosie
elegantrosemary@yahoo.co.uk

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!

Categories