Updating database vb

Rated 3.90/5 based on 967 customer reviews

And your answer (compared to OP's code) is wide open for SQL injection!

Execute Non Query() if i Welcome to Stack Overflow! Hint: 4 leading spaces in a line indicate code formatting.

You need to add the third parameter value, but I don't know where that comes from.

I agree with the suggestions to use a parameter query for this instead.

Thanks in advance, Richard Paulicelli You can also convert your date string to yyyy-mm-dd format to avoid misinterpreting the date literal based on local.

Also wrap command and connections in using statements so they are properly disposed when you are done with them.

Currenlty above the readability lack, its confusing.

Leave a Reply