调用连接字符串

配置文件中:

 

 <connectionStrings>
    <add name="SQLCONNECTIONSTRING" connectionString="server=JIZHENGK-FA7C05;uid=sa;pwd=;database=pubs" providerName="System.Data.SqlClient"/>

  </connectionStrings>

 

 

 

前台页面:  

 

 

引入命名空间:

using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;

 

在这里调用:

 

 public void testconn()
    {
        string connstr = ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ToString();
        SqlConnection myconn = new SqlConnection(connstr);
        try
        {
            myconn.Open();
            if (myconn.State == ConnectionState.Open)
            {
                Response.Write("open");
            }
            else
            {
                Response.Write("close");
            }
        }
        catch (SqlException ex)
        {
            throw new Exception(ex.Message, ex);

        }
        finally
        {
            myconn.Close();
        }
    }