コード例 #1
0
        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();
            }
        }
コード例 #2
0
 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();
 }