Question How to Sanitize textboxes for mysql commands

Noremacam

Member
Joined
Jun 30, 2008
Messages
14
Programming Experience
1-3
Hello, I'm a noob when it comes to programming with mysql(I understand databases, but I don't really understand the sql syntax very well).

I'm creating a database application, and I want to UPDATE a row with all the fields from various textboxes. How do I sanitize the strings from the textboxes and then put them into the mysql update command? I couldn't find any assistance with regards to sanitizing in vb.net online.

In my example, lets say I want to update a row's LastName and FirstName with the contents from txtLastName and txtFirstName with people who have the user_id=1.

Any help would be enormously appreciated!
 
Last edited:
Back
Top