Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

converting invalid query characters

Status
Not open for further replies.
ryebread

ryebread

Programmer
Aug 13, 2001
29
US
Does anybody know of a way to convert characters like ' and " into a format that would be safe to pass into a SQL query?

 
Sort by date Sort by votes
Use Replace(txtName.Text, "'", "''")
Notice, It's two 's instead of " you are going to replace '.
Hope this answers your question.
 
Upvote 0 Downvote
I solved my problem. I used a SqlCommand object and passed all my variables in using parameters.

Thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

stinkybee
  • Locked
  • Question
Replace ’ characters from string
Replies
5
Views
324
stinkybee
stinkybee
primagic
  • Locked
  • Question
'Dropdown list' has a SelectedValue which is invalid because it does not exist in the list of items
Replies
4
Views
152
jbenson001
jbenson001
stinkybee
  • Locked
  • Question
Display the value of a QueryStringParameter in my ListView
Replies
1
Views
81
jbenson001
jbenson001
primagic
  • Locked
  • Question
CONVERSION ERROR: Code could not be converted. Details: -- line 1 col 9: invalid TypeDecl
Replies
7
Views
116
jbenson001
jbenson001
mmy1981
  • Locked
  • Question
asp.net + crystal reports: problem with date fields query
Replies
4
Views
86
mmy1981
mmy1981

Part and Inventory Search

Sponsor

Back
Top