Tech
Forums
Jobs
Books
Events
Live
Interviews Prep
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
Database Connection in Asp.net using Razor
Sadaqat Jeelani
Dec 14 2015 2:31 AM
622
Reply
Hi!
Here is My code i'm on entry level facing problem working on database in asp.net razor
@{
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>
When i run this code it's showing me an exception and that exception is (SqlException unhandle by user) please help me
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Embed Google map in ASP.Net without iframe
Encrypt a url in mvc 4