C#连接数据库怎么将App.config连接改为用sqlconnection连接

Question

这是App.config

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
    </startup>
  <connectionStrings>
    <add name="sqlserver" connectionString="Server=127.0.0.1;Initial Catalog=Hotel;User ID=sa;Password=1234" providerName="System.Data.SqlClient" />
  </connectionStrings>
</configuration>

怎么改成下面这种

string connstring = "Server=.; user Id = sa; Pwd = 1234; DataBase = Library";//Data Source =172.20.10.5;Initial Catalog = Library;User ID= sa;Pwd=1234
            SqlConnection conn = new SqlConnection(connstring);
            string sql = String.Format("select count(*) from [Manager] where managerid='{0}' and managerPassword='{1}' and mIdentity='{2}'", username, passworld,midentity );

Answer 1

App.config只是用来存储写好的sql字符串，方便项目所有的连接字符串统一管理，一般这样用
string connstring = ConfigurationManager.ConnectionStrings["sqlserver"].ConnectionString;（取出App.config的connectionStrings里name为sqlserver的ConnectionString字符串）