Remove selected value from dropdowns asp.net mvc

Question

how to remove selected value from drop downs.

here is my code.

@viewbag.empskil = new selectlist(db.skils,"skillid","skillname");

my view code

@html.Dropdown("skill", @viewbag.empskil as  SelectList);

It Showing all skill in drop down An Employee can Have multiple Skill. multiple skill are adding with rating .

I just Want to remove Already Selected Skill From Drop down. can anybody tell me how to accomplish this

here is the screen

enter image description here

I just want if employee having skill these skill will not show in drop down.can any body tell me how it will be done.

structure of class skill and employee would be usefull

Raphaël Althaus
– Raphaël Althaus

2013-01-31 15:19:55 +00:00
Commented Jan 31, 2013 at 15:19 — Raphaël Althaus
– Raphaël Althaus, Commented Jan 31, 2013 at 15:19

viperguynaz · Accepted Answer · 2013-01-31 15:51:17Z

1

Sounds like you will need both server-side and client-side code. Server-side, take a list of all skills and a list of employee skills and create a new list using LINQs "Except", something like:

var unusedSkills = db.skils.ToList().Except(db.empSkils);
@viewbag.empskil = new selectlist(unusedSkills,"skillid","skillname");

Client-side, you'll want to use jQuery to remove a skill from the list after it is selected and add it to the employee's list, something like:

$("#button1").click(function(){
    $("#list1 > option:selected").each(function(){
        $(this).remove().appendTo("#list2");
    });
});

answered Jan 31, 2013 at 15:51

viperguynaz

12.2k4 gold badges33 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

hungry Over a year ago

I tried this var empskill = db.Skills.Where(m => m.CompanyId == CompanyId).Except(employee.skills); but it give me error System.NotSupportedException: Unable to create a constant value of type ''. Only primitive types ('such as Int32, String, and Guid') are supported in this context.

viperguynaz Over a year ago

without knowing what employee.skills and db.Skills look like, can't help much. Edit your question and add code details.

hungry Over a year ago

employee have many to many relationship with skill.so employee.skills geting the skills which is attached with employee.

hungry Over a year ago

found the error this is working code var empskill = db.Skills.Where(m => m.CompanyId == CompanyId).tolist().Except(employee.skills) Many thanks

Collectives™ on Stack Overflow

Remove selected value from dropdowns asp.net mvc

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related