Chap 3 pg 133: The connection name 'AppConnectionString1' was not found in the ap

tomche · October 10th, 2009, 09:26 AM

Hello All,

I just got the following error whilst doing the example on pg 133

The connection name 'AppConnectionString1' was not found in the applications configuration or the connection string is empty.

The information I have suggests that some code should be entered into the web.config file but instinct says that it is not referencing the Northwind database.

Any help would be excellent.

Cheers

Thomas

irProject · December 1st, 2009, 04:48 AM

you can define your own ConnectionString. for example you can define a class to present your general variables:

Code:

public class MyVariables
{
  public const string ConnectionString = "Data Source=<your server>; Initial Catalog=<your database name>";
}

and then use:

Code:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
SelectCommand="SELECT [CompanyName] FROM [Customers]"
ConnectionString="<%=MyVariables.ConnectionString %>">
</asp:SqlDataSource>