Asp.net Webpage Database connection

Sadaqat Jeelani

10y1.7k.NET

@{
var db = Database.Open("SmallBakery");
var selectQueryString = "SELECT * FROM Product ORDER BY Name";
}

Small Bakery Products

@foreach(var row in db.Query(selectQueryString))
{

}

Id	Product	Description	Price
@row.Id	@row.Name	@row.Description	@row.Price

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?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Francis Susaimichael10y ago
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!
0
Manas Mohapatra10y ago
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.
0