解析数据库连接字符串 （将Data Source、Initial Catalog、User ID、Password取出）

解析数据库连接字符串 （将Data Source、Initial Catalog、User ID、Password取出）

  
private void AnalysisConnectionstring()
        {
            string tempStr = “Data Source=192.168.2.123;Initial Catalog=caxastat;Persist Security Info=True;User ID=sa;Password=sa;Pooling=true;
                       Max Pool Size=40000;Connect Timeout=30”;
            string[] paras = tempStr.Split(';');
            foreach (string para in paras)
            {
                switch (para.Split('=')[0])
                {
                    case "Data Source":
                        ServerName = para.Split('=')[1].Trim();
                        break;
                    case "Initial Catalog":
                        DataBase = para.Split('=')[1].Trim();
                        break;
                    case "User ID":
                        User = para.Split('=')[1].Trim();
                        break;
                    case "Password":
                        PassWord = para.Split('=')[1].Trim();
                        break;
                }
            }
}

　　

posted on 2016-07-13 17:18 坐在海边看星星 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/zemax/p/5667643.html