How to update dropdownlist in gridview

I have a gridview in my form,in which there is dropdownlist that is fill up using following code

Hide Copy Code

DropDownList ddlEmployee = (DropDownList)row.FindControl("ddlEmp");

       DropDownList ddlEmployee2 = (DropDownList)row.FindControl("ddlEmp2");

             var Emplist1 = _service.GetAllSectorEmployee();

 ddlEmployee.Bind(Emplist1, "EmployeeIdName", "Employee_Id");

   ddlEmployee2.Bind(Emplist1, "EmployeeIdName", "Employee_Id");

i have a requirement that when ever employee is selected ,then it will remove from list,i have done it using following code,

Hide Copy Code

var removelist = _service.GetAllSectorEmployee().Where(x => x.Employee_Id == Emp2).FirstOrDefault();

                     _service.DeleteSectorEmployee(removelist);

problem is that when employee is removed ,dropdownlist will be updated and also remove that employee.how can i do it? i try following code but fruitless

Hide Copy Code

DropDownList ddlEmployee = (DropDownList)row.FindControl("ddlEmp");

                     DropDownList ddlEmployee2 = (DropDownList)row.FindControl("ddlEmp2");

                var Emplist1 = _service.GetAllSectorEmployee();

    ddlEmployee.Bind(Emplist1, "EmployeeIdName", "Employee_Id");

       ddlEmployee2.Bind(Emplist1, "EmployeeIdName", "Employee_Id");

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sajid Hussain11y ago
Employee is removed from database,but dropdownlist show that employee,if i refresh the page then that employee is removed from the list,but i dont want to refresh the page because it all the selected value
Vivek Joy11y ago
Hi
Check
how do you display the values to dropdownlist.

Whether while you deleting the value then the current employee dtails is removed from database or not?
Sajid Hussain11y ago
i want that each time when employee is slected ,it will remove from the list ,and dropdown list is updateed soon after removal of employee,user just see remaining employee
Vivek Joy11y ago
I didn't understand what is your need?