Problem with the Parsing XML

See more:

VB

ASP.NET

XML

SQL

Hope you guys can help me in this one.

I am trying to create a web service using that will return and display an xml document that has been populated using an SQL query.

Below is my current code.

Imports System.Web
Imports System.Web.Services
Imports System.Web.Services.Protocols
Imports System.Data.SqlClient
Imports System.Xml
Imports System.Data
Imports System
Imports System.Collections.Generic
Imports System.Linq

' To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
' <system.web.script.services.scriptservice()> _
<webservice(namespace:> _
<webservicebinding(conformsto:> _
<global.microsoft.visualbasic.compilerservices.designergenerated()> _
Public Class RetrieveJobs
     Inherits System.Web.Services.WebService

    <webmethod()> _
    Public Function HelloWorld() As String
        Return "Hello World"
    End Function

    <webmethod()> _
    Public Function GetUserInfo() As XmlDocument
        Dim xml As String = ""
        Dim xmlDoc As New XmlDocument()

        Try
            Using con As New SqlConnection(ConfigurationManager.ConnectionStrings("PeopleConnectionString").ConnectionString)
                con.Open()
                Dim query As String = "SELECT * FROM sysdba.USERINFO FOR XML RAW ('USERINFO'), ROOT ('USERINFO'), ELEMENTS"

                Dim cmd As New SqlCommand(query, con)

                Dim dr As SqlDataReader = cmd.ExecuteReader()
                If dr.Read() Then
                    xml = dr(0).ToString()
                End If
                con.Close()
            End Using
        Catch generatedExceptionName As Exception
        End Try

        xmlDoc.LoadXml(xml)

        Return xmlDoc

    End Function

End Class

This code is heavily based on the following post - http://www.ashishblog.com/blog/how-to-create-and-return-xml-document-from-a-web-service-c-net/[^]

The problem I have is that an error is thrown up when testing it in Visual Studio 2010 stating 'Unexpected end of file while parsing Name has occurred. Line 1, position 2034.'

Does anyone know what it means?
Is this a suitable way of creating an XML file from an SQL query?

Any help would be appreciated.
Cheers