update of lines followed according to items selected in listview

Question

we have a table 1, which has building and rooms, building A, sala01, room 02.... , we need to put people in these rooms. These people come from another table(2), which fills the listview. This Lvi has checkboxes and is multiselect. How will you do it? Select people by checkboxes and click a button to place each person in a room in sequence. If you select Person 1, Person 4, Person 7, you place Person 1 in Room 1, Person 4 in Room 2, Person 7 in Room 3, right on the bench for display on the grid.... I’m doing it like this:

 private void btnAlocar_Click(object sender, EventArgs e)
        {
            foreach (ListViewItem item in listView2.CheckedItems)
            {
                if (item.Checked == true)
                {
                    int j = listView2.CheckedItems.Count;
                    try
                    {
                        SqlConnection con = new SqlConnection(conexaoString);

                        con.Open();

                        for (int i = 0; i < (j); i++)
                        {
                            var cmd = new SqlCommand(@"UPDATE salas SET
                            nomePessoa=@nomePessoa, cargo=@cargo, idPessoa=@idPessoa WHERE idSala=@idSala", con);

                            cmd.Parameters.AddWithValue("@idSala", Convert.ToInt32(dgvSalas.CurrentRow.Cells["idSala"].Value.ToString()));

                            cmd.Parameters.AddWithValue("@nomePessoa", item.SubItems[0].Text);
                            cmd.Parameters.AddWithValue("@idPessoa", Convert.ToInt32(item.SubItems[3].Text));

                            cmd.ExecuteNonQuery();
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show($"Erro ao alocar Pessoa: {ex.Message}");
                    }
                    finally
                    {
                        SqlConnection con = new SqlConnection(conexaoString);
                        this.salasTableAdapter.Fill(this.bdDataSet.salas);

                        con.Close();
                        con.Dispose();
                    }
                }
            }

        }

it does the insertion, but from one person, I’m not getting it to pass to the next line and insert the other selected, where I’m missing, I can’t find the error....

Answer 1

On the line

cmd.Parameters.AddWithValue("@idSala", Convert.ToInt32(dgvSalas.CurrentRow.Cells["idSala"].Value.ToString()));

Where do you update dgvSalas.CurrentRow? 'Cause it looks to me like you’re overwriting the user in that room with every UPDATE...