In C# I want to save one row of datagridview into SQL database after entire row is filled.

See more:

C#

I want to save automatically datagridview row after that grid fully filled by user.
Already binded that gridview with my sql database file.

What I have tried:

For that I wrote one code in datagridview_RowLeave event. but error is coming.
here is my code

private void dataGridView1_RowLeave(object sender, DataGridViewCellEventArgs e)
       {
           if (e.ColumnIndex == 5)
           {

               con.Open();
               SqlCommand insert = new SqlCommand("insert into invtempdb (fullname, quantity, itmbyp, itmprimary, itmtotal) values(@a,@b,@c,@d,@e)", con);

               insert.Parameters.Add("@a", dataGridView1.CurrentRow.Cells[1]);
               insert.Parameters.Add("@b", dataGridView1.CurrentRow.Cells[2]);
               insert.Parameters.Add("@c", dataGridView1.CurrentRow.Cells[3]);
               insert.Parameters.Add("@d", dataGridView1.CurrentRow.Cells[4]);
               insert.Parameters.Add("@e", dataGridView1.CurrentRow.Cells[5]);
               insert.ExecuteNonQuery();
               //con.Close();

               insert.ExecuteNonQuery();

               MessageBox.Show("value saved");
           }
           else
           {
               MessageBox.Show("Not Saved");
           }
       }