private void b_r_keluarga_Click(object sender, EventArgs e) { Riwayat_Keluarga rk = new Riwayat_Keluarga(t_nip_nrp.Text); rk.Show(); this.Hide(); }
private void btn_login_Click(object sender, EventArgs e) { SqlCommand perintahLogin = new SqlCommand(); conn = Connection.connect(); perintahLogin.Connection = conn; perintahLogin.CommandType = CommandType.Text; perintahLogin.CommandText = "select * from dbo.personil where nip_nrp=@nip_nrp and password=@password and role=@role"; perintahLogin.Parameters.Add("@nip_nrp", SqlDbType.VarChar); perintahLogin.Parameters.Add("@password", SqlDbType.VarChar); perintahLogin.Parameters.Add("@role", SqlDbType.VarChar); perintahLogin.Parameters["@nip_nrp"].Value = t_nip_nrp.Text.Trim(); perintahLogin.Parameters["@password"].Value = t_password.Text.Trim(); perintahLogin.Parameters["@role"].Value = cb_role.Text.Trim(); conn.Open(); dr = perintahLogin.ExecuteReader(); if (dr.Read() == true) { MessageBox.Show("Berhasil Login"); Riwayat_Keluarga rk = new Riwayat_Keluarga(t_nip_nrp.Text); rk.Show(); this.Hide(); } else { MessageBox.Show("Maaf tidak dapat login silahkan cek username dan password anda.!"); } conn.Close(); }