Chapter 12: Creating Tables in the Table Designer

phztfte1 · November 26th, 2015, 09:09 PM

I opened the SSMS and logged in to the LocalDB SQL Server; but, the Solution Explorer in which SSMS launched was empty. It did not appear in the Chapter 12 website.

How do I connect it with the Chapter 12 website. I had Chapter 12 opened, but SSMS did not connect with it.

Imar · November 27th, 2015, 05:14 AM

Hi there,

In SSMS you need the Object Explorer, not the Solution Explorer (which indeed will be empty).

I don't understand what you mean with:

>> It did not appear in the Chapter 12 website. How do I connect it with the Chapter 12 website. I had Chapter 12 opened, but SSMS did not connect with it.

Can you elaborate?

Cheers,

Imar

phztfte1 · November 27th, 2015, 12:00 PM

I downloaded the code for Beginning ASP.NET 4.5.1: in C# and VB and have been using the code since Chapter 9. When I did the Creating the SQL Server Sample Database Try It Out, the Object Explorer opened with the Solution Explorer in Chapter 12.

Therefore, I thought that the databases created would go to the Databases folder that was created at the beginning of the Try it out.

Similarly, when the paths C:\BegASPNET\Site\App_Data were entered in SSMS, I thought the databases would be located in C:\BegASPNET\Site\App_Data for Chapter 12.

Imar · November 27th, 2015, 01:09 PM

I still don't understand what you're saying. Is the issue resolved now?

Imar

phztfte1 · November 27th, 2015, 02:47 PM

It does not work. I get the same error message as my other post except this time it is for "PlanetWrox" instead of "PlanetWroxTemp".

The way I have the folders set up is "C:\BegASPNET\Source\Chapter12

Imar · November 27th, 2015, 03:43 PM

>> The way I have the folders set up is "C:\BegASPNET\Source\Chapter12

What does that mean? Is that where you build your site? This is where the source that comes with the book is located so this will likely lead to conflicts. The book has you use C:\BegASPNET\Site instead.

Cheers,

Imar

phztfte1 · November 27th, 2015, 04:54 PM

Actually, I stored the code as follows "OneDrive\BegASPNET". Inside BegASPNET, I put the Release, Resource, and Source folders. I thought by doing this I would be able to work on the exercises using my Surface Pro 3 when I was not at my desk.

Since Chapter 9, I would use BegASPNET as my initial website but would click on the chapter folder that I was working on. The chapter contents would become my new website. Most of the time I did not have to type in the bold faced code since it was already there.

Imar · November 27th, 2015, 05:02 PM

You're not very specific about what you do so I can only guess; "but would click on the chapter folder that I was working on." is quite meaningless and doesn't tell me much.

As explained in the introduction of the book, you can't open C:\BegASPNET\Source and then browse to the chapter folders separately; especially the later chapters need to be in the root of the site, while this setup would lead to something like C:\localhost:12345/Chapter12/SomePage.aspx which will cause all kinds of issues. In general you should the Source folder as a reference and build your own site (and optionally copy files in from the Source folder).

Using OneDrive might work, but no guarantees. It should work OK for plain text files but you'll run into issues with SQL Server databases as you'll get file locks.

Cheers,

Imar

phztfte1 · November 27th, 2015, 05:39 PM

Thank you very much.