TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Sadaqat Jeelani
NA
20
15k
Asp.net Webpage Database connection
Jan 11 2016 4:16 AM
@{
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>
Here is my code i tried many time but con't connect i shows (
An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code
Additional information: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL
)
some one told me do some changes in web.config file but i don't know which type of changes are that?
Reply
Answers (
2
)
Object reference not set to an instance of an object.
How to auto logout after 1hr of inactivity