View Single Post
Invasive contributor
13Sep2009,12:58  
nimesh's Avatar
yes, you will get an error of Incorrect Syntax, because the Insert statement is not correct.

The correct syntax would be:
1] If you want to insert all values
Code:
"insert into emp values('"+txtid.Text+"','"+txtname.Text+"','"+txtdesig.Text+"','"+txtsal.Text+"','"+txtjoin.Text+"','"+txtadd.Text+"','"+txtjoin.Text+"','"+txtcont.Text+"');";
2] If you want to insert specific values
Code:
"insert into emp(id,name,desig,sal) values('"+txtid.Text+"','"+txtname.Text+"','"+txtdesig.Text+"','"+txtsal.Text+"');";