Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Adding a Customers Page
- In the "DemoWebPages" folder, create a new CSHTML file named "Products.cshtml".
- Replace the code in the file with the code from the example below:
- Products.cshtml
- @{
- var db = Database.Open("SmallBakery");
- var selectQueryString = "SELECT * FROM Product ORDER BY Name";
- }
- <html>
- <body>
- <h1>Small Bakery Products</h1>
- <table>
- <tr>
- <th>Id</th>
- <th>Product</th>
- <th>Description</th>
- <th>Price</th>
- </tr>
- @foreach(var row in db.Query(selectQueryString))
- {
- <tr>
- <td>@row.Id</td>
- <td>@row.Name</td>
- <td>@row.Description</td>
- <td align="right">@row.Price</td>
- </tr>
- }
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement