how do i test if my connection in my web config is correct ?

Question

Hi expert,

I am now doing a test using my home PC cos I am so used to doing things via entity framework I really forgot how to write the connection string inside my web.config.

My database name is test.

And here's how I do it inside my web.config:

<connectionStrings>
<add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\aspnet-WebApplication9-20170128051949.mdf;Initial Catalog=aspnet-WebApplication9-20170128051949;Integrated Security=True"
providerName="System.Data.SqlClient" />
<add name="ConnTest" connectionString="Data Source=localhost;Initial Catalog=test;Integrated Security=True;" providerName="System.Data.SqlClient" />
</connectionStrings>

Hope someone can tell me if it is correct or how can I ascertain that it is connected ?

Tks.

Amit Kumar · Answer

Hi Dear, You can test your web confg. connection is correct or not like.. Suppose it your web.cofig After that: The codebehind for the page is simply this: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Configuration; using System.Data.SqlClient; using System.Data; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void btnTestDb_Click(object sender, EventArgs e) {try { SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["EarthConn"].ConnectionString); connection.Open(); if ((connection.State & ConnectionState.Open) > 0) { Response.Write("Connection OK!"); connection.Close(); } else { Response.Write("No Connection!"); } }catch { Response.Write("No Connection!"); } } When you load the page, click the “Test Database” button, and you will see the appropriate response, "Connection OK!" or "No Connection!", written to the page.

Nigel Fernandes · Answer

Read my article, on connecting to database from visual studio. http://www.c-sharpcorner.com/article/connect-to-a-database-from-visual-studio/ Fill your credentials in that and click test connection.

how do i test if my connection in my web config is correct ?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)