XML

  • Thread starter Thread starter Bob
  • Start date Start date
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
 
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.
 
Back
Top