在.NET中,推荐使用配置文件来存放数据库连接字符串,如Web.config或App.config。如下:
<
configuration
>
< appSettings >
< add key = " SqlServerName " value = " (local) " />
< add key = " SqlServerPort " value = " 1433 " />
< add key = " SqlServerUID " value = " sa " />
< add key = " SqlServerPWD " value = " sa " />
< add key = " SqlServerDBName " value = " DBName " />
</ appSettings >
</ configuration >
< appSettings >
< add key = " SqlServerName " value = " (local) " />
< add key = " SqlServerPort " value = " 1433 " />
< add key = " SqlServerUID " value = " sa " />
< add key = " SqlServerPWD " value = " sa " />
< add key = " SqlServerDBName " value = " DBName " />
</ appSettings >
</ configuration >
SqlServerName是数据库服务器的名子,(local)就是本地计算机的意思;SqlServerPort是数据库服务的端口号,SQLServer的默认端口号是1433;SqlServerUID是登陆数据库服务的用户名;SqlServerPWD是密码;SqlServerDBName是要访问的数据库。
在数据访问层,需要做一个“制造连接字符串”的方法,以方便使用,如下:
///
<summary>
/// 制作SQL连接字符串
/// </summary>
/// <returns> SQL连接字符串 </returns>
private string GetConnectionString()
{
return " Data Source= " + ConfigurationManager.AppSettings[ " SqlServerName " ] + " , " + ConfigurationManager.AppSettings[ " SqlServerPort " ] + " ; Initial Catalog = " + ConfigurationManager.AppSettings[ " SqlServerDBName " ] + " ; User ID = " + ConfigurationManager.AppSettings[ " SqlServerUID " ] + " ; Password = " + ConfigurationManager.AppSettings[ " SqlServerPWD " ];
}
/// 制作SQL连接字符串
/// </summary>
/// <returns> SQL连接字符串 </returns>
private string GetConnectionString()
{
return " Data Source= " + ConfigurationManager.AppSettings[ " SqlServerName " ] + " , " + ConfigurationManager.AppSettings[ " SqlServerPort " ] + " ; Initial Catalog = " + ConfigurationManager.AppSettings[ " SqlServerDBName " ] + " ; User ID = " + ConfigurationManager.AppSettings[ " SqlServerUID " ] + " ; Password = " + ConfigurationManager.AppSettings[ " SqlServerPWD " ];
}