Insert into sql from datagrid c#

I try this

Error is

column name or number of supplied values does not match table definition

private void button21_Click(object sender, EventArgs e) //placanje gotovinski
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
using (SqlConnection con = new SqlConnection(cs))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO mp_kasa_roba VALUES(@roba, @kolicina, @cijena_sa_pdv)", con))
{
//cmd.Parameters.AddWithValue("@redni_broj", row.Cells["nazivartikla"].Value);
cmd.Parameters.AddWithValue("@roba", row.Cells["nazivartikla"].Value);
cmd.Parameters.AddWithValue("@kolicina", row.Cells["kolicina"].Value);
cmd.Parameters.AddWithValue("@cijena_sa_pdv", row.Cells["cijena"].Value);
//cmd.Parameters.AddWithValue("@ukupno", row.Cells["ukupno"].Value);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
MessageBox.Show("Records inserted.");
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.