Error inserting

Question

for (int i = 0; i < rows; i++) { values = dataGridView1.Rows[i].Cells[1].Value.ToString(); MessageBox.Show(values); cm.CommandText=insert into check values('+textBox1.Text+''+values+''''');; cm.Connection=cn; MessageBox.Show(cm.CommandText.ToString()); cm.ExecuteNonQuery(); //MessageBox.Show(dataGridView1.Rows[i].Cells[1].Value.ToString()); values = ; } this shows an error on cm.ExecuteNonQuery(); please help asap

Kirtan Patel · Answer

in your Writen Code you Are trying to Store all the Values of Row in One Variable that is not possible take at look here http://www.mediafire.com/?sharekey=2e9d884c2476e3fa7069484bded33bcdbcec3d68ab7f5d53

utsav rathour · Answer

The site says it the file is private and need to login to download. And the insert is not working for other tables too not just check. I'll take a look at it though. And for the datagrid value change thing i looked at another example and added some parrt to your and now it works. Thankx for the help man!!!

Kirtan Patel · Answer

Made Necessary changes to your Print application and Database Now its working fine and Inserts Successfully you must rename the table from check to any other name because check is Reserved word for Database Query Here is the Modified Project http://www.mediafire.com/?idmhkztjtjk Happy Coding :)