Example #1
0
        // DB Reader Class
        private void ReadSingleRow(IDataRecord dataRecord)
        {
            try
            {
                Console.WriteLine(String.Format("{0}, {1}, {2}", dataRecord[0], dataRecord[1], dataRecord[2]));

                dbUserName = dataRecord[0].ToString();
                dbPassword = dataRecord[1].ToString();
                allow      = dataRecord[2].ToString();

                if (dbUserName == userName && dbPassword == password && allow == "Y")
                {
                    BSFX bsfx = new BSFX();
                    connect.Close();
                    this.Hide();
                    File.AppendAllText(logLoc, Environment.NewLine + Environment.NewLine + time + ":" + " Login complete! Initializing main window..." + Environment.NewLine);
                    bsfx.Show();
                }
                else
                {
                    Console.WriteLine("ERROR OCCURED WHEN COMPARING USER NAMES AND PASSWORDS");
                }
            }
            catch (Exception readErr)
            {
                Console.WriteLine(readErr);
            }
        }