62,074
社区成员
发帖
与我相关
我的任务
分享
string strCnn="Data Source=.;Initial Catalog=DianJiCS;Persist Security Info=True;User ID=sa;Password=sa";
string[] strs;
strs = strCnn.Split(';');
string path = "";//数据库备份路径
string dataBaseName = "";//数据库名称
string hostName = "";//当前连接的SqlServer服务器名称
string userID = "";//SQLServer连接用户名
string password = "";//SQLServer连接密码
#region 获取
foreach (string str in strs)
{
if (str.Contains("Data Source") || str.Contains("Server"))//SQLServer服务器名称
{
hostName = str.Substring(str.IndexOf("=") + 1);
}
else
{
if (str.Contains("Initial Catalog") || str.Contains("Database"))
{
dataBaseName = str.Substring(str.IndexOf("=") + 1);
}
else
{
if (str.Contains("User ID") || str.Contains("UID"))
{
userID = str.Substring(str.IndexOf("=") + 1);
}
else
{
if (str.Contains("Password") || str.Contains("PWD"))
{
password = str.Substring(str.IndexOf("=") + 1);
}
}
}
}
}
#endregion
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
string DataSource = connection.DataSource;
string Database = connection.Database;
}