private void Textbox1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Down || e.KeyCode == Keys.Enter)
{
Textbox2.Focus();
}
}
private void button4_Click_1(object sender, EventArgs e)
{
try
{
if (Textbox1.Text == "")
{
MessageBox.Show("Please enter username", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Textbox1.Focus();
return;
}
else if (Textbox2.Text == "")
{
MessageBox.Show("Please enter password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Textbox2.Focus();
return;
}
else
{
i = 0;
koneksi.Open();
MySqlCommand cmd = koneksi.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from akun_siswa where username_siswa='" + Textbox1.Text + "'and password_siswa='" + Textbox2.Text + "'";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dt);
i = Convert.ToInt32(dt.Rows.Count.ToString());
if (i == 0)
{
MessageBox.Show("you have entered invalid username or password", "Error");
Textbox1.Text = "";
Textbox2.Text = "";
}
else
{
save_data2();
MessageBox.Show("Welcome Student SMKN 10 Jakarta", "Login");
Form2 f2 = new Form2();
f2.Show();
this.Hide();
Textbox1.Text = "";
Textbox2.Text = "";
}
koneksi.Close();
}
}
catch (Exception ex)
{
koneksi.Close();
MessageBox.Show(ex.ToString(), ex.Message);
}
}
