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

Tangara G

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:

"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" />
"ConnTest" connectionString="Data Source=localhost;Initial Catalog=test;Integrated Security=True;" providerName="System.Data.SqlClient" />

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

Tks.

2 Replies

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

Amit Kumar9y ago
Accepted 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 Fernandes9y ago
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.