"Dimitre Novatchev" <dnovatchev@yahoo.com> wrote in message
news:bq5jsu$1vb1vf$1@ID-152440.news.uni-berlin.de...
> How is this question related to xml???
>
>
> "Keith Chadwick" <kchadwick@leewardsystems.com> wrote in message
> news:O8OF%23IQtDHA.2408@tk2msftngp13.phx.gbl...
> > 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
> >
> >
>
>

"Keith Chadwick" <kchadwick@leewardsystems.com> wrote in message
news:O8OF%23IQtDHA.2408@tk2msftngp13.phx.gbl...
> 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
>
>