Solved

sqlserver query to output xml into asp.net page

Posted on 2013-01-25
2
329 Views
Last Modified: 2013-01-25
Hi!

i Have simple data connection like this

Dim GetDataQry As String = "SELECT * from facilities where ItemID=@ItemId FOR XML PATH"
            Dim cmd As New SqlClient.SqlCommand(GetDataQry, conn)

with a SqlDataReader.

but it outputs only text. not xml as the query requests.
how do i get it to output xml into a asp.net page.
0
Comment
Question by:jamppi
2 Comments
 
LVL 35

Accepted Solution

by:
Robert Schutt earned 305 total points
ID: 38820613
If you're writing this out to the page it could be that the browser is hiding the xml tags as unknown html tags, in that case you could try something like:
Response.Write yourxmlstringvar.Replace("<", "&lt;")

Open in new window

0
 

Author Closing Comment

by:jamppi
ID: 38820809
you got me on right track..  i had to change the document properties to
Response.ContentType = "text/xml"

then i got it right!

/J
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question