cmd.CommandText = "insert into lignes_de_commande ( num_commande,reference,commune) values('" + int.Parse(txtNumCmd.Text) + "','" + listaffiches.SelectedItems + "','" + checkedListVallelAude.SelectedItem + "')";
foreach (object itemChecked in checkedListVallelAude.CheckedItems) { cmd.CommandText = "insert into lignes_de_commande ( num_commande,reference,commune) values('" + int.Parse(txtNumCmd.Text) + "','" + listaffiches.SelectedItem + "','" + checkedListVallelAude.CheckedItems.ToString() + "')"; cmd.ExecuteNonQuery(); }
foreach (string Item in checkedListVallelAude.CheckedItems) { cmd.CommandText = "insert into lignes_de_commande ( num_commande,reference,commune) values(" + int.Parse(txtNumCmd.Text) + ",'" + listaffiches.SelectedItem + "','" + Item + "')"; cmd.ExecuteNonQuery();
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionstring Item in checkedListVallelAude.CheckedItems
foreach (string Item in checkedListVallelAude.CheckedItems) { cmd.CommandText = "insert into lignes_de_commande ( num_commande,reference,commune) values(" + int.Parse(txtNumCmd.Text) + ",'" + listaffiches.SelectedItem + "','" + Item + "')"; cmd.ExecuteNonQuery(); }