Advertisement
Ortund

Untitled

Feb 27th, 2014
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 0.32 KB | None | 0 0
  1. Dim conn As New SqlConnection(connectionString)
  2.  
  3. Dim sql As String = "update table1 set value1 = @value where pkvalue = @pk"
  4. Dim cmd As New SqlCommand(sql, conn)
  5.  
  6. cmd.Parameters.AddWithValue("@value", TextBox1.Text)
  7. cmd.Parameters.AddWithValue("@pk", primaryKeyValue)
  8.  
  9. conn.Open()
  10. cmd.ExecuteNonQuery()
  11. conn.Close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement