WebPagesRazor W3Schools
In MS VisualStudio 19
1) Create a new web site pick ASP.NET Empty Web Site
2) Add ASP.NET folder App_Data
3) Find the member.accdb in the unit on blackboard download it and and add it to App_data
4) Add a NewItem Web Page (Razor v3)
5) Add the connection string in the Web.config file.
<connectionStrings>
<add connectionString="Provider=Microsoft.ACE.OleDb.12.0;Data Source=|DataDirectory|member.accdb;" name="member" providerName="System.Data.OleDb">
</add></connectionStrings>
6) Go into: Tools > NuGet Package Manager > Package Manager Console
And run the following command:
PM> Install-Package Microsoft.AspNet.WebPages.Data
then open the command prompt.
cd \Program Files (x86)\IIS Express
Then type the following command:
appcmd set config /section:system.webServer/directoryBrowse /enabled:true
@using WebMatrix.Data;
@{
var db = Database.Open("member");
var selectQueryString = "SELECT * FROM memberTable ORDER BY LastName";
}
<html>
<body>
<h1>
Paleo Scriptology Club Members</h1>
<table border="1" style="width: 100%;">
<tr>
<th>Id</th>
<th>LastName</th>
<th>FirstName</th>
<th>PhoneNumber</th>
</tr>
@foreach (var row in db.Query(selectQueryString))
{
<tr>
<td>@row.StudentId</td>
<td>@row.LastName</td>
<td>@row.FirstName</td>
<td>@row.PhoneNumber</td>
</tr>
}
</table>
</body>
Paleo Scriptology Club Members
| Id | LastName | FirstName | PhoneNumber |
|---|---|---|---|
| @row.StudentId | @row.LastName | @row.FirstName | @row.PhoneNumber |
</html>
