recording multiple checkedlist box items in database

HI all,

I have tried asking on other forums but I get very short answers but I would love for someone to maybe look at my code and change the exact areas where I am wrong.

I have a table called empSkills which has employeeID pk and technicalSkillsID fk, a Technicalskills table with TechnicalskillsID pk and technicalskills, and employee table with empid pk and all other IDs etc. The Empskills table allows for multiple skills to be setsaved against an employee. at the moment I am not able to do this though. I heard about list collection or something but can someone possibly show me exactly how I do this? I have been trying to find the answer for a week so you can see that I'm not going to get it on my own. I've left the commented parts in so you can see what I've tried.


 
Thank you so so much.. !!!!
 Sianny

if (adoDR.HasRows)

{
while (adoDR.Read())

{

//techSkillsCheckListBox2.SelectedItems.Equals(adoDR["TechnicalSkillsID"]);


 
if (techSkillsCheckListBox2.CheckedItems.Count != 0)

{
for (int x = 0; x <= techSkillsCheckListBox2.CheckedItems.Count - 1; x++)

{
if (techSkillsCheckListBox2.CheckedItems[x].Equals(TechnicalSkills))

{

sql = "Insert into EmpSkills(EmployeeID,TechnicalSkillsID) values ('" + this.EmployeeID + "','" + techSkillsCheckListBox2.CheckedItems.ToString() + "')";


// for(i = 0; i< (techSkillsCheckListBox2.Items.Count); i++)

// {

// if (techSkillsCheckListBox2.CheckedItems.Equals(TechnicalSkill))

 
// foreach (int i in techSkillsCheckListBox2.CheckedIndices)

// foreach (object itemChecked in techSkillsCheckListBox2.CheckedItems)

// {

// sql = "Insert into EmpSkills(EmployeeID,TechnicalSkillsID) values ('" + this.EmployeeID + "','" + techSkillsCheckListBox2.CheckedItems.ToString() + "')";

1 Reply

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

Jan Montano19y ago
"I have a table called empSkills which has employeeID pk and technicalSkillsID fk..." "The Empskills table allows for multiple skills to be setsaved against an employee."

I just noticed, if the EmpSkills table allows for multiple skills to be setsaved against an employee, how would you define multiple skils if employeeID is a pk for empSkills? Shouldn't both [employeeID and technicalSkillsID] be unique and be fkeys instead?