I have one combo box and a Listbox.
Both of the controls are getting data from database.
Now i am selecting the items in combo box and selecting items in list box.
I want that what id of the item selected in the combobox to be updated against all the items selected in the list box.
My Combo box is of teamleader.
My List box is of employee.
Now when i select a Teamleader the id of the teamleader should be updated to all the selected employees in the list box.
Eg If i select Teamleader in the combo box as raj whose id = 1
And then if i select 5 employees and click save
then against all the employees the teamleader id should be updated =1
so that means Raj as team leader will have 5 employees.
I am also attaching the for loop but in my for loop it is only updating one value
private void btnMap_Click(object sender, EventArgs e)
con = new SqlConnection(strconn);
for (int items = 0; items < listBox1.SelectedItems.Count; items++)
DataRowView drv = listBox1.SelectedItems[items] as DataRowView;
if (drv != null)
sqlcmd = new SqlCommand("MappEmployees", con);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@TeamLeaderID",SqlDbType.Int).Value = cmbTL.SelectedValue;
sqlcmd.Parameters.AddWithValue("@EmployeeCode", SqlDbType.Int).Value = listBox1.SelectedItems;
int result= sqlcmd.ExecuteNonQuery();
catch (Exception ex)
throw new Exception(ex.Message);
This is my Employee Table.
create table EmployeeDetails
EmpID int identity(1,1),
create proc UpdateTL
update employeedetails set TL =@TLID where EmpID =@EmpID
This logic is only updating one Employees TeamleaderID