DaniWeb IT Discussion Community - View Single Post

Re: Update Command in Vb.net

Oct 12th, 2008

Enclose text field values in quotes:

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
Dim strSQL As String = ("UPDATE Staff SET StaffName = ['" & _
  namebox.Text & "'] ,Address = ['" & addbox.Text & _
  "'] ,Phone = ['" & phone & "'] ,JobPosition = ['" & _
  posbox.Text & "'] ,JobStat = ['" & genId & _
  "']  WHERE SID='" & id.Text & "'")
Dim strSQL As String = ("UPDATE Staff SET StaffName = ['" & _
  namebox.Text & "'] ,Address = ['" & addbox.Text & _
  "'] ,Phone = ['" & phone & "'] ,JobPosition = ['" & _
  posbox.Text & "'] ,JobStat = ['" & genId & _
  "']  WHERE SID='" & id.Text & "'")

If SID field is numeric, remove quotes from it.

Teme64 @ Windows Developer Blog