Loading

Escaping single quotes and double quotes in a String

aidin

I have a textbox in wich users can put there input. I want this String to be escaped of strange characters, single quotes and double quotes. Since I don't want my SQL query to crash, with bad user input. Is there a standard function for this in .NET ? In PHP with mysql you have the mysql_escape_string() method is there a similar method in .Net ? Keyboard

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

aidin23y ago
Thanx a lot !
+1
Tanvir Huda23y ago
i think replace specific occurance of character or string in string string s=@"replaceing ' with value"; s=s.Replace("'"," "); MessageBox.Show(s); it replace the "'" with " " It works
+1