不确定如何更新单个客户记录。VB.net

Imports System.Data.SqlClient

Public Sub UpdateCustomerRecord(customerID As String, column1Value As String, column2Value As String)
    Dim connectionString As String = "YourConnectionString"
    
    Using connection As New SqlConnection(connectionString)
        connection.Open()
        
        Dim sql As String = "UPDATE Customers SET Column1 = @Column1Value, Column2 = @Column2Value WHERE CustomerID = @CustomerID"
        
        Dim cmd As New SqlCommand(sql, connection)
        cmd.Parameters.AddWithValue("@Column1Value", column1Value)
        cmd.Parameters.AddWithValue("@Column2Value", column2Value)
        cmd.Parameters.AddWithValue("@CustomerID", customerID)
        
        cmd.ExecuteNonQuery()
    End Using
End Sub