private void dgv_slr_RowEnter(object sender, DataGridViewCellEventArgs e) { int numrow; numrow = e.RowIndex; if (numrow >= 0) { tb_slr_id.Text = dgv_slr.Rows[numrow].Cells[0].Value.ToString(); tb_slr_name.Text = ManagerForm.ReadDataa("SELECT STAFF.FULLNAME FROM STAFF WHERE STAFF.ID = '" + dgv_slr.Rows[numrow].Cells[0].Value.ToString() + "'").ToString(); tb_slr_payrate.Text = dgv_slr.Rows[numrow].Cells[3].Value.ToString(); tb_slr_allowence.Text = dgv_slr.Rows[numrow].Cells[5].Value.ToString(); tb_slr_basicrate.Text = dgv_slr.Rows[numrow].Cells[4].Value.ToString(); tb_slr_tl.Text = dgv_slr.Rows[numrow].Cells[6].Value.ToString(); } }
private void EmployeeForm_Load(object sender, EventArgs e) { lb_st_fn.Text = ManagerForm.ReadDataa("SELECT STAFF.FULLNAME FROM STAFF JOIN PASSWORD ON STAFF.ID = PASSWORD.ID WHERE PASSWORD.USERNAME = '******'").ToString(); lb_st_id.Text = ManagerForm.ReadDataa("SELECT ID FROM PASSWORD WHERE PASSWORD.USERNAME = '******'").ToString(); }