using System;
using System
.Collections
.Generic;
using System
.Linq;
using System
.Text;
using System
.Data;
using System
.Data
.SqlClient;
using Models;
using System
.Configuration;
using System
.Xml;
namespace DAL
{
public class DBConfig
{
/// <summary>
/// 禁止实例化
/// </summary>
private DBConfig() { }
public static List<Databases> GetDatabaseName(string connStr)
{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("select name from sys
.databases where name like '%Training%'", conn);
List<Databases> list = new List<Databases>();
try
{
conn
.Open();
SqlDataReader reader = cmd
.ExecuteReader();
while (reader
.Read())
{
list
.Add(new Databases() { DatabaseName=reader[0]
.ToString() });
}
return list;
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn
.Close();
}
}
/// 获取
ConnectionStrings
public static string Get
ConnectionStringsConfig(string connectionName)
{
string
connectionString =
ConfigurationManager.ConnectionStrings[connectionName]
.ConnectionString;
return
connectionString;
}
///
/// 更新连接字符串
public static void Update
ConnectionStringsConfig(string key, string conString)
{
bool isModified = false; //记录该连接串是否已经存在
if (
ConfigurationManager.ConnectionStrings[key] != null)
{
isModified = true;
}
//新建一个连接字符串实例
ConnectionStringSettings mySettings = new
ConnectionStringSettings(key, conString);
// 打开可执行的
配置文件*
.exe
.config
Configuration config =
ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel
.None);
// 如果连接串已存在，首先删除它
if (isModified)
{
config
.ConnectionStrings
.ConnectionStrings
.Remove(key);
}
// 将新的连接串添加到
配置文件中
.
config
.ConnectionStrings
.ConnectionStrings
.Add(mySettings);
// 保存对
配置文件所作的更改
config
.Save(ConfigurationSaveMode
.Modified);
// 强制重新载入
配置文件的
ConnectionStrings
配置节
ConfigurationManager.RefreshSection("
connectionStrings");
}
/// <summary>
/// 修改
AppSettings中
配置
/// </summary>
/// <param name="key">key值</param>
/// <param name="value">相应值</param>
public static bool SetConfigValue(string key, string value)
{
try
{
Configuration config =
ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel
.None);
if (config
.AppSettings.Settings[key] != null)
config
.AppSettings.Settings[key]
.Value = value;
else
config
.AppSettings.Settings
.Add(key, value);
config
.Save(ConfigurationSaveMode
.Modified);
ConfigurationManager.RefreshSection("
appSettings");
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 获取
AppSettings中某一节点值
/// </summary>
/// <param name="key"></param>
public static string GetConfigValue(string key)
{
Configuration config =
ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel
.None);
if (config
.AppSettings.Settings[key] != null)
return config
.AppSettings.Settings[key]
.Value;
else
return string
.Empty;
}
/// <summary>
/// 测试连接
数据库是否成功
/// </summary>
/// <returns></returns>
public static bool ConnectionTest(string
ConnectionString)
{
//创建连接对象
SqlConnection mySqlConnection = new SqlConnection(
ConnectionString);
bool IsConnectionInfo = true;
//ConnectionTimeout 在
.net 1
.x 可以设置 在
.net 2
.0后是只读属性，则需要在连接字符串设置
//如：server=
.;uid=sa;pwd=;database=PMIS;Integrated Security=SSPI; Connection Timeout=30
//mySqlConnection
.ConnectionTimeout = 1;//设置连接超时的时间
try
{
//Open DataBase
//打开
数据库
mySqlConnection
.Open();
IsConnectionInfo = true;
}
catch
{
//Can not Open DataBase
//打开不成功 则连接不成功
IsConnectionInfo = false;
}
finally
{
//Close DataBase
//关闭
数据库连接
mySqlConnection
.Close();
}
//mySqlConnection is a SqlConnection object
if (mySqlConnection
.State == ConnectionState
.Closed || mySqlConnection
.State == ConnectionState
.Broken)
{
//Connection is not available
return IsConnectionInfo;
}
else
{
//Connection is available
return IsConnectionInfo;
}
}
}
}
本文介绍了两种在web.config或app.config文件中设置数据库连接字符串的方法：通过connectionStrings元素直接配置连接信息和利用appSettings进行间接设置。此外，还提供了如何在C#代码中读取这些连接字符串的具体示例。
扫一扫
5648
到【灌水乐园】发言
