update sql with vb.net 2.0

I'm new to sql and need to update a few columns in 1 row.  I can update a single column, but have not figured out how to do multiple columns.   What do I have wrong?

This works
dbcmd.CommandText = "Update Workstations Set USERNAME='" & strUserName & "' Where NAME='" & testme & "'"

This does not work.
dbcmd.CommandText = "Update Workstations Set USERNAME='" & strUserName & "' Set LOGTYPE='" & strType & "' Set CHECKTIME='" & strDate & "' Where SERIAL='" & testme & "'"

It just tells me there is an error near the "=".  I checked and my column names are correct
chadmanvbAsked:
Who is Participating?
 
Luis PérezSoftware Architect in .NetCommented:
You're failing in the construction of your SQL query.

The UPDATE syntax is like this:
UPDATE [table] SET FIELD1 = value, FIELD2 = value, [...] [WHERE ...]

So you don't need (and in fact it fails for it) to write the "SET"" word for each updated field.

So change your code:
dbcmd.CommandText = "Update Workstations Set USERNAME='" & strUserName & "' Set LOGTYPE='" & strType & "' Set CHECKTIME='" & strDate & "' Where SERIAL='" & testme & "'"

And instead put this:
dbcmd.CommandText = "Update Workstations Set USERNAME='" & strUserName & "', LOGTYPE='" & strType & "', CHECKTIME='" & strDate & "' Where SERIAL='" & testme & "'"

Hope that helps.
0
 
chadmanvbAuthor Commented:
That did it.  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.