<%@ Page Language="C#" %>
<%@ import Namespace="System.Data.SqlClient" %>
void cmdConnect_OnClick(Object sender, EventArgs e)
{
String connectString = ConnectionsList.SelectedItem.Text;
SqlConnection sqlConn = null;
try
{
sqlConn = new SqlConnection(connectString);
sqlConn.Open();
lblConnectInfo.Text = "Connection successful!";
}
catch
{
lblConnectInfo.Text = "Connection failed!";
}
finally
{
if (sqlConn != null)
sqlConn.Close();
}
}
Default
Note: None of these actually work for this demo.
User ID=user;Password=pass;Initial Catalog=Northwind;Data Source=(local)
Integrated Security=yes;Initial Catalog=Northwind;Data Source=(local)