Hello Team,
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.
EG :-
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.
Regards,
Raj.Trivedi.
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;
try
{
con.Open();
int result= sqlcmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
This is my Employee Table.
create table EmployeeDetails
(
EmpID int identity(1,1),
EmpName varchar(20),
TeamleaderID int
)
Stored Proc
create proc UpdateTL
(
@EmpID int,
@TLID int
)
as
begin
update employeedetails set TL =@TLID where EmpID =@EmpID
end
)
This logic is only updating one Employees TeamleaderID
Regards,
Raj.trivedi
Regard's
Raj.Trivedi
"Sharing is Caring"
Please mark as answer if your Query is resolved