private void btnAdd_Click(object sender, EventArgs e)
 {
     if (txtPassword.Text.Length > 7 && txtPassword.Text.Length < 10 && txtUsername.Text.Length > 7 && txtUsername.Text.Length < 11)
     {
         CLogin c = new CLogin();
         c.Username = txtUsername.Text;
         c.Password = txtPassword.Text;
         CLoginDB.add(c);
         DBUtil.closeSqlConnection();
         MessageBox.Show("Account added");
     }
 }
 private void btnChange_Click(object sender, EventArgs e)
 {
     if (isNew && isConfirm)
     {
         CLogin c = new CLogin();
         c.Password = tbConfirmPassword.Text;
         c.Username = Login.username;
         CLoginDB.updatePassword(c);
         DBUtil.closeSqlConnection();
         Login.initLogin();
         DialogResult result = MessageBox.Show("Password changed", "Change", MessageBoxButtons.OK, MessageBoxIcon.Information);
         if (result == System.Windows.Forms.DialogResult.OK)
         {
             this.Close();
         }
     }
 }
 public static void initLogin()
 {
     logins = CLoginDB.getAll();
     logins.Sort();
     DBUtil.closeSqlConnection();
 }