private void button4_Click(object sender, EventArgs e)
{
menu one = new menu();
one.Show();
Close();
}
private void button2_Click(object sender, EventArgs e)
{
menu two = new menu();
two.Show();
Close();
}
private void button1_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string sql = "SELECT * FROM userstable WHERE Username = '******'AND Password = '******'";
MySqlConnection con = new MySqlConnection("host=localhost;user=admin;password=130943;database=usersdatabase");
/*MySqlCommand cmd = new MySqlCommand(sql, con);*/
MySqlDataAdapter sda = new MySqlDataAdapter(sql, con);
DataTable dt = new DataTable();
sda.Fill(dt);
con.Open();
/*MySqlDataReader reader = cmd.ExecuteReader();
* while (reader.Read())*/
if (dt.Rows.Count == 3)
{
menu one = new menu();
one.Show();
Close();
}
else
{
MessageBox.Show("ชื่อผู้ใช้งานหรือรหัสผ่านไม่ถูกต้อง", "ระบบผิดพลาด");
}
}