TableAdapter and Multiple Result Sets
Posted by: The Visual Basic Team,
on 13 Mar 2007 |
View original | Bookmarked: 0 time(s)
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 calls DataAdapter.Fill() to retrieve data from database. And DataSet.Fill() method allows you to retrieve multiple result sets from a stored procedure....