Parse the database connection string (extract data Source, Initial Catalog, User ID, password)

private void Analysisconnectionstring () {String tempstr = "Data source=192.168.2.123;initial catalog=ca Xastat; 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 }            }}

　　

Parse the database connection string (extract data Source, Initial Catalog, User ID, password)