Private Sub Command1_Click()
        Text1.Text = ddd(" * from set_car  ")
        '去掉以下三行注释后就转化为文本格式
        'Set x = New MSXML2.DOMDocument40
        'x.loadXML Text1.Text
        'Text1.Text = x.childNodes(1).Text
End Sub

Function ddd(aa As String) As String
    Dim QuerStr As String
    QuerStr = aa 'aa  为查询语句 不带SELECT 
    Dim strxml As String
    strxml = "<?xml version='1.0' encoding='utf-8'?>"
    strxml = strxml & "<soap:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'>"
    strxml = strxml & "<soap:Body>"  
    strxml = strxml & "<QueryRtn xmlns='http://tempuri.org/'>"    
    strxml = strxml & "<sQuerString>" & QuerStr & "</sQuerString>"
    strxml = strxml & "</QueryRtn>"
    strxml = strxml & "</soap:Body>"
    strxml = strxml & "</soap:Envelope>"
   
    Dim h As MSXML2.ServerXMLHTTP40
    Dim x As MSXML2.DOMDocument40
    Set x = New MSXML2.DOMDocument40
    x.loadXML strxml
    Set h = New MSXML2.ServerXMLHTTP40
   
    h.open "POST", "http://www.fenjin.com/CZGPSService/FJCZGPS.asmx", HTTP / 1.1
    h.setRequestHeader "Content-Type", "text/xml"
    h.setRequestHeader "Host", "www.fenjin.com"
    h.setRequestHeader "SOAPAction", "http://tempuri.org/QueryRtn"
    h.send (strxml)
    ddd = h.responseText
    '格式化XML格式
    ddd = Replace(ddd, "><", ">" & vbCrLf & "<")
End Function

posted on 2006-04-14 17:27  拉登·闸  阅读(335)  评论(2)    收藏  举报