C#从SQLServer连接字符串获取SQLServer服务器信息

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;

}