如何从xml文件中选择数据 [英] How to select data from xml file

问题描述

我有xml文件，例如:

I have xml file like:

<?xml version="1.0" encoding="utf-8" ?>
<Event>
  <Events id="1" Venu="Venu1">
    <Name>Event1</Name>
    <Title>Title1</Title>
    <Date>2010/4/25</Date>
  </Events><Events id="2">
    <Name>Event2</Name>
    <Title>Title2</Title>
    <Date>2010/4/5</Date>
  </Events><Events id="3">
    <Name>Event3</Name>
    <Title>Title1</Title>
    <Date>2010/4/1</Date>
  </Events><Events id="4">
    <Name>Event3</Name>
    <Title>Title1</Title>
    <Date>2010/4/11</Date>
  </Events><Events id="5">
    <Name>Event3</Name>
    <Title>Title1</Title>
    <Date>2010/5/1</Date>
  </Events><Events id="5">
    <Name>Event3</Name>
    <Title>Title1</Title>
    <Date>2010/5/11</Date>
  </Events>
</Event>

我需要使用xquery或任何其他方法选择事件(例如2006年或2007年的日期)，有帮助吗?
请帮助

I need to select event for example date in 2006 or 2007 using xquery or any other method, any help?
Please help

推荐答案

大家好，

这是获取2006年或2007年活动的最简单方法，有许多不同的获取方法，请遵循此方法.

XDocument xdoc = XDocument.Load("XMLFile1.xml");
if(xdoc.Element("Event")！= null&& xdoc.Element("Event").Elements("Events")！= null&& xdoc.Element("Event").Elements( 事件").Count()> 0)
{
foreach(xdoc.Element("Event").Elements("Events"))中的XElement元素
{
if(ele.Element("Date")！= null&&ele.Element("Date").Value！= null)
{
字符串str = Convert.ToDateTime(ele.Element("Date").Value).ToString("yyyy/MM/dd");
DateTime datetime = Convert.ToDateTime(str);
如果(datetime.Year == 2006 || datetime.Year == 2007)
{
//将此事件存储在变量中以供您使用
}
}
}
}

如果我的回答正确，请投票给我.

Hi All,

This is the easiest way to get the events for 2006 or 2007, there are many different ways to get it, follow this.

XDocument xdoc = XDocument.Load("XMLFile1.xml");
if (xdoc.Element("Event") != null && xdoc.Element("Event").Elements("Events") != null && xdoc.Element("Event").Elements("Events").Count()>0)
{
foreach(XElement ele in xdoc.Element("Event").Elements("Events"))
{
if (ele.Element("Date") != null && ele.Element("Date").Value != null)
{
string str = Convert.ToDateTime(ele.Element("Date").Value).ToString("yyyy/MM/dd");
DateTime datetime = Convert.ToDateTime(str);
if (datetime.Year == 2006 || datetime.Year == 2007)
{
//Store this event in a variable for your purpose
}
}
}
}

If my answer is correct, please vote me.

Dim xdoc As XDocument = XDocument.Load("Events.xml")
        If xdoc.Element("Event") IsNot Nothing AndAlso xdoc.Element("Event").Elements("Events") IsNot Nothing AndAlso xdoc.Element("Event").Elements("Events").Count() > 0 Then
            For Each ele As XElement In xdoc.Element("Event").Elements("Events")
                If ele.Element("Date") IsNot Nothing AndAlso ele.Element("Date").Value IsNot Nothing Then
                    Dim str As String = Convert.ToDateTime(ele.Element("Date").Value).ToString("yyyy/MM/dd")
                    Dim datetime As DateTime = Convert.ToDateTime(str)
                    'Store this event in a variable for your purpose
                    If datetime.Year = 2006 OrElse datetime.Year = 2007 Then
                    End If
                End If
            Next
        End If

Error   2   Type 'XDocument' is not defined.    C:\Users\Iram\Documents\Visual Studio 2008\WebSites\JqueryCalender_XML\Calender2.aspx.vb    36  21  C:\...\JqueryCalender_XML\

im使用vb.net，所以在转换时不是vb.net，这在下一行给了我一个错误

i m using vb.net so in convert it not vb.net its giving me an error on following line

Error   1   Name 'doc' is not declared. C:\Users\Iram\Documents\Visual Studio 2008\WebSites\JqueryCalender_XML\Calender2.aspx.vb    36  39  C:\...\JqueryCalender_XML\

Dim nodeList As XmlNodeList = doc.SelectNodes("//Event/Events")

这篇关于如何从xml文件中选择数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！