[crickwiz]

insert a new row .For that i use insert command. the problem is For eg:command=new oledbcommand("INSERT INTO table(COL) VALUES(textbox1.text)I get a error. Actually my program is not able to get the value from textbox1.text

[G K]

hi your problem is syntax related.you are about to insert int to field that must be var char type.try thisinsert into table(COL) values('textbook1.text')