By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,041 Members | 1,046 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,041 IT Pros & Developers. It's quick & easy.

XMLReader vs Multi tables

P: n/a
Hi,
Does XMLReader supports multi tables returned from a SQL Server Stored
Procedure?

Ex:

Begin

Select 1 ..
FOR XML AUTO
Select 2...
FOR XML AUTO
Select 3...
FOR XML AUTO

End

Thanks for your help,
--
Sylvain Audet - MCP+SB
Visitez les astuces .NET sur dotNET-fr.org
http://www.dotnet-fr.org/sections.ph...ticles&secid=6
Nov 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Thanks for your reply David,
How can I retrieve a particular table then? Right now, I am able to
retrieve the XML stream but I am only able to navigate one record (node) at
a time just like if it was ONE table alone, and it seems to me that there
are no way to navigate through the tables directly.

--
Sylvain Audet - MCP+SB
Visitez les astuces .NET sur dotNET-fr.org
http://www.dotnet-fr.org/sections.ph...ticles&secid=6

"Davud Brnch" <bi*******@yahoo.com> wrote in message
news:2F**********************************@microsof t.com...
Yes... it does concatenate is all togather
David

"Sylvain Audet" wrote:
Hi,
Does XMLReader supports multi tables returned from a SQL Server Stored Procedure?

Ex:

Begin

Select 1 ..
FOR XML AUTO
Select 2...
FOR XML AUTO
Select 3...
FOR XML AUTO

End

Thanks for your help,
--
Sylvain Audet - MCP+SB
Visitez les astuces .NET sur dotNET-fr.org
http://www.dotnet-fr.org/sections.ph...ticles&secid=6

Nov 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.