Saving apostraphy to sql table (resolved)

[Beast777]

Gonna keep this simple. Got a textbox and a button. CLick on button, insert text into sql table. Now add a apostraphy into text and error occurs, obviously its the apostraphy in the sql syntax.

The .net cmdtext is
"Insert into testtable (testtext) values ( '" & txtTestTextbox.Text & "')"

So if the text is Hello I get a cmdtext of
"Insert into testtable (testtext) values ( 'Hello')"

Now with text of I Don't Know I get a cmdtext of
"Insert into testtable (testtext) values ( 'I Don't Know ')"

even I can see the problem but how do we work around this?