Help with SQL in VB.NET

Have a different question to ask? Start New Discussion Reply to this Discussion 3 Hours Ago 0

Hey Guys,

I'm working on a practice Project at the moment where I'm recalling user information from a database, placing it into a form with several textBoxes, comboBoxes, etc and then proceeding to update the information in the database when the user clicks save. I understand this is simple, however snippets I've seen (and I probably haven't searched properly) show how to update one column in the table. I'm using VB.NET 2010 and SQL CE

An example of what I've found is below, which replaces a single entry.

Dim SQLCmd As New SqlCommand("UPDATE tblQuestion SET Answer