asp.net remove apostrophe from parameterized query

Asked Nov 05 '13 at 09:43

Active Nov 05 '13 at 10:16

Viewed 71 times

MySqlParameter[] sqlParams = new MySqlParameter[] 
    { new MySqlParameter { ParameterName = "@ParameterValue", Value = someValue} };

actual value of someValue is ('1', '2', '3', '4')

but when it goes through parameterized query the value turns to '('1\',\'2\',\'3\',\'4\')'

How can I remove '\' or prevent parameterized query from producing '\'?

edited Nov 05 '13 at 10:16

Keren Caelen

asked Nov 05 '13 at 09:43

Seehyung Lee

Do you mean that `someValue` is an array of characters? You haven't given the SqlDbType in your parameter constructor, so we can't tell what you intend it to be from looking at it. – Andrew Morton Nov 05 '13 at 09:51
It's a string ('1', '2', '3', '4') – Seehyung Lee Nov 05 '13 at 09:52

0 Answers0