DataGridView doesn't apply changes
<p>i'm attaching the code.
i'm trying to delete a raw and append it to the original database with datagridview.
i successively get the datagridview, but the modifications are not saved.</p>

<p>i cannot hav the datagridview save anything, it just pops right back up on next launch.
thank you so much in advance.</p>

<pre><code>private void button2_Click(object sender, EventArgs e)
{
            SqlConnection myConnection = new SqlConnection("Data Source=MyServerName\\InstanceName;Initial Catalog="+ comboBox1.Text + ";Integrated Security=SSPI;");
                string sqlQuery = @"SELECT * from " + comboBox2.Text;
                SqlCommand cmd = new SqlCommand(sqlQuery, myConnection);

            SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataTable table = new DataTable();
                da.Fill(table);
                dataGridView1.DataSource = new BindingSource(table, null);
                myConnection.Close();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            foreach (DataGridViewRow item in this.dataGridView1.SelectedRows)
            {
                DialogResult question = MessageBox.Show("Are You Sure?", "Please Confirm", MessageBoxButtons.YesNo);
                if ( question == DialogResult.Yes)

                {

                   dataGridView1.Rows.RemoveAt(item.Index);
                   dataGridView1.CommitEdit(DataGridViewDataErrorContexts.Commit);
                   myConnection.Close();

                }
                else
                {
                    myConnection.Close();
                    break;
                }
            }
        }
    }
}
</code></pre>
