Hi

I seem to be getting an error when trying to run the below code: -

     Function CustomersEdit() As System.Data.DataSet
       Dim connectionString As String = _
              ConfigurationSettings.AppSettings("ConnectionStrin g")
       Dim dbConnection As System.Data.IDbConnection = _
              New System.Data.OleDb.OleDbConnection(connectionString )

       Dim queryString As String = "SELECT [Customers].[CustomerName], [Customers].[Address1], [Customers].[SiteLogin],"& _
     "[Customers].[SitePassword], [Customers].[CustomerID] FROM [Customers]"
       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 line that displays the error is the one in bold, of which it is advising "The ConnectionString property has not been initialized."

Can anyone offer any suggestions?

Thanks
Sharon

I have also set up the key for my web.config called ConnectionString so this can't be the problem.

Thanks

Sharon

HelpWanted:
According to the error message, the objAdapter is not finding the database referenced in your web.config. It is the Fill() method of the Adapter object that creates and/or populates the DataTable in the objDataSet. As you stated in your topic you have the web.config "ConnectionString" setup correctly, then make sure your web.config is in the correct place, like the web root directory.

As a suggestion: 1) use the import namespace directive. In your case
<%@ Import namespace="System.Data" %>
<%@ Import namespace="System.Data.Oledb" %> Cuts down on the typing in your statements.

Hope this helps.

HelpWanted:
This same error has been addressed in the following topic:

http://p2p.wrox.com/topic.asp?TOPIC_ID=27910

Hope this helps.