Dynamically generated update statement returns exception when parameter value contains Special Characters

Asked Jan 20 '14 at 06:11

Active Jan 20 '14 at 07:02

Viewed 26 times

I found some similar questions and answers (like this) where people suggested to Search & Replace the single (') with two (''). I just wanted to know, is there any better way to resolve this issue other that doing search & replace? Below are my code blocks:

Stored Procedure
enter image description here

C# Code
enter image description here

Exception
enter image description here

Testing Value
A-A!@#$%^&*()-=+|]}[{;:'"?/.>,<`~

Thanks in advance.

edited May 23 '17 at 12:13

Community

asked Jan 20 '14 at 06:11

vpv

2

Please use textual code instead of picture code where possible. – leppie Jan 20 '14 at 06:53
OK. This is noted.. :) – vpv Jan 20 '14 at 07:28

Dynamically generated update statement returns exception when parameter value contains Special Characters

0 Answers0