1、添加app.config文件

 

 
  
  1. <?xml version="1.0" encoding="utf-8" ?> 
  2. <configuration> 
  3.     <connectionStrings> 
  4.         <add name="dbstrConn" connectionString="Data Source=127.0.0.1;Initial
  5.   Catalog=demo;User ID=sa;Password=abc123456"/> 
  6.     </connectionStrings> 
  7. </configuration> 

 2、引用system.configuration

 3、声明变量strconn

 
  
  1. string strconn = ConfigurationManager.ConnectionStrings["dbstrConn"].ConnectionString; 
  2.  using (SqlConnection conn = new SqlConnection(strconn))  
  3.             {    
  4.  
  5.             }