' transform SQL xml and VIEW
        Try

    Dim myconnection As Data.SqlClient.SqlConnection
            myconnection = New Data.SqlClient.SqlConnection()
            myconnection.ConnectionString = _
            ConfigurationManager.ConnectionStrings("MYCMSConnectionString5").ConnectionString
    Dim strSQL As String = "SELECT xmldata FROM MYTABLE"
    Dim dbComm As New Data.SqlClient.SqlCommand(strSQL, myconnection)

            myconnection.Open()

    Dim myXR = dbComm.ExecuteXmlReader()

    Dim sb As New StringBuilder()
            While myXR.read()
                sb.Append(myXR.readouterxml())
            End While

    Dim xml As String = sb.ToString()

    Dim finxml As String = sb.ToString()
    Dim xmldoc As New XmlDocument
            xmldoc.LoadXml(xml)

    Dim stWrite As StringWriter = New StringWriter()
    Dim xslt As New XslCompiledTransform()

            xslt.Load(Server.MapPath("xslt/myxslt.xslt"))

            xslt.Transform(xmldoc, Nothing, stWrite)
            Response.Write(stWrite.ToString())


            dbComm.Dispose()
        Catch ex As Exception
            Response.Write(Err.Description)
        End Try