Store data from datagridview to sql tables

using (SqlConnection con = new SqlConnection("server=localhost;Database =primus; integrated Security = true"))
{
for (int i = 0; i < dtgartikuj.Rows.Count; i++)
{
{
SqlCommand cmdeditimi = new SqlCommand("updatestoku", con);
cmdeditimi.CommandType = CommandType.StoredProcedure;

cmdeditimi.Parameters.Add(new SqlParameter("@barkodi", Convert.ToString(dtgartikuj.Rows[i].Cells[0].Value)));
cmdeditimi.Parameters.Add(new SqlParameter("@sasia", Convert.ToString(dtgartikuj.Rows[i].Cells[2].Value)));

con.Open();
cmdeditimi.ExecuteNonQuery();
con.Close();

}
{
SqlCommand cmd = new SqlCommand("insertfaturimi", con);
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add(new SqlParameter("@idfatura", Int64.Parse(txtnrfatures.Text)));
cmd.Parameters.Add(new SqlParameter("@klienti", cmbklienti.Text));
cmd.Parameters.Add(new SqlParameter("@shenime", txtshenime.Text));
cmd.Parameters.Add(new SqlParameter("@nrartikujve", Int64.Parse(lblnumri.Text)));
cmd.Parameters.Add(new SqlParameter("@vleratvsh", Double.Parse(textBox1.Text)));
cmd.Parameters.Add(new SqlParameter("@nentotali", Double.Parse(txttotali.Text)));
cmd.Parameters.Add(new SqlParameter("@zbritje", Double.Parse(txtzbritja.Text)));
cmd.Parameters.Add(new SqlParameter("@totali", Double.Parse(totali.Text)));
cmd.Parameters.Add(new SqlParameter("@kasieri", lbluser.Text));
cmd.Parameters.Add(new SqlParameter("@koha", DateTime.Now));
cmd.Parameters.Add(new SqlParameter("@pagesa", faturimi));
cmd.Parameters.Add(new SqlParameter("@barkodi", Convert.ToString(dtgartikuj.Rows[i].Cells[0].Value)));
cmd.Parameters.Add(new SqlParameter("@emertimi", Convert.ToString(dtgartikuj.Rows[i].Cells[1].Value)));
cmd.Parameters.Add(new SqlParameter("@sasia", Convert.ToString(dtgartikuj.Rows[i].Cells[2].Value)));
cmd.Parameters.Add(new SqlParameter("@tvsh", Convert.ToString(dtgartikuj.Rows[i].Cells[3].Value)));
cmd.Parameters.Add(new SqlParameter("@cmimi", Convert.ToString(dtgartikuj.Rows[i].Cells[4].Value)));
cmd.Parameters.Add(new SqlParameter("@totalipcs", Convert.ToString(dtgartikuj.Rows[i].Cells[5].Value)));
cmd.Parameters.Add(new SqlParameter("@vlerapatvshpcs", Convert.ToString(dtgartikuj.Rows[i].Cells[6].Value)));
cmd.Parameters.Add(new SqlParameter("@vleraetvshpcs", Convert.ToString(dtgartikuj.Rows[i].Cells[7].Value)));

con.Open();
cmd.ExecuteNonQuery();
con.Close();

}
}
}
clear();
}