C#

this.DialogResult = DialogResult.None;

gamer1127 wrote:

private void txtBoxLogIn_TextChanged(object sender, EventArgs e)
{
txtBoxLogIn.KeyPress += new KeyPressEventHandler(txtBoxLogIn_KeyPress);
}

gamer1127 wrote:

I'll be using only one eventhandler in transferring focus to other controls.

Jimmanuel wrote:

Why? Have you tried separate handlers for each control?

txtBoxLogIn.Tag = txtBoxPassword; // give focus to the password box
txtBoxPassword.Tag = btnProceedLogIn; // give focus to the button
btnProceedLogIn.Tag = null; // set this to null to signify the end of the chain

private void focusForwardingControl_KeyDown(object sender, KeyEventArgs e)
{
    Control control = sender as Control;
    if (control == null)
    {
        // if this event isn't from a Control object then return
        return;
    }

    if (e.KeyCode == Keys.Enter)
    {
        // get the next Control to have focus
        Control nextControl = control.Tag as Control;
        if (nextControl != null)
        {
            // if there's a valid Control stored then give it focus
            nextControl.Focus();
        }
    }
}

string sConnection = "Provider = Microsoft.Jet.OLEDB.4.0;" + "Data Source = Schedule.mdb";

            try
            {
                OleDbConnection dbConnect = new OleDbConnection(sConnection);
                dbConnect.Open();

                string sqlString = "SELECT * FROM LogIn WHERE ID = '" + txtBoxLogIn.Text + "' AND Password = '" + txtBoxPassword.Text + "';";

                OleDbCommand dbCmd = new OleDbCommand();
                dbCmd.CommandText = sqlString;
                dbCmd.Connection = dbConnect;

                OleDbDataReader dbReader;
                dbReader = dbCmd.ExecuteReader();

                while (dbReader.Read())
                {
                    if (dbReader[0].ToString() == txtBoxLogIn.Text && dbReader[1].ToString() == txtBoxPassword.Text )
                    {
                        frmMainForm frmMainForm = new frmMainForm();
                        frmMainForm.ShowDialog();
                        this.Close();
                    }
                    else
                    {
                        MessageBox.Show("Either the Username or Password does not exist", "Log-In Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
                    }
                }
                
                dbReader.Close();
                dbConnect.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                return;
            }