public static class DatabaseManager
{
public static SqlConnection GetConnection()
{
return GetConnection("DefaultConnection");
}
public static SqlConnection GetConnection(string name)
{
string conn = ConfigurationManager.ConnectionStrings[name].ConnectionString.ToString();
SqlConnection cn;
cn = new SqlConnection(conn);
cn.Open();
return cn;
}
}
Usage;
SqlConnection con = DatabaseManager.GetConnection();