Hi James,

Here is the version of that code converted to VB.NET: 

Public Function GetProducts() As IEnumerable(Of Product)
    Dim products As List(Of Product) = New List(Of Product)

    Using conn = New SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("NORTHWIND").ConnectionString)
        conn.Open()
        Using cmd As New SqlCommand("ProductOrderedByPrice", conn)
            cmd.CommandType = System.Data.CommandType.StoredProcedure
            Using reader = cmd.ExecuteReader()
                While reader.Read()
                    products.Add(New Product() With { _
                       .Code = CInt(reader("ProductID")), _
                       .Price = CDec(reader("UnitPrice")) _
                     })
                End While
            End Using
        End Using
    End Using

    Return products
End Function

As for passing parameters to the stored procedures, the SqlCommand class has a Parameters collection with which you can add your parameters. http://msdn.microsoft.com/en-us/library/yy6y35y8%28v=vs.71%29.aspx