Is there an easy way of Response writing the value contained within each 
  item in an OleDb parameter collection? Using a For each loop for example?

Thanks in advance,

Yes, you could use an IEnumerator e.g.

        Dim a As New OleDbCommand
        Dim b As IEnumerator = a.Parameters.GetEnumerator
        While b.MoveNext
            '... y.Current gets the current item
        End While

Or, you could use the Index of each parameter e.g.

        Dim c As New OleDbCommand
        For d As Integer = 0 To (c.Parameters.Count - 1)
            '... c.Parameters.Item(d) gets the current item
        Next

How about something like this:

Dim cmd As System.Data.OleDb.OleDbCommand
For Each param As System.Data.OleDb.OleDbParameter In cmd.Parameters
      Response.write(param.Value)
Next


Steve C.
MCAD,MCSE,MCP+I,CNE,CNA,CCNA


DC wrote:

> Is there an easy way of Response writing the value contained within each 
>  item in an OleDb parameter collection? Using a For each loop for example?
> 
> Thanks in advance,

Cheers Steve, that worked like a charm.

Steve wrote:

> How about something like this:
> 
> Dim cmd As System.Data.OleDb.OleDbCommand
> For Each param As System.Data.OleDb.OleDbParameter In cmd.Parameters
>      Response.write(param.Value)
> Next