Как настроить кнопку для заполнения столбцов БД из текстбоксов?

public class NewPeople : Form 
{
    public string Firm 
    {
        get
        {
            return txtFirm.Text.Trim();
        }
    }
    
    ........
    
    private void btnSaveNewPeople_Click(object sender, EventArgs e)
    {
        if (ne vse kak nado)
            DialogResult = DialogResult.No;
        else
            DialogResult = DialogResult.OK;
    }
    
}

private void btnAddPeople_Click(object sender, EventArgs e)
{
    NewPeople newPeople = new NewPeople();
    if (newPeople.ShowDialog() != DialogResult.OK)
    {
        MessageBox.Show("Не добавлен");
        return;
    }
    
    DataRow drNewPeople = DataSet.Tables["PeoplesTable"].NewRow();
    
    drNewPeople["Firm"] = newPeople.Firm;
    drNewPeople["FirstName"] = newPeople.FirstName;
    drNewPeople["LastName"] = newPeople.LastName;
    ......
 
    DataSet.Tables["PeoplesTable"].Rows.Add(drNewPeople);
 
    PeopleDataAdapter.Update(DataSet.Tables["PeoplesTable"]);
}

OleDbDataAdapter mydata = new OleDbDataAdapter();
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            OleDbConnection conn;
            OleDbCommand comm;
            ConnectionStringSettings constring = ConfigurationManager.ConnectionStrings["autocnstr"];
            conn = new OleDbConnection(constring.ConnectionString);
            conn.Open();
            //string command = "update  zayvka [nazvanie], [uchastok], [object], [project], [komu], [kto], [data] VALUES (@name, @uch, @obj, @proj, @komu, @kto, @data) where id = @id";
            string command = "update zayvka set [nazvanie] = @name, [uchastok] = @uch, [object] = @obj, [project] = @proj, [komu] = @komu, [kto] = @kto, [data] = @data where id = @id";
            OleDbCommand com = new OleDbCommand(command, conn);
            com.Parameters.AddWithValue("@name", textBox4.Text);
            com.Parameters.AddWithValue("@uch", textBox1.Text);
            com.Parameters.AddWithValue("@obj", textBox2.Text);
            com.Parameters.AddWithValue("@proj", textBox3.Text);
            com.Parameters.AddWithValue("@komu", textBox5.Text);
            com.Parameters.AddWithValue("@kto", textBox6.Text);
            com.Parameters.AddWithValue("@data", label10.Text);
            com.Parameters.AddWithValue("@id", label12.Text);
 
            int ui = com.ExecuteNonQuery();
            conn.Close();
            conn.Open();

private OleDbConnection connection;
        private DataSet DC;
        private OleDbDataAdapter adapter1;
        private OleDbDataAdapter adapter2;
        DataSet ds = new DataSet();
 
 
 
        private void Form2_Load(object sender, EventArgs e)
        {
            OleDbDataAdapter mydata = new OleDbDataAdapter();
            
            DataTable dt = new DataTable();
            OleDbConnection conn;
            ConnectionStringSettings constring = ConfigurationManager.ConnectionStrings["autocnstr"];
            conn = new OleDbConnection(constring.ConnectionString);
            adapter1 = new OleDbDataAdapter("SELECT * from zayvka WHERE status = 0", conn);
            var res = adapter1.Fill(ds);
            dt = ds.Tables[0];
            dataGridView1.DataSource = dt.DefaultView;