Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Dim conn As New SqlConnection(connectionString)
- Dim sql As String = "update table1 set value1 = @value where pkvalue = @pk"
- Dim cmd As New SqlCommand(sql, conn)
- cmd.Parameters.AddWithValue("@value", TextBox1.Text)
- cmd.Parameters.AddWithValue("@pk", primaryKeyValue)
- conn.Open()
- cmd.ExecuteNonQuery()
- conn.Close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement