Advertisement
Guest User

Untitled

a guest
Apr 24th, 2019
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1.  
  2. protected void Txt_NIP_TextChanged(object sender, EventArgs e)
  3. {
  4. SqlConnection SPPDConn = new SqlConnection(ConfigurationManager.ConnectionStrings["SPPDConnection"].ConnectionString);
  5. SPPDConn.Open();
  6. SqlCommand namaOtomatis = new SqlCommand("select * from pegawai where nip ='" + Txt_NIP.Text + "'", SPPDConn);
  7. SqlDataReader bacaOtomatis = namaOtomatis.ExecuteReader();
  8. if (bacaOtomatis.Read())
  9. {
  10. Txt_nama.Text = (bacaOtomatis["nama"].ToString());
  11. Txt_pangkat.Text = (bacaOtomatis["pangkat"].ToString());
  12. Txt_golongan.Text = (bacaOtomatis["golongan"].ToString());
  13. txt_jabatan.Text = (bacaOtomatis["jabatan"].ToString());
  14. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement