Sounds wierd but I actually haven't that much data access in 2003 or 2005....but what I did do in 2003 was along the lines of....
i) create typed dataset with multiple tables + relations etc. ii) write stored procedures that would fill in the whole dataset based on different criteria..... e.g. 2 tables... Owners, Dogs Select Owners.* From Owners where Owners.Name = @param1 Select Dogs.* From Dogs INNER JOIN owners ON .... and Owners.Name = @param1 now in 2005, things seem to have migrated to a slightly more table gateway oriented sort of thing. it's as if we're now supposed to incrementally populate datatables one by one.....I'm not sure if this makes sense though in the context of a dataset. =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
