I've got a nice big dataset....under 2003 I had some code derived from the Microsoft code blocks, that did updates....inserts forwards, deletes backwards...so that FK constraints didn't get upset...all in a transaction.....lovely
now 2005.... so I'll just use the same code... no...table adapters don't implement DataAdapter...yes I believe I can go into the designer and update the base class...but thats a real pain, what I like about datasets is that I can pick up the tables from the explorer, dump them on the designer and it writes the code....I don't want to touch that code...ever. Now I could use the table adapters....but wont I get FK constraint problems if I don't do them in the correct order? (in fact there isn't a correct order...because the order for inserts is opposite to that of deletes). P.S. sometimes I think 2005 has stuff that is inferiour to 2003....bizarre. =================================== This list is hosted by DevelopMentorĀ® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com