Insert into sql from datagrid c#

Question

Insert into sql from datagrid c# I have existing datagrid (non-sql)...(id, price, name, quantity) I need from that datagrid insert value in (account) table in sql (id, price, name, quantity) Some help?

Goran Bibic · Answer

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." ); }

Insert into sql from datagrid c#

Answers (1)