private void comboBoxMaNV_SelectedIndexChanged(object sender, EventArgs e) { string MaNV = cbbMaNV.SelectedItem.ToString(); //Reset(); //dgvTTCN.DataSource = ""; //database.loadDataGridView(dgvTTCN, "SELECT * FROM dbo.TTNhanVienCoBan WHERE MaNV='" + MaNV + "'"); database.loadTextBox(txtChucVu, "SELECT ChucVu FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'"); database.loadTextBox(txtPhongBan, "SELECT MaPB FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'"); }
private void comboBoxMaNV_SelectedIndexChanged(object sender, EventArgs e) { string MaNV = comboBoxMaNV.SelectedItem.ToString(); Reset(); dataGridView1.DataSource = ""; database.loadDataGridView(dataGridView1, "SELECT * FROM dbo.TTNhanVienCoBan WHERE MaNV='" + MaNV + "'"); database.loadTextBox(textBoxTenNV, "SELECT TenNV FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'"); database.loadTextBox(textBoxHoNV, "SELECT HoDemNV FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'"); database.loadTextBox(textBoxChucVu, "SELECT ChucVu FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'"); database.loadTextBox(textBoxPhongBan, "SELECT MaPB FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'"); }
private void comboBoxMaNV_SelectedIndexChanged(object sender, EventArgs e) { string MaNV = cbbMaNV.SelectedItem.ToString(); database.loadTextBox(txtTenNV, "SELECT TenNV FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'"); database.loadTextBox(txtHoNV, "SELECT HoDemNV FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'"); database.loadTextBox(txtChucVu, "SELECT ChucVu FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'"); //database.loadComboBox_Show(comboBoxMaPB, "SELECT MaPB FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'"); //database.loadComboBox_Show(comboBoxLuong, "SELECT MaLuong FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'"); //string query = "SELECT * FROM dbo.HoSoNV WHERE MaNV='"+MaNV+"'"; //database.loadDataGridView(dataGridView, query); }
private void comboBoxMaNV1_SelectedIndexChanged(object sender, EventArgs e) { Reset(); string MaNV = cbbMaNV1.SelectedItem.ToString(); db.loadTextBox(txtMaLuong1, "SELECT MaLuong FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'"); db.loadTextBox(txtTenNV1, "SELECT TenNV FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'"); string ten = txtTenNV1.Text.Trim(); db.loadTextBox(txtTenNV1, "SELECT HoDemNV FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'"); string ho = txtTenNV1.Text.Trim(); string HoTenNV = ho + " " + ten; txtTenNV1.Text = HoTenNV; //db.loadTextBox(textBoxGhiChu1, "SELECT GhiChu FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'"); //db.loadDataGridView(dataGridViewBH, "SELECT * FROM dbo.CDBaoHiemXaHoi WHERE MaNV=N'" + MaNV + "'"); try { db.loadTextBox(txtMaBHXH, "SELECT MaBHXH FROM dbo.CDBaoHiemXaHoi WHERE MaNV='" + MaNV + "'"); } catch { } }