On the Journey to be a SQL Server Professional: 6/15/14

Microsoft Data Development Technologies: Past, Present, and Future

Server Error in '/' Application. The resource cannot be found. Description: HTTP 404 - Used a wrong aspx name

Problem:

Today, I replay the code on this page:

It works fine. Then I create a VB Web project to test it with Visual Studio 2012.

But, when I debug the aspx file, I get the error message as below:

Server Error in '/' Application. The resource cannot be found. Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Reason:

The sample code uses demo_classicasp.aspx for the aspx page. I used WebForm1.aspx in the project.

Solution:

Change demo_classicasp.aspx to WebForm1.aspx in the code.

Issues with the project "Creating a Movie Database Application in 15 minutes with ASP.NET MVC"

I first found this web article and tried to duplicate the project with Visual Studio Ultimate 2012

However, I have encountered several issues in the process:

1. The original project was created in VS 2008, so the create/save table part is slightly different in VS 2012.

2. If it complains "using MovieEntityApp.Models", then remember that MovieEntityApp should be the project name

3. It then complains the MovieSet part, I found this thread.

So I downloaded the source code. But it cannot be upgraded to VS 2012.

Then I tried to upgrade it to VS 2010. Open the solution in VS 2010. It works great!

4. I also watched the original video by Stephen Walther, and follow the instructions to duplicate the exercise. Yes, I had to download MVC for Visual Studio 2008.

It was amazing that Visual Studio 2008 automatically fills up the code in MoviesDBModel.Designer.cs. It works perfectly in Visual Studio 2008.

How to link to a SQL Server database from an ASP.NET webpage?

Step 1. Create the SQL Server database and the table. Please note the database file does not have to be in the App_Data folder of the ASP.NET Project folder (But for the compact edition database in WebMatrix, the sdf file needs to be in this folder). It can be in the normal data folder for SQL Server, such as:

D:\Program Files\Microsoft SQL Server\MSSQL10_50.R2\MSSQL\DATA

Step 2. In VS, configure the connection string in the web.config file as below:

</connectionStrings>

<system.web>

</compilation>

</system.web>

</configuration>

Step 3. In VS, in the cshtml file, use Database.Open('myconnectionstringname') to open the database:

//var db = Database.Open("SmallBakery"); use this option if using compact edition in WebMatrix

var db = Database.Open("myconnectionstring"); //defined in the web.confog file

var query = "SELECT * FROM Product";

}

<html>

<body>

<h1>Small Bakery Products</h1>

<tr>

<th>Product</th>

<th>Description</th>

<th>Price</th>

</tr>

@foreach (var row in db.Query(query))

{

<tr>

<td>@row.Description</td>

<td align="right">@row.Price</td>

</tr>

}

</table>

</body>

</html>

Step 4. In VS, no need to manually "Add Connection" in Data Connections. When you run the code, VS will automatically create one "myconnectionstring (WebSite1(1))", defaulted to closed. Webite1(1) is the name for the WebSite.

Step 5. Also notice, there is no database file in the C:\Users\Charlie\Documents\Visual Studio 2012\WebSites\WebSite1\App_Data folder,neither in the App_Data folder in VS (The two should represent the same information).

Step 6. If you face error message on LINQ in the temporary ASP.NET files, delete these temp cs files in the corresponding Net Framework folder.

Step 7. Press Ctr+A to select the cshtml code, then press Ctrl+Shift+W to process it. Enjoy the cakes!