Add ID to listbox pass those values to a multi update query

Hey Josue,

Yw !! Good to know that ur problem solved :)

Good luck ...

THANKS GUYS, after a weekend of frustration I found the answer with your help.

this is my code it will update each item in the listbox WHERE column='listbox.value" foreach

private void update_containers(object sender, EventArgs e)
        {
                foreach (var item in shiplist.Items)
                {
                string a =item.ToString();
                string Query = "UPDATE ewaste.container SET ContainerStatus='Shipped', ShipmentID='" + this.lastid_show_txt.Text + "', ShipDate=CURRENT_TIMESTAMP, ShippedBy='" + Properties.Settings.Default.LoggedUser + "' WHERE ContainerID='" + a + "';";
                MySqlConnection conDataBase = new MySqlConnection(Properties.Settings.Default.RPS);
                MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase);
                MySqlDataReader myReader;
                try
                {
                    conDataBase.Open();
                    myReader = cmdDataBase.ExecuteReader();
                    while (myReader.Read())
                    { }
                }
                catch (MySql.Data.MySqlClient.MySqlException ex)
                {
                    MessageBox.Show("Error " + ex.Number + " has occurred: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }

Hi Josue,

Adding the items to list box :

http://www.dotnetperls.com/listbox

For Updating :
http://stackoverflow.com/questions/16652306/c-sharp-update-database-for-every-item-in-listbox
http://forums.asp.net/t/1446801.aspx?How+to+view+and+update+MS+SQL+table+using+ListBox+c+

Thank you, I appreciate your time. 

Sample:

So I want to add names to the listbox

Then run a UPDATE query for each of the otems in the listbox. 

Hey Josue,


SELECT * FROM employee_tbl
WHERE daily_typing_pages IN ( 250, 220, 170 );

IN after we should have the braces right ? I think that was the problem