VB.Net循环遍历SQL和Log + Value中的每个参数

Question

我可以循环遍历SQL中的每个参数，但是如何记录参数名和值？

Public  Sub LogParams(sqlcmd As SqlCommand)
        Dim strParam As String = ""
        For Each p As SqlParameter In sqlcmd.Parameters
             strParam +=      'how to get Name and Value of parameter?
        Next p
End Sub

Answer 1

你可以把它当作

For Each p As SqlParameter In sqlcmd.Parameters
    'p.ParameterName
    'p.Vaalue
Next p