Asp.net Webpage Database connection

Question

@{
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?

Francis · Answer

You should maintain the connnection string in the web.config as normal practice in ASP.Net. I guess, you didn't provide the connection string in a proper format. Check my blog post for the tutorial to construct the connection string : http://www.aspdotnetchamp.com/2014/12/an-easy-way-to-construct-connection.html Also, your connection string might look like below in web.Config: providerName="System.Data.SqlClient" /> You should retrieve the connection string as follows in your C# code: string conString = string.Empty; ConnectionStringSettings mySetting = ConfigurationManager.ConnectionStrings[" MyDBConnectionString "]; if (mySetting == null || string.IsNullOrEmpty(mySetting.ConnectionString)) throw new Exception("Fatal error: missing connecting string in web.config file"); conString = mySetting.ConnectionString; Hope this helps!

Manas Mohapatra · Answer

Do project search " SmallBakery " and see where it being used. I hope you will find in web.config file. Just cross check the connection string to which database it is pointing.

Asp.net Webpage Database connection

Mahesh Chand