List Box Issue while inserting data in Windows App

Posted by Raj.Trivedi under C# on 3/2/2013 | Points: 10 | Views : 1070 | Status : [Member] [MVP] | Replies : 0
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



Responses

(No response found.)

Login to post response