Ejemplo n.º 1
0
        private SqlConnection Connect(string DataBase)
        {
            INIAdapter    iniAdt = new INIAdapter(Application.StartupPath + "\\sjsys.ini");
            SqlConnection conn;

            if (!iniAdt.Exists())
            {
                throw (iniAdt.INIException);
            }
            else
            {
                string DataSource, InitialCatalog, UserID, Password;
                DataSource     = iniAdt.ReadValue(DataBase, "DataSource");
                InitialCatalog = iniAdt.ReadValue(DataBase, "InitialCatalog");
                UserID         = iniAdt.ReadValue(DataBase, "UserID");
                Password       = iniAdt.ReadValue(DataBase, "Password");

                StringEncrypt.DecodeString(Password, out Password);

                conn = new SqlConnection();
                conn.ConnectionString = @"Data Source=" + DataSource + ";Initial Catalog=" + InitialCatalog + ";User ID=" + UserID + ";Password=" + Password;
            }
            return(conn);
        }