TableAdapter and Multiple Result Sets
Several people asked me whether TableAdapter can be used to retrieve multiple result sets from stored procedures. The quick answer is... No, you can't do that with TableAdapter.Fill() method that gets generated as a part of Typed Dataset. But there's a very simple work-around. DataAdapter.Fill() & Multiple Result Sets TableAdapter.Fill() method...