Example #1
0
        private void loginButton_Click(object sender, EventArgs e)
        {
            string ConnectionString = ConfigurationManager.ConnectionStrings["LogAuth"].ConnectionString;

            using (MySqlConnection con = new MySqlConnection(ConnectionString))
            {
                con.Open();
                using (MySqlCommand cmd = con.CreateCommand())
                {
                    cmd.CommandText = @"select count(*) from logauth where UserName=@UserName and Password=@Password";
                    cmd.Parameters.Add(new MySqlParameter("UserName", UsernameO.Text));
                    cmd.Parameters.Add(new MySqlParameter("Password", PasswordO.Text));
                    int i = Convert.ToInt32(cmd.ExecuteScalar());
                    if (i > 0)
                    {
                        QMSParent invf = new QMSParent(UsernameO.Text);
                        invf.Show();
                        this.Hide();
                        QMSParent.variable1 = UsernameO.Text;
                    }
                    else
                    {
                        MessageBox.Show("UserName or Password error.");
                    }
                }
            }
        }
Example #2
0
        private void exitToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            this.Close();
            QMSParent mp = new QMSParent();

            mp.Show();
        }