【求助】 connectionString 是拼接的，该如何使用

[jlz_tt]

<connectionStrings>
<add name="ModelContainer" connectionString="Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3};" providerName="SqlServer"/>
</connectionStrings>
<appSettings>
<add key="DataSource" value="."/>
<add key="InitialCatalog" value="test" />
<add key="UserName" value="sa"/>
<add key="PassWord" value="aa"/>
</appSettings>

WinFrom程序 我想使用这样的 方便设置连接字符串。可是如何在SqlHelper中去调用呢
connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ModelContainer"].ToString();

这样做的貌似 还是参数啊。

[EdsionWang]

这样怎么就方便了？

 <connectionStrings>
    <add name="ModelContainer" connectionString="Data Source=local;Initial Catalog=dbname;Persist Security Info=True;User ID=userid;Password=pwd;" providerName="SqlServer"/>
  </connectionStrings>

connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ModelContainer"].ToString(); 

就这样就完了

[jlz_tt]

感觉这样会方便点呀

[jlz_tt]

        public static string DataSource = System.Configuration.ConfigurationManager.AppSettings["DataSource"].ToString();
        public static string InitialCatalog = System.Configuration.ConfigurationManager.AppSettings["InitialCatalog"].ToString();
        public static string UserName = System.Configuration.ConfigurationManager.AppSettings["UserName"].ToString();
        public static string PassWord = System.Configuration.ConfigurationManager.AppSettings["PassWord"].ToString();
        //需要拼接字符串的数据源
        public static string ModelContainer = System.Configuration.ConfigurationManager.ConnectionStrings["ModelContainer"].ToString();
        //获取拼接后的正常的sql连接字符串
        public static string connectionString = String.Format(ModelContainer, DataSource, InitialCatalog, UserName, PassWord); 

这样就可以了。自己陷入了思维误区，总以为有方法可以搞定这个。结贴