vb.net代码更新数据库

Imports System.Data.SqlClient

Public Sub UpdateDatabase()
    Dim connectionString As String = "YourConnectionStringHere"
    Dim sqlQuery As String = "UPDATE YourTable SET ColumnName = @Value WHERE ConditionColumn = @ConditionValue"

    Using connection As New SqlConnection(connectionString)
        Dim command As New SqlCommand(sqlQuery, connection)
        command.Parameters.AddWithValue("@Value", "NewValue")
        command.Parameters.AddWithValue("@ConditionValue", "ConditionValue")

        Try
            connection.Open()
            Dim rowsAffected As Integer = command.ExecuteNonQuery()
            Console.WriteLine("Rows affected: " & rowsAffected)
        Catch ex As Exception
            Console.WriteLine("Error updating database: " & ex.Message)
        Finally
            connection.Close()
        End Try
    End Using
End Sub