Beispiel #1
0
        private void comboBoxMaNV2_SelectedIndexChanged(object sender, EventArgs e)
        {
            Reset2();
            string MaNV = cbbMaNV2.SelectedItem.ToString();

            //db.loadTextBox(textBoxTenNV2, "SELECT HoTenNV FROM dbo.HoSoNV WHERE MaNV=N'" + "'");

            db.loadTextBox(txtTenNV2, "SELECT TenNV FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'");
            string ten = txtTenNV2.Text.Trim();

            db.loadTextBox(txtTenNV2, "SELECT HoDemNV FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'");
            string ho      = txtTenNV2.Text.Trim();
            string HoTenNV = ho + " " + ten;

            txtTenNV2.Text = HoTenNV;

            db.loadComboBox_Show(cbbMaPB, "SELECT MaPB FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'");

            db.loadDataGridView(dgvTS, "SELECT * FROM dbo.CDThaiSan");
        }