Printable View
When i add to data base from textbox i have problem and the problem is that in the text have the charachter " ' " "Dont be stupid' be smart", and have error.
How to resolve this error. Can i resolved with replace or another solution.
Tnx to all who help me sry for my bad english and iam beginer at SQL.
That is a common issue, and sooner or later it will probably be followed by other similar ones.. unless you switch from putting values into a string to using parameterised queries, which automatically deal with the ' issue and others.
There are some examples of how to use them in this thread (the code snippets that include the keyword Parameters).