Copy the contents of a datagrid back to an sqlite database table

See more:

C#

I am making a small database front end and I have a datagridview that so far I have made to load the contents of my table with the below code.

I now need to make it so that and changes in the datagridview are saved back to the database table.

I want to do this in its own method so that I can easily call it from different places (i want a save button that carries out the method but then also will look to have it save in some other places)

What is the most efficient was of copying the changes in the datagrid view back?

What I have tried:

<pre>private void button1_Click(object sender, EventArgs e)
        {
            //Load Main Table
            SQLiteConnection dbConnectionString;
            dbConnectionString = new SQLiteConnection(@"Data Source = F:\Omega\Drawing Register\DRDB.sqlite; Version = 3");
            dbConnectionString.Open();
            string sql = "SELECT * FROM Jobs";
            SQLiteCommand command = new SQLiteCommand(sql, dbConnectionString);
            var sqlDataAdapt = new SQLiteDataAdapter(sql, dbConnectionString);
            using (DataTable dt = new DataTable())
            {
                sqlDataAdapt.Fill(dt);
                dataGridView1.DataSource = dt;

                //Set Font
                dataGridView1.Font = new Font("MS Sans Serif", 8);
                //Set Column Widths
                dataGridView1.Columns[0].Width = 100;
                //Set Column Names
                dataGridView1.Columns[0].HeaderText = "Enq No";

            }

        }