Пример #1
0
        private void btnLogin_Click(object sender, EventArgs e)
        {
            MSLoginDatabase database = new MSLoginDatabase();

            string m_loginid  = IdNumberTextBox.Text;
            string m_password = PasswordTextBox.Text;

            DataTable dataTable = new DataTable();

            MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter();

            MySqlCommand mySqlCommand = new MySqlCommand("SELECT * FROM `manager` WHERE `m_loginid` = @usn and `m_password` = @pass ", database.getConnection());


            mySqlCommand.Parameters.Add("@usn", MySqlDbType.VarChar).Value  = m_loginid;
            mySqlCommand.Parameters.Add("@pass", MySqlDbType.VarChar).Value = m_password;

            mySqlDataAdapter.SelectCommand = mySqlCommand;

            mySqlDataAdapter.Fill(dataTable);

            if (dataTable.Rows.Count > 0)
            {
                ManagerMenu managerMenu = new ManagerMenu();
                managerMenu.Show();
            }
            else
            {
                MessageBox.Show("Incorrect Login ID and Password, Please try again!");
            }
        }
Пример #2
0
        private void btnLogin_Click(object sender, EventArgs e)
        {
            MSLoginDatabase database = new MSLoginDatabase();

            String s_loginid  = IdNumberTextBox.Text;
            String s_password = PasswordTextBox.Text;

            DataTable table = new DataTable();

            MySqlDataAdapter adapter = new MySqlDataAdapter();

            MySqlCommand Command = new MySqlCommand("SELECT * FROM `nurse` WHERE `s_loginid` = @usn and `s_password` = @pass ", database.getConnection());

            Command.Parameters.Add("@usn", MySqlDbType.VarChar).Value  = s_loginid;
            Command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = s_password;

            adapter.SelectCommand = Command;

            adapter.Fill(table);

            if (table.Rows.Count > 0)
            {
                passingtext = IdNumberTextBox.Text;
                this.Close();
                NurseMenu nurseMenu = new NurseMenu();
                nurseMenu.Show();
            }
            else
            {
                if (s_loginid.Trim().Equals(""))
                {
                    MessageBox.Show("Enter Your Username To Login", "Empty Username", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else if (s_password.Trim().Equals(""))
                {
                    MessageBox.Show("Enter Your Password To Login", "Empty Password", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    MessageBox.Show("Wrong Username Or Password", "Wrong Data", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }