удаление

 private void button1_Click(object sender, EventArgs e)
        {
            var result = MessageBox.Show("Вы действительно хотите удалить запись?", "Удаление", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (result == DialogResult.Yes)
            {
                string mytablename = "table";
                string mybdpath = Application.StartupPath + @"\base.mdb";
                string conStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mybdpath;
                int id = Convert.ToInt32(dataGridView[0, dataGridView.CurrentRow.Index].Value.ToString());
                OleDbConnection connection = new OleDbConnection(conStr);
                OleDbCommand command = new OleDbCommand("DELETE FROM ["+ mytablename+"] WHERE id=" + id, connection);
                command.Connection.Open();
                command.ExecuteNonQuery();
                //command.Connection.Close();
 
                OleDbConnection con = new OleDbConnection(conStr);
                OleDbDataAdapter adapter = new OleDbDataAdapter();
 
                
                OleDbCommand com = new OleDbCommand("SELECT * FROM [" + mytablename + "] ORDER BY id", con);
                
 
                adapter.SelectCommand = com;
                DataSet dataSet = new DataSet();
                adapter.Fill(dataSet);
                dataGridView.DataSource = dataSet.Tables[0];
                adapter.Update(dataSet);
            }
        }

dataGridView[0, dataGridView.CurrentRow.Index].Value;
dataGridView.CurrentRow[0].Value;

int id = (int)dataGridView.CurrentRow.Cells[0].Value;
OleDbCommand command = new OleDbCommand("DELETE FROM ["+ mytablename+"] WHERE id=" + id, connection);

DataRow _row = dataSet.Tables[0].Rows.Find(id);
_row.Delete();
dataGridView.Rows.Remove(dataGridView.CurrentRow)
adapter.Update(dataSet.Tables[0]);
dataSet.AcceptChanges();