private void dg_peg_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (dg_peg.SelectedIndex >= 0) { DataRowView dataRow = (DataRowView)dg_peg.SelectedItem; string index = dataRow.Row[0].ToString(); k.sql = "select *from pegawai left join akun on pegawai.nip = akun.nip where pegawai.nip = '" + index + "'"; k.setdt(); Byte[] tmpfoto = new Byte[0]; String tgllahir; foreach (DataRow baris in k.dt.Rows) { txt_nip.Text = baris[0].ToString(); txt_nama.Text = baris[1].ToString(); if (baris[2].ToString() == "Laki - Laki") { rb_laki.IsChecked = true; } else { rb_perempuan.IsChecked = true; } tgllahir = baris[3].ToString(); DateTime dt = Convert.ToDateTime(tgllahir); dp_tgllahir.SelectedDate = dt; txt_alamat.Text = baris[4].ToString(); txt_tempatlahir.Text = baris[5].ToString(); cmb_agama.Text = baris[6].ToString(); cmb_jabatan.Text = baris[7].ToString(); txt_nohp.Text = baris[8].ToString(); tmpfoto = (Byte[])baris[9]; img_foto.Source = ByteImageConverter.ByteToImage(tmpfoto); txt_username.Text = baris[10].ToString(); txt_password.Password = baris[11].ToString(); } btn_ubah.IsEnabled = true; btn_hapus.IsEnabled = true; } }
public form_menu(string nip, string _sessionid) { InitializeComponent(); //load nama user //----------------------------------- k.sql = "select *from pegawai inner join akun on pegawai.nip = akun.nip where pegawai.nip='" + nip + "'"; k.setdt(); string cekhak = ""; Byte[] tmpfoto = new Byte[0]; foreach (DataRow baris in k.dt.Rows) { txt_namausr.Text = baris[1].ToString(); txt_nipusr.Text = baris[0].ToString(); txt_hakusr.Text = baris[13].ToString(); tmpfoto = (Byte[])baris[9]; fotousr.ImageSource = ByteImageConverter.ByteToImage(tmpfoto); } txt_namausr2.Text = txt_namausr.Text; txt_nipusr2.Text = txt_nipusr.Text; txt_hakusr2.Text = txt_hakusr.Text; fotousr2.ImageSource = fotousr.ImageSource; sessionId = _sessionid; //timer------------- DispatcherTimer timer = new DispatcherTimer(DispatcherPriority.Render); timer.Interval = TimeSpan.FromMilliseconds(2500); timer.Tick += timer_refreshData; timer.Start(); //--------- //Digital Clock------------- DispatcherTimer clock = new DispatcherTimer(DispatcherPriority.Render); clock.Interval = TimeSpan.FromSeconds(1); clock.Tick += digitalClockTick; clock.Start(); //--------- }
private void showdata() { k.sql = "select *from data_sekolah"; k.setdt(); Byte[] tmpfoto = new Byte[0]; foreach (DataRow baris in k.dt.Rows) { txt_kdsklh.Text = baris[0].ToString(); txt_namasklh.Text = baris[1].ToString(); txt_alamat.Text = baris[2].ToString(); txt_kota.Text = baris[3].ToString(); txt_kec.Text = baris[4].ToString(); txt_kdpos.Text = baris[5].ToString(); txt_kepalasklh.Text = baris[6].ToString(); txt_nip.Text = baris[7].ToString(); txt_notelp.Text = baris[8].ToString(); tmpfoto = (Byte[])baris[9]; img_foto.Source = ByteImageConverter.ByteToImage(tmpfoto); } }
private void dg_sisw_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (dg_sisw.SelectedIndex >= 0) { DataRowView dataRow = (DataRowView)dg_sisw.SelectedItem; string index = dataRow.Row[0].ToString(); k.sql = "select *from siswa left join kelas on siswa.kd_kelas = kelas.kd_kelas where siswa.nis = '" + index + "'"; k.setdt(); Byte[] tmpfoto = new Byte[0]; String tgllahir; foreach (DataRow baris in k.dt.Rows) { txt_nisn.Text = baris[0].ToString(); txt_nis.Text = baris[1].ToString(); txt_nama.Text = baris[2].ToString(); if (baris[3].ToString() == "Laki - Laki") { rb_laki.IsChecked = true; } else { rb_perempuan.IsChecked = true; } tgllahir = baris[4].ToString(); DateTime dt = Convert.ToDateTime(tgllahir); dp_tgllahir.SelectedDate = dt; txt_tempatlahir.Text = baris[5].ToString(); txt_alamat.Text = baris[6].ToString(); cmb_agama.Text = baris[7].ToString(); tmpfoto = (Byte[])baris[9]; img_foto.Source = ByteImageConverter.ByteToImage(tmpfoto); } btn_ubah.IsEnabled = true; btn_hapus.IsEnabled = true; } }