Lets say I have a search page with a grid that I want to populate with fields from 3 different objects, but that I only want a subset of the fields for each object. How do I use WORM to create a query that will return a dataset/xml from this query. I won't be able to return an object because the data I will be returning won't be of any object type that I've created.

-meppum

If you're willing to take the performance hit for a more OO design and you have small objects and a small number of objects being returned, you might be able to create a property on your main object that just passes through to the object which has the property you need. Then you can bind the grid to the object collection.

For example, suppose you have an Invoice object which a Customer object.  You could add a CustomerName property to Invoice like so:

Public ReadOnly Property CustomerName() As String
   Get
      Return Me.Customer.Name
   End Get
End Property

--Bill Daly