带有if语句vb.net的SQL参数

Dim query As String = "SELECT * FROM Customers WHERE Country = @Country"

Using connection As New SqlConnection(connectionString)
    Using command As New SqlCommand(query, connection)
        ' 创建SqlParameter对象
        Dim countryParam As New SqlParameter("@Country", SqlDbType.NVarChar, 50)
        
        ' 使用if语句设置参数值
        If condition Then
            countryParam.Value = "China"
        Else
            countryParam.Value = "USA"
        End If
        
        ' 将参数添加到SqlCommand对象的Parameters集合中
        command.Parameters.Add(countryParam)
        
        ' 执行SQL查询
        connection.Open()
        Dim reader As SqlDataReader = command.ExecuteReader()
        
        ' 处理查询结果
        While reader.Read()
            ' 处理每一行数据
        End While
        
        reader.Close()
    End Using
End Using