Question

linq to xml 排序

linq to xml 如何对 UserTime 进行排序 我想取出 最后1次写如xml中的数据 根据时间排序
<Root>
<LoginTable pk="a">
<UserName>a</UserName>
<UserPwd>●●</UserPwd>
<UserTime>2011/5/22 22:30:47</UserTime>
</LoginTable>
<LoginTable pk="zhanghao">
<UserName>zhanghao</UserName>
<UserPwd>●●●●</UserPwd>
<UserTime>2011/5/23 9:46:51</UserTime>
</LoginTable>
</Root>

Answer 1

Dim XMLFilePath As String = Request.PhysicalApplicationPath & "/Rules.xml"
Dim XMLValues As XElement = XElement.Load(XMLFilePath)
Dim Values = (From x In XMLValues.Elements() _
Order BY x.Element("UserTime") _
Select New With { _
.UserName = CType(x.Element("UserName"), String), _
.UserTime = CType(x.Element("UserTime"), String)}).FirstOrDefault
取出最后1次写入xml中的数据