VB6 RecordSet与XML转换

Public Function SaveRSToXML(ByVal ConnectionString As String,ByVal strSQL As String) As String
    Dim oCn As New ADODB.Connection
    Dim oRs As New ADODB.Recordset
    Dim oStream As New ADODB.Stream
    
    oCn.Open ConnectionString
    oRs.Open strSQL,oCn,adOpenKeyset,adLockReadOnly
    oRs.Save oStream,adPersistXML
    SaveRSToXML = oStream.ReadText
    
    oStream.Close
    Set oStream = Nothing
    
    oRs.Close
    Set oRs = Nothing
    
    oCn.Close
    Set oCn = Nothing
End Function

Public Function RecordsetFromXMLString(ByVal sXml As String) As ADODB.Recordset
    Dim oStream As ADODB.Stream
    Set oStream = New ADODB.Stream
    
    oStream.Open
    oStream.WriteText sXml

    oStream.Position = 0

    Dim oRecordset As ADODB.Recordset
    Set oRecordset = New ADODB.Recordset
       
    oRecordset.Open oStream

    oStream.Close
    Set oStream = Nothing

    Set RecordsetFromXMLString = oRecordset

    Set oRecordset = Nothing
End Function

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!