<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
void Page_Load()
{
// string strConnection = "user id=sa;password=;";
// strConnection += "initial catalog=northwind;data source=EWANB;";
//strConnection += "Connect Timeout=30";
string strConnection = "Data Source=whsql-v08.prod.mesa1.secureserver.net;Initial Catalog=DB_49907;User ID=rntsoftuser;Password='password';";
data_src.Text = strConnection;
SqlConnection objConnection = new SqlConnection(strConnection);
try
{
objConnection.Open();
con_open.Text="Connection opened successfully.
objConnection.Close();
con_close.Text="Connection closed.
}
catch (Exception e)
{
con_open.Text="Connection failed to open.
con_close.Text=e.ToString();
}
}
Testing the data connection