当前位置：首页技术文章正文

关于.net：使用c#读取XML内部子节点 | 珊瑚贝

01-05 技术文章 508

Reading XML inner child node using c#

我正在尝试在 c# 中读取 xml。我能够读取节点 \\’ArrayOfCruisePriceSummaryResponse\\’ 但我如何读取内部节点。

1
2
3
4
5
6
7

XmlNodeList xmlnode;
xmlnode = xml.GetElementsByTagName(“CruisePriceSummaryResponse”);

for (int i = 0; i <= xmlnode.Count – 1; i++)
{

}

使用 GetElementsByTagName 我可以到达该节点，但我如何读取内部孩子。我想从 BestFare 和 FullFare 中读取 TotalPrice 每个孩子有两个内在孩子 BestFare 和 FullFare，我需要读取每个 TotalPrice .

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63

<ArrayOfCruisePriceSummaryResponse
xmlns:i=“http://www.w3.org/2001/XMLSchema-instance”
xmlns=“http://schemas.datacontract.org/2004/07/OpenseasAPI.ServiceModel”>
<CruisePriceSummaryResponse>
<AvailablePromos
xmlns:d3p1=“http://schemas.microsoft.com/2003/10/Serialization/Arrays”>
<d3p1:string>FLA</d3p1:string>
<d3p1:string>FLB</d3p1:string>
</AvailablePromos>
<Brand>PA</Brand>
<CruiseCategory i:nil=“true”/>
<RoomSize>
<CruisePriceSummaryRoomSize>
<BestFare>
<TotalPrice>2798.0000000</TotalPrice>
</BestFare>
<FullFare>
<TotalPrice>3198.000000</TotalPrice>
</FullFare>
<PaxCount>2</PaxCount>
</CruisePriceSummaryRoomSize>
<CruisePriceSummaryRoomSize>
<BestFare>
<TotalPrice>2796.000000</TotalPrice>
</BestFare>
<FullFare>
<TotalPrice>4196.000000</TotalPrice>
</FullFare>
<PaxCount>4</PaxCount>
</CruisePriceSummaryRoomSize>
</RoomSize>
<ShipCode>PD</ShipCode>
</CruisePriceSummaryResponse>
<CruisePriceSummaryResponse>
<AvailablePromos
xmlns:d3p1=“http://schemas.microsoft.com/2003/10/Serialization/Arrays”>
<d3p1:string>FLA</d3p1:string>
<d3p1:string>LF1</d3p1:string>
</AvailablePromos>
<Brand>PA</Brand>
<RoomSize>
<CruisePriceSummaryRoomSize>
<BestFare>
<TotalPrice>1298.000000</TotalPrice>
</BestFare>
<FullFare>
<TotalPrice>3498.000000</TotalPrice>
</FullFare>
<PaxCount>2</PaxCount>
</CruisePriceSummaryRoomSize>
<CruisePriceSummaryRoomSize>
<BestFare>
<TotalPrice>1796.000000</TotalPrice>
</BestFare>
<FullFare>
<TotalPrice>5396.000000</TotalPrice>
</FullFare>
<PaxCount>4</PaxCount>
</CruisePriceSummaryRoomSize>
</RoomSize>
<ShipCode>PJ</ShipCode>
</CruisePriceSummaryResponse>
</ArrayOfCruisePriceSummaryResponse>

P.S 我不想使用 LINQ，因为我正在使用 VS2008 处理 SSIS 项目，它不支持 LINQ。

你介意使用 XmlSerializer 吗？

您可以使用各种 SelectNode 变体来遍历文档并提取数据。

试试这个：

1
2
3
4
5
6
7
8
9
10
11
12
13
14

XmlNodeList xmlnodes;
xmlnodes = xml.GetElementsByTagName(“CruisePriceSummaryResponse”);

for (int i = 0; i < xmlnodes.Count; i++)
{
XmlNodeList rooms = xmlnodes[i].SelectNodes(“RoomSize/CruisePriceSummaryRoomSize”);
for(int j = 0; j < rooms.Count; j++)
{
string bestFare = rooms[j].SelectSingleNode(“BestFare/TotalPrice”).InnerText;
string fullFare = rooms[j].SelectSingleNode(“FullFare/TotalPrice”).InnerText;

// do whatever you need
}
}

您可能想在此处查找有关 XPath 位置的信息。

谢谢@Amit。我收到错误 System.Xml.XmlNodeList does not contain a definition for SelectNodes 我声明 XmlDocument xml = new XmlDocument();然后 XmlNodeList rooms = xml.SelectNodes(“RoomSize/CruisePriceSummaryRoomSize”);。但这是返回 0 值
@OwaisAhmed – 没错，我忘记了访问器 ([i])。你的命名方案让我很困惑，所以我重命名了变量并添加了缺失的部分。

来源：https://www.codenong.com/33118388/

微信公众号

手机浏览(小程序)

Warning: get_headers(): SSL operation failed with code 1. OpenSSL Error messages: error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed in /mydata/web/wwwshanhubei/web/wp-content/themes/shanhuke/single.php on line 57

Warning: get_headers(): Failed to enable crypto in /mydata/web/wwwshanhubei/web/wp-content/themes/shanhuke/single.php on line 57

Warning: get_headers(https://static.shanhubei.com/qrcode/qrcode_viewid_9001.jpg): failed to open stream: operation failed in /mydata/web/wwwshanhubei/web/wp-content/themes/shanhuke/single.php on line 57

0

分享到：