XML

B

Bob

How do I use a SQL Server query that has the "for xml auto" syntax?

I'm using C#...but how does C# get to use the results?

Anybody know?

Bob Sweeney
 
N

Nicholas Paldino [.NET/C# MVP]

Bob,

Given a SqlCommand, you can call the ExecuteXmlReader method to get an
XmlReader which you can get the results of.

If for some reason you can't call that, I believe that a one row, one
column result set will be returned where the xml is in that single
row/column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing Offsetting XML Nodes 5
Store XML/XSD in SQL Server 2008 3
Query data (SELECT * FROM table) from XML File 9
Can't connect to SQL 2005 4
How to use the xml sql server datatype with c# 1
SQL XML Result 2
Console Mode argument access 3
XML and SQL database 3

Top