Chapter 12 & 13

martine · June 5th, 2016, 10:26 AM

While doing the first try it out session in chapter 13, (step 10 threw an error) I realised that I had inadvertently left the delete statement from step 10 in the last try it out session from chapter 12. I opened SQL Server, but could not locate the Planet Wrox DB. Help!
I logged in to SQL Management Studio as (localDB)\v11.0.

Imar · June 6th, 2016, 06:31 AM

Hi there,

I am not sure I understand the problem. Have you tried browsing for your database in the App_Data folder from within Visual Studio (using the Attach command)?

Imar

martine · June 6th, 2016, 08:35 AM

I can see the database in App_Data, but cannot connect to in in SQL Server.

Step 10 on page 445: When I bring up Genres.aspx in my browser I get this
-----------------
Server Error in '/' Application.

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

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The connection name 'PlanetWroxConnectionString1' was not found in the applications configuration or the connection string is empty.

Source Error:

Line 19: </Fields>
Line 20: </asp:DetailsView>
Line 21: <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:PlanetWroxConnectionString1 %>" DeleteCommand="DELETE FROM [Genre] WHERE [Id] = @Id" InsertCommand="INSERT INTO [Genre] ([Name], [SortOrder]) VALUES (@Name, @SortOrder)" ProviderName="<%$ ConnectionStrings:PlanetWroxConnectionString1.Prov iderName %>" SelectCommand="SELECT [Id], [Name], [SortOrder] FROM [Genre]" UpdateCommand="UPDATE [Genre] SET [Name] = @Name, [SortOrder] = @SortOrder WHERE [Id] = @Id">
Line 22: <DeleteParameters>
Line 23: <asp:Parameter Name="Id" Type="Int32" />
---------------------

martine · June 6th, 2016, 09:00 AM

Not to worry. I am having to stop & restart and probably missed a step. I will start the exercise again. It would still be good to know though, why I am unable to get to the database using SQL Server Management.

Imar · June 7th, 2016, 07:54 AM

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

This sounds like you changed the connection string in web.config (maybe you added a new one and removed the old one) without updating the control that has a reference to it. Check the name of the connection string in web.config and then search the site for PlanetWroxConnectionString1 and update the references to your current connection string.

>> It would still be good to know though, why I am unable to get to the database using SQL Server Management.

Hard to say without knowing more. Can you elaborate?

Imar