Return XML To Response.write From SQL XML Type

Hi,

I am trying to retrive some XML from my SQL server 2005 database. The XML is in a table called "myxml" and it is being stored a native XML. The Field type is "XML". The VB code returns nothing when I select SELECT xml. How ever if i SELECT NAME it displays the correct name from the name field. how do I return the XML to be viewed as XML throught the response.write?

 Thanks!

Here is my Table definition:




Column Name
Data Type
Allow Nulls

Id
Int
 

xml
xml
Yes

NAME
Nvarchar(50)
yes

My XML that is stored in the XML field:
<ROOT>
<CHAPTER>
<TITLE>This is a test</TITLE>
</CHAPTER>
</ROOT> 

Here is my VB code:

   Dim myconnection As SqlConnection
Dim mycommand As SqlCommand
myconnection = New SqlConnection()
myconnection.ConnectionString = _
ConfigurationManager.ConnectionStrings("myxmlConnectionString2").ConnectionString

Dim strSQL As String = "SELECT [xml] FROM myxml WHERE id = 76"

' create SQL command instance
mycommand = New SqlCommand(strSQL, myconnection)

Try
' open database connection
myconnection.Open()
'execute T-SQL command
Dim dr = mycommand.ExecuteReader()
While dr.read()
Response.Write("<p>" & dr(0).ToString() & "</p>")
End While
Response.Write("GOT IT")

Catch ex As Exception
Response.Write(ex.Message)
Response.Write(strSQL)
Response.End()


End Try
' Close connection
myconnection.Close()