Exemplo n.º 1
0
        //RB 20/02/2018 2018-R1 ABSEXCH-19790: Check SQL Posting Compatibility: Unhandled exception is occurred when running check for Single Daybook posting.
        private void SetSQLCommonConnectionString(ConnectionStringBuilder aConnStrBuilderObj)
        {
            // Rebuild Connection String
            string[] ConSplit = Regex.Split(SQLCommonConnectionString, ";");
            ExchequerCommonSQLConnection = "";
            foreach (string CSplit in ConSplit)
            {
                if (CSplit.StartsWith("Data Source"))
                {
                    ExchequerCommonSQLConnection = ExchequerCommonSQLConnection + "Data Source=" + CSplit.Substring(12, (CSplit.Length - 12)) + ";";
                }
                else if (CSplit.StartsWith("Initial Catalog"))
                {
                    ExchequerCommonSQLConnection = ExchequerCommonSQLConnection + "Initial Catalog= " + CSplit.Substring(16, (CSplit.Length - 16)) + ";";
                }
                else if (CSplit.StartsWith("User Id"))
                {
                    ExchequerCommonSQLConnection = ExchequerCommonSQLConnection + "User Id=" + CSplit.Substring(8, (CSplit.Length - 8)) + ";";
                }
                else if (CSplit.StartsWith("Password") && aConnStrBuilderObj.DecryptedPassword == "")
                {
                    ExchequerCommonSQLConnection = ExchequerCommonSQLConnection + "Password= "******";";
                }
            }
            ExchequerCommonSQLConnection = ExchequerCommonSQLConnection + "Provider=SQLOLEDB.1";

            if (aConnStrBuilderObj.DecryptedPassword != "")
            {
                connPassword = aConnStrBuilderObj.DecryptedPassword;
            }
        }
Exemplo n.º 2
0
        private void btn_Load_Click(object sender, EventArgs e)
        {
            OpenFileDialog OFD = new OpenFileDialog();

            OFD.Filter      = "All Files (*.*)|*.*";
            OFD.Multiselect = true;
            bool b_filePath = true;

            if (OFD.ShowDialog() == DialogResult.OK)
            {
                for (int i = 0; i < OFD.FileNames.Length; i++)
                {
                    if (b_filePath == true)
                    {
                        m_filePath = CSplit.FilenameSplit(OFD.FileNames[i], false); b_filePath = false;
                    }
                    lb_Picture.Items.Add(CSplit.FilenameSplit(OFD.FileNames[i]));
                    Console.WriteLine(CSplit.FilenameSplit(OFD.FileNames[i]));
                }
            }
        }