I prefer to use stored procedures over having sql statements sitting in my
.NET code.

My problem is I can not figure out how get .NET to understand there are
multiple recordsets coming back.  Each of the recordsets is returning xml
data and if called individually would be called as :

Dim myCmd as SqlCommand=New SqlCommand("ae_RegGetShow",myCnct)
myDataSet.ReadXml(myCmd.ExecuteXmlReader(), XmlReadMode.Fragment)

The stored procedure has something like the following

selet * from table1 as show for xml auto,xmldata
select * from table2 as options for xml,xmldata

Any thoughts or suggest?

Cheers
Keith