[RESOLVED]text box to database

[srisa]

Hello,
When writing a value in a textbox to the database, if there is a single quote as part of the textbox, an error is occuring. I mean if text1.text=vb's then , for writing it to database ,sql we would be something like this:
" INSERT INTO mytable (name) values ( '" & text1.text & "')".
This would evaluate to
"INSERT INTO mytable (name) values ('vb's')".
So , is there any workaround to include single quotes in the text values to be stored in the database? If yes, how?
Thank you.