Sometime you just want to return some data from the DB to client in XML format. Here is my Function to return an XML doc.
Public Function GetReaderAsXML(ByVal sql As String, ByVal Environment As String, Optional ByRef OtherOraConnection As OracleConnection = Nothing) As XmlDocument
Dim cmdfunc As New OracleCommand
If OtherOraConnection Is Nothing Then
If Not oraConnection.State = ConnectionState.Open Then
Me.ConnectToOracle(Environment)
End If
cmdfunc.Connection = oraConnection
Else
cmdfunc.Connection = OtherOraConnection
End If
cmdfunc.CommandText = sql
cmdfunc.XmlCommandType = OracleXmlCommandType.Query
cmdfunc.BindByName = True
cmdfunc.XmlQueryProperties.MaxRows = -1
Dim XmlReaderOut As System.Xml.XmlReader
XmlReaderOut = cmdfunc.ExecuteXmlReader
Dim XmlDocOut As New System.Xml.XmlDocument
XmlDocOut.PreserveWhitespace = True
XmlDocOut.Load(XmlReaderOut)
Return XmlDocOut
End Function
Thursday, May 1, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment