How do you see the name and value of a parameter? 1

[emaduddeen]

Hi Everyone,

If I use the following code to create a parameter can you tell me how to extract the parameter name and the parameter value?

objSqlCommand.Parameters.AddWithValue("@MyParam", "CA").DbType = DbType.String

Truly,
Emad

 

[RiverGuy]

Is this what you are looking for?

            objSqlCommand.Parameters("@MyParam").Value
            objSqlCommand.Parameters("@MyParam").ParameterName

 

[emaduddeen]

Hi RiverGuy,

Yes that's what I needed.

Thanks so much.

Here's you code I used:

            ' Write out command parameters and values.
            '-----------------------------------------
            txtResults.Text = txtResults.Text & "Command parameters:" & vbCrLf

            For Each objSqlParameter In .Parameters
                txtResults.Text = txtResults.Text & ControlChars.Tab & _
                objSqlCommand.Parameters("@MyParam").ParameterName & "=" & _
                objSqlCommand.Parameters("@MyParam").Value.ToString & vbCrLf
            Next

Truly,
Emad