How to insert Access data in more than three tables from the “datagridview” control?

Hi

Just simple example

rivate void button3_Click(object sender, EventArgs e)
        {



            using (OleDbConnection connection = new OleDbConnection("constring"))
            {
                if (connection.State != ConnectionState.Open)
                {
                    connection.Open();
                }
                using (OleDbTransaction trans = connection.BeginTransaction())
                {

                    try
                    {
                        foreach (DataGridViewRow item in dataGridView1.Rows)
                        {
                            OleDbCommand cmdCommon = new OleDbCommand();
                            cmdCommon.CommandText = "Your first table insert query";
                            cmdCommon.ExecuteNonQuery();

                            cmdCommon.CommandText = "Your second table isnert query";
                            cmdCommon.ExecuteNonQuery();
                          
                        }
                        trans.Commit();
                    }
                    catch (Exception ex)
                    {
                        trans.Rollback();
                        throw ex;
                    }
                }
            }
        }

You can read value from the every row and make query and pass to command.

thank you