Asp.net Webpage Database connection

Question

@{ var db = Database.Open(SmallBakery); var selectQueryString = SELECT * FROM Product ORDER BY Name; } Small Bakery Products Id Product Description Price @foreach(var row in db.Query(selectQueryString)) { @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?

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.