[RESOLVED] Syntax error in UPDATE statement

[GaryMazzone]

Add this

Try
     Dim ResutlCount As Integer = dbCommand.ExecuteNonQuery()
     MessageBox.Show("Rows Effected: " & ResultCount.ToString()
Catch ex As Exception

     MsgBox(ex.Message, MsgBoxStyle.Critical)
End Try

What is the result in the messagebox.

[shmo888]

Add this

Try
     Dim ResutlCount As Integer = dbCommand.ExecuteNonQuery()
     MessageBox.Show("Rows Effected: " & ResultCount.ToString()
Catch ex As Exception

     MsgBox(ex.Message, MsgBoxStyle.Critical)
End Try

What is the result in the messagebox.

Rows Effected: 0