예제 #1
0
        private void btn_login_Click(object sender, EventArgs e)
        {
            connection = new MySqlConnection(ConnectionString);

            if (txt_uname.Text == "" || txt_pword.Text == "")
            {
                MessageBox.Show("Invalid Username or Password");
            }
            try
            {
                connection.Open();
                MySqlCommand cmd = new MySqlCommand("SELECT uname, pword  From users Where uname = '" + txt_uname.Text + "' And pword ='" + txt_pword.Text + "'", connection);
                MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                adapter.Fill(ds);
                cmd.ExecuteNonQuery();
                connection.Close();

                int count = ds.Tables[0].Rows.Count;
         
              
                if (count == 1)
                {
                    //MessageBox.Show("Login Successfully!");

                    MainForm main = new MainForm();
                    main.FormClosed += new FormClosedEventHandler(mainformclosed);
                    main.Show();

                    this.Hide();
                }

                else
                {
                    MessageBox.Show("Invalid Username or Password");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
예제 #2
0
        private void btn_login_Click(object sender, EventArgs e)
        {
            connection = new MySqlConnection(ConnectionString);

            try
            {
                connection.Open();
                MySqlCommand cmd = new MySqlCommand("SELECT uname, pword From users Where uname = '" + txt_uname.Text + "' AND  pword = '" + txt_pword.Text + "' and status = 'Active'", connection);
                MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                adapter.Fill(ds);
                cmd.ExecuteNonQuery();
                connection.Close();

                int count = ds.Tables[0].Rows.Count;

                if (count == 1)
                {                   
                    MainForm main = new MainForm();
                    main.FormClosed += new FormClosedEventHandler(mainformclosed);
                    main.Show();

                    this.Hide();                
                }
               
                else
                {
                    btn_cancel.PerformClick();
                    MetroMessageBox.Show(this, "Invalid Username or Password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);                   
                }
            }      
                catch (Exception ex)
                {
                    MetroMessageBox.Show(this, ex.Message);
                }
            }