动软里面 public class PubConstant
{
/// <summary>
/// 获取连接字符串
/// </summary>
public static string ConnectionString
{
get
{
string _connectionString = ConfigurationManager.AppSettings["ConnectionString"];
string ConStringEncrypt = ConfigurationManager.AppSettings["ConStringEncrypt"];
if (ConStringEncrypt == "true")
{
_connectionString = DESEncrypt.Decrypt(_connectionString);
}
return _connectionString;
}
} /// <summary>
/// 得到web.config里配置项的数据库连接字符串。
/// </summary>
/// <param name="configName"></param>
/// <returns></returns>
public static string GetConnectionString(string configName)
{
string connectionString = ConfigurationManager.AppSettings[configName];
string ConStringEncrypt = ConfigurationManager.AppSettings["ConStringEncrypt"];
if (ConStringEncrypt == "true")
{
connectionString = DESEncrypt.Decrypt(connectionString);
}
return connectionString;
}
}
然后我用
PubConstant.GetConnectionString("workstation id=localhost;Integrated Security=SSPI;database=zbroad2009");
MessageBox.Show(PubConstant.ConnectionString);
结果发现.ConnectionString 是NULL
是空的
这个Connectionstring 如何赋值呢
{
/// <summary>
/// 获取连接字符串
/// </summary>
public static string ConnectionString
{
get
{
string _connectionString = ConfigurationManager.AppSettings["ConnectionString"];
string ConStringEncrypt = ConfigurationManager.AppSettings["ConStringEncrypt"];
if (ConStringEncrypt == "true")
{
_connectionString = DESEncrypt.Decrypt(_connectionString);
}
return _connectionString;
}
} /// <summary>
/// 得到web.config里配置项的数据库连接字符串。
/// </summary>
/// <param name="configName"></param>
/// <returns></returns>
public static string GetConnectionString(string configName)
{
string connectionString = ConfigurationManager.AppSettings[configName];
string ConStringEncrypt = ConfigurationManager.AppSettings["ConStringEncrypt"];
if (ConStringEncrypt == "true")
{
connectionString = DESEncrypt.Decrypt(connectionString);
}
return connectionString;
}
}
然后我用
PubConstant.GetConnectionString("workstation id=localhost;Integrated Security=SSPI;database=zbroad2009");
MessageBox.Show(PubConstant.ConnectionString);
结果发现.ConnectionString 是NULL
是空的
这个Connectionstring 如何赋值呢
web.config怎么配置的
string ConStringEncrypt = ConfigurationManager.AppSettings["ConStringEncrypt"];
if (ConStringEncrypt == "true")
{
connectionString = DESEncrypt.Decrypt(connectionString);
}的作用,感觉可以去掉嘛。
参数是configName
不是configValue
string ConStringEncrypt = ConfigurationManager.AppSettings["ConStringEncrypt"];
是不是要ToString一下。
没错,项目中应该还有个web.config或者是app.config吧,找到这两个文件,找到有workstation id=localhost;Integrated Security=SSPI;database=zbroad2009这个的那个节点,复制节点名字替换上面这句