数据库连接函数并读取TXT文本中的数据

  #region  数据库连接函数
        public SqlConnection  getcon()
        {
            StreamReader sr = new StreamReader("config.txt");
            {
                string line = sr.ReadToEnd();
                string[] ss = new string[line.Length];
                ss = line.Split(';');
                String sqlconn = "server=" + ss[0].Substring(7).Trim() + ";database=" + ss[1].Substring(11).Trim() + ";user=" + ss[2].Substring(7).Trim() + ";pwd=" + ss[3].Substring(6).Trim() + "";
                ring sqlconn = @"server=(local);uid=sa;pwd=sasa;database=jhedb";
                SqlConnection conn = new SqlConnection();
                conn.ConnectionString = sqlconn;
                return conn;
            }
        }
        #endregion