Skip to content

Instantly share code, notes, and snippets.

@tuldok89

tuldok89/updatesnip.vb

Created March 3, 2012 04:38
Show Gist options
  • Save tuldok89/1964388 to your computer and use it in GitHub Desktop.
Save tuldok89/1964388 to your computer and use it in GitHub Desktop.
Download ZIP
Update Snippet
Raw
updatesnip.vb
cmdUpdate = New OleDb.OleDbCommand
cmdUpdate.Connection = cn
' cmdUpdate.CommandText = "Update Sci_QA_Easy set key = 1 where Question ='" & lblQ.Text & "'"
cmdUpdate.CommandText = "Update Sci_QA_Easy set key = 1 where Question=@question"
cmdUpdate.Parameters.AddWithValue("@question", lblQ.Text)
cmdUpdate.ExecuteNonQuery()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment