Listbox C# ASP.NEt - Number of selected items

Okay.

My comple code below

    protected void btnsave_Click(object sender, ImageClickEventArgs e)
    {
                string constr = ConfigurationManager.ConnectionStrings["cn"].ConnectionString;
                using (MySqlConnection con =
                    new MySqlConnection(constr))
                {
                    using (MySqlCommand cmd =
                        new MySqlCommand("SAVE_20250127", con))
                    {
                        cmd.CommandTimeout = 2147483;
                        cmd.Connection.Open();
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.Clear();

                        string s = "";
                        foreach (ListItem item in myddl.Items)
                        {
                            if (item.Selected)
                            {
                                s += item.Text + ";";
                            }
                        }
                        Response.Write(s.ToString().ToUpper() + "<br />"); ;
                        cmd.Parameters.AddWithValue("@myddl", s.ToString().ToUpper());

                        cmd.ExecuteNonQuery();
                        cmd.Connection.Close();
                    }
                }
    }

Please explain what are you doing

I need to update the "myddl" column of the mysql database table using the stored procedure "SAVE_20250127"

The "myddl" column of the mysql database table must contain one or more values ​​selected from the multiple-select listbox.

If the value from the listbox is multiple, the "myddl" column must record, e g. "Chicago; Denver"

If the value from the listbox is single, the "myddl" column must record, e. g, "Chicago;"

Now the "myddl" column of the mysql database table updates only if the value from the listbox is multiple, e g. "Chicago; Denver"

If the value from the listbox is single, e. g, "Chicago;" the column "myddl" is updated as empty.

Hi,

Try this way of saving to database

https://www.aspsnippets.com/questions/190291/Update-multiple-values-from-ListBox-in-Database-in-ASPNet/Replies/3#Replies