'------------------------------------
'程序将XML的内容添加到cboList列表框
Public Sub funGetXmlList( _
ByVal strText As String, _
ByVal strSingName As String, _
ByVal strTagName As String, _
ByVal intIndex As Integer, _
ByRef objName As Object)
If Run_Mode = -1 Then
On Error GoTo hidden
End If
Dim i As Integer
Dim strTmp As String
Dim xmlDoc As MSXML2.DOMDocument40
Set xmlDoc = New MSXML2.DOMDocument40
Dim objNode As IXMLDOMElement
Dim NodeList As IXMLDOMNodeList
'加载XML数据到XML文挡对象
xmlDoc.async = False
xmlDoc.Load (strText) '如果直接读文件这样写
objName.Clear
'取得发送信息
Set objNode = xmlDoc.selectSingleNode("//" & strSingName)
If Not objNode Is Nothing Then
Set NodeList = objNode.getElementsByTagName(strTagName)
For i = 0 To NodeList.length - 1
objName.AddItem (NodeList.Item(i).childNodes(intIndex).Text)
Next
End If
Set objNode = Nothing
Set NodeList = Nothing
Exit Sub
hidden:
MsgBox Err.Description, vbOKOnly, "提示"
On Error Resume Next
Set objNode = Nothing
Set NodeList = Nothing
Err.Clear
End Sub
Private Sub Command1_Click()
'向列表框添加个人信息只姓名
Call funGetXmlList("c:/xml.xml", "资料", "个人信息", 0, cboList)
End Sub
读多条记录添加到comboBox中
Public Sub funGetXmlList( _
ByVal strText As String, _
ByVal strSingName As String, _
ByVal strTagName As String, _
ByVal intIndex As Integer, _
ByRef objName As Object)
If Run_Mode = -1 Then
On Error GoTo hidden
End If
Dim i As Integer
Dim strTmp As String
Dim objNode As IXMLDOMElement
Dim NodeList As IXMLDOMNodeList
'加载XML数据到XML文挡对象
xmlDoc.async = False
xmlDoc.loadXML (strText)
objName.Clear
'取得发送信息
Set objNode = xmlDoc.selectSingleNode("//" & strSingName)
If Not objNode Is Nothing Then
Set NodeList = objNode.getElementsByTagName(strTagName)
For i = 0 To NodeList.length - 1
objName .AddItem (NodeList.Item(i).childNodes(intIndex).Text)
Next
End If
Set objNode = Nothing
Set NodeList = Nothing
Exit Sub
hidden:
MsgBox Err.Description, vbOKOnly, "提示"
On Error Resume Next
Set objNode = Nothing
Set NodeList = Nothing
Err.Clear
End Sub