private void button1_Click(object sender, EventArgs e) { conn.Open(); dr = new MySqlDataAdapter("SELECT * FROM admin WHERE uname='" + textBox1.Text + "' AND pass='******'", conn); DataTable dt = new DataTable(); dr.Fill(dt); if (dt.Rows.Count > 0) { global.a_name = dt.Rows[0]["uname"].ToString(); global.a_posi = dt.Rows[0]["posi"].ToString(); MessageBox.Show("Welcome: " + global.a_name, "Welcome Admin", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Hide(); landing_page nf = new landing_page(); nf.Show(); } else if (string.IsNullOrEmpty(textBox1.Text) && string.IsNullOrEmpty(textBox2.Text)) { MessageBox.Show("Please Input Username and Password!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else if (string.IsNullOrEmpty(textBox1.Text)) { MessageBox.Show("Please Input Username!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else if (string.IsNullOrEmpty(textBox2.Text)) { MessageBox.Show("Please Input Password!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { MessageBox.Show("Invalid Account!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } conn.Close(); }
private void button1_Click(object sender, EventArgs e) { conn.Open(); dr = new MySqlDataAdapter("SELECT * FROM admin WHERE uname='" + textBox1.Text + "' AND pass='******'", conn); DataTable dt = new DataTable(); dr.Fill(dt); if (dt.Rows.Count > 0) { global.a_name = dt.Rows[0]["uname"].ToString(); MessageBox.Show("Welcome " + global.a_name); this.Hide(); landing_page nf = new landing_page(); nf.Show(); } else { MessageBox.Show("invalid account"); } conn.Close(); }