VS C# Write data set to another table

I have a dataset defined as MyDataSet= new System.Data.DataSet() along with a DataAdapter called MyDataAdapter. I then use _commandBuilder = new SqlCommandBuilder(MYDataAdapter) and finally MyDataAdapter.Fill(MyDataSet) to get the data and present it to the user via a data grid view. On the dgv I did add a Checkbox. Now on the screen the user sees values for order number, customer, amount plus the checkbox. The only field the user can change is the checkbox. If the user checks the box, I do not want to write these order numbers to another table. So the question here is:
How do I set up the code under the 'Save' button so it will write this dataset to another table but only for those records that have not been checked? Do I have to loop through each record in the dataset looking for the unchecks one and write only them or is there a way to commit this entire dataset to another table? How do I get this commit to write to another table? I have included the complete code below.

      private void DisplayOpenSalesOrders()
        {
            /* Define dataset for open sales orders in My */
            MyDataSet = new System.Data.DataSet();
            MyDataSet.CaseSensitive = false;

            /* Define the data command for the open sales orders in My */
            MyDataCommand = new System.Data.SqlClient.SqlCommand();
            MyDataCommand.Connection = MyDataConnection;

            MyDataCommand.CommandText = "SELECT * FROM SelectOpenOrders WHERE DOCDATE <= '" + txtThroughDate.Text + "' ORDER BY DOCDATE";
           
            /* Define the data adapter for the open sales orders */
            MyDataAdapter = new System.Data.SqlClient.SqlDataAdapter();
            MyDataAdapter.SelectCommand = MyDataCommand;

            _commandBuilder = new SqlCommandBuilder(MyDataAdapter);

            /* Populate the data set */
            MyDataAdapter.Fill(MyDataSet);

            dgvOpenSalesOrders.DataError += new DataGridViewDataErrorEventHandler(dgvOpenSalesOrders_DataError);

            dgvOpenSalesOrders.RowHeadersVisible = false;
            dgvOpenSalesOrders.DataSource = MyDataSet.Tables[0].DefaultView;
            dgvOpenSalesOrders.AutoGenerateColumns = true;
            dgvOpenSalesOrders.DefaultCellStyle.NullValue = ' ';
            dgvOpenSalesOrders.AllowUserToAddRows = false;
            dgvOpenSalesOrders.AllowUserToDeleteRows = false;

            dgvOpenSalesOrders.Columns[0].Width = 80;
            dgvOpenSalesOrders.Columns[0].ReadOnly = true;
            dgvOpenSalesOrders.Columns[0].HeaderText = "Doc Date";
            dgvOpenSalesOrders.Columns[0].DefaultCellStyle.Tag = "TOUPPER";

            dgvOpenSalesOrders.Columns[1].Width = 110;
            dgvOpenSalesOrders.Columns[1].ReadOnly = true;
            dgvOpenSalesOrders.Columns[1].HeaderText = "Req Ship Date";
            dgvOpenSalesOrders.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvOpenSalesOrders.Columns[1].DefaultCellStyle.Tag = "TOUPPER";

            dgvOpenSalesOrders.Columns[2].Width = 100;
            dgvOpenSalesOrders.Columns[2].ReadOnly = true;
            dgvOpenSalesOrders.Columns[2].HeaderText = "Doc Type";
            dgvOpenSalesOrders.Columns[2].DefaultCellStyle.Tag = "TOUPPER";

            dgvOpenSalesOrders.Columns[3].Width = 120;
            dgvOpenSalesOrders.Columns[3].ReadOnly = true;
            dgvOpenSalesOrders.Columns[3].HeaderText = "Doc Number";
            dgvOpenSalesOrders.Columns[3].DefaultCellStyle.Tag = "TOUPPER";

            dgvOpenSalesOrders.Columns[4].Width = 100;
            dgvOpenSalesOrders.Columns[4].ReadOnly = true;
            dgvOpenSalesOrders.Columns[4].HeaderText = "Cust Number";
            dgvOpenSalesOrders.Columns[4].DefaultCellStyle.Tag = "TOUPPER";

            dgvOpenSalesOrders.Columns[5].Width = 300;
            dgvOpenSalesOrders.Columns[5].ReadOnly = true;
            dgvOpenSalesOrders.Columns[5].HeaderText = "Cust Name";
            dgvOpenSalesOrders.Columns[5].DefaultCellStyle.Tag = "TOUPPER";

            dgvOpenSalesOrders.Columns[6].Width = 100;
            dgvOpenSalesOrders.Columns[6].ReadOnly = true;
            dgvOpenSalesOrders.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
            dgvOpenSalesOrders.Columns[6].DefaultCellStyle.Format = "c";
            dgvOpenSalesOrders.Columns[6].HeaderText = "Doc Amount";

            DataGridViewCheckBoxColumn colCheckBox = new DataGridViewCheckBoxColumn();
            colCheckBox.HeaderText = "Keep";
            colCheckBox.Name = "colCheck";
            colCheckBox.Width = 36;
            dgvOpenSalesOrders.Columns.Insert(7, colCheckBox);

            dgvOpenSalesOrders.EditMode = DataGridViewEditMode.EditOnEnter;
            dgvOpenSalesOrders.Focus();
        }

        private void dgvOpenSalesOrders_DataError(object sender, DataGridViewDataErrorEventArgs anError)
        {
        }

        private void btnDisplay_Click(object sender, EventArgs e)
        {
            DisplayOpenSalesOrders();
        }
    }