ExamGuru IT/.Net Guru : Help Getting XML Doc from SQL 2000 on ASPFriends.com 'aspngxml' list

.NETGURU

Help Getting XML Doc from SQL 2000

Messages

Related Types

This message was discovered on ASPFriends.com 'aspngxml' list.

Little, Ambrose

I know this is probably really simple, but the answer eludes me. All I want
to do is get a well-formed XML document from a SQL Server 2000 FOR XML query
and turn it into a string. What is the easiest way to do this?

Thanks!

--Ambrose

******************************************************************************
The Company reserves the right to amend statements
made herein in the event of a mistake. Unless expressly
stated herein to the contrary, only agreements in writing signed
by an authorized officer of the Company may be enforced against it.
*******************************************************************************

Reply to this message...

Dan Wahlin

Call the SqlCommand object's ExecuteXmlReader() method. Once you have
the reader you can move to the content and then call the ReadOuterXml()
to get a string representation. If you want to work with the XML
directly you could load the reader into a DataSet, XmlDocument, etc.

HTH,
Dan Wahlin

Wahlin Consulting LLC
Microsoft MVP - ASP.NET
http://www.XMLforASP.NET
XML for ASP.NET Developers by Dan Wahlin in bookstores everywhere!

-----Original Message-----
From: Little, Ambrose [mailto:Click here to reveal e-mail address]
Sent: Tuesday, July 16, 2002 1:43 PM
To: aspngxml
Subject: [aspngxml] Help Getting XML Doc from SQL 2000

I know this is probably really simple, but the answer eludes me. All I
want
to do is get a well-formed XML document from a SQL Server 2000 FOR XML
query
and turn it into a string. What is the easiest way to do this?

Thanks!

--Ambrose

************************************************************************
******
The Company reserves the right to amend statements
made herein in the event of a mistake. Unless expressly
stated herein to the contrary, only agreements in writing signed
by an authorized officer of the Company may be enforced against it.
************************************************************************
*******

| [aspngxml] member Click here to reveal e-mail address = YOUR ID
| http://www.asplists.com/asplists/aspngxml.asp = JOIN/QUIT
| http://www.asplists.com/search = SEARCH Archives

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.373 / Virus Database: 208 - Release Date: 07/01/2002

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.373 / Virus Database: 208 - Release Date: 07/01/2002

Reply to this message...

Little, Ambrose

Thanks, Dan. I've got your book, but the section on SQL Server 2000 and
ADO.NET does not give this particular example (and I haven't had time to
read the whole thing yet). I did try this and it does get the first element
(i.e., the first record), but only the first. I'm guessing this may have
something to do with the fact that FOR XML does not return a root element?
Is there a way to wrap all of the records (elements) into a root one and
read them all at once using the GetOuterXml?

TIA,

--Ambrose

[Original message clipped]

******************************************************************************
The Company reserves the right to amend statements
made herein in the event of a mistake. Unless expressly
stated herein to the contrary, only agreements in writing signed
by an authorized officer of the Company may be enforced against it.
*******************************************************************************

Reply to this message...

	System.Data.DataSet
	System.Data.SqlClient.SqlCommand
	System.Xml.XmlDocument

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification