Hello all, I have a TypedList with 4 fields. I Need those 4 fields to filter Data. However, I Need to get a Distinct on only 2 fields with the Fill Method. How could I do this ?

Thanx a lot !

Hi Carlos,

So, you want to filter on 4 fields but the resulset will have just 2 distinct fields? I think you can accomplish that easily with a DynamicList

DISTINCT is always per row, as most db's do distinct filtering per complete row, not per set of fields.

Thank you verry much. Can I import any DLL to get the DataAccessAdapter Class in the SelfServicing template to build my DynamicList ?

Thanx again ...

Carlos wrote:

Thank you verry much. Can I import any DLL to get the DataAccessAdapter Class in the SelfServicing template to build my DynamicList ?

Thanx again ...

You can create DynamicLists in SelfServicing as well. Here is the manual's link. All that classes (both Adapter and SelfServicing) are contained in the ORMSupportClasses assembly