Just as a follow-up, what I gave you works fine for one result set.
Not to complicate matters, but if you have a stored proc that returns multiple result sets and you want to set the table names, you'll probably want to do something more elaborate.
Bonnie talked about this in Message #
943069.
Also, Cathi Gero has a blog entry where she talks about multiple result sets in the same DataAdapter...
http://blogs.prenia.com/cathi/PermaLink.aspx?guid=1b6e47c0-a58e-4e6f-bad7-ab11124820e6Depending on what you're doing, you may not need these right now - but they may be helpful to you down the road. Something to read when you have some time. ;)
Kevin
