public void ShowDepartments(string search)
        {
            N_Departments objDepartment = new N_Departments();

            //limpiamos la tabla para que no haya filas seleccionadas
            tableDepartment.ClearSelection();

            tableDepartment.DataSource = objDepartment.ShowDepartments(search);
        }
        public void ItemsCmbDepartment(string search)
        {
            N_Departments _itemsDepartment = new N_Departments();

            cmbDepartment.DataSource = _itemsDepartment.ShowDepartments(search);
            //quiero que tenga el valor del id
            cmbDepartment.ValueMember = "IdDepartment";
            //pero quiero que el usuario vea el nombre
            cmbDepartment.DisplayMember = "NameDepartment";
        }