Updating in Visual Basic

[gregory21]

I'm insert my information into a SQL table, but I wont to make changes to older record if needed. So I begin with an UpDate Statement, but I'm having problem with the code to go through into the SQL Table for in update.


Here's the update code:

"Update [BLL_Program] Set [Number of Problem] = " & TextBox1.Text & " [Problem Type] = '" & ComboBox2.Selec tedText & " where [Day] = '" & NumericUpDown2. Value & "' and [Month] = ' " & NumericUpDown1. Value & "'and [Year] = '" & ComboBox1.Selec tedText & "'")


Thanks.

[Rabbit]

Output the SQL string so you can verify the syntax.