LINQ to XML - Elements() 有效，但 Elements(XName) 无效

发布于 2024-11-12 16:50:06 字数 4633 浏览 1 评论 0原文

下面给出的是我的 xml：

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
    <Body>
        <ReportItems>
            <Textbox Name="txtCurrentDate">
                <CanGrow>true</CanGrow>
                <KeepTogether>true</KeepTogether>
                <Paragraphs>
                    <Paragraph>
                        <TextRuns>
                            <TextRun>
                                <Value>=Today()</Value>
                                <Style>
                                    <FontWeight>Medium</FontWeight>
                                    <Format>d</Format>
                                </Style>
                            </TextRun>
                        </TextRuns>
                        <Style>
                            <TextAlign>Left</TextAlign>
                        </Style>
                    </Paragraph>
                </Paragraphs>
                <Left>0.36958in</Left>
                <Height>0.22917in</Height>
                <Width>1in</Width>
                <Style>
                    <Border>
                        <Style>None</Style>
                    </Border>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                </Style>
            </Textbox>
            <Textbox Name="txtName">
                <CanGrow>true</CanGrow>
                <KeepTogether>true</KeepTogether>
                <Paragraphs>
                    <Paragraph>
                        <TextRuns>
                            <TextRun>
                                <Value>Mark Wilkinson</Value>
                                <Style />
                            </TextRun>
                        </TextRuns>
                        <Style />
                    </Paragraph>
                </Paragraphs>
                <Top>0.22917in</Top>
                <Left>0.36958in</Left>
                <Height>0.20833in</Height>
                <Width>3.22917in</Width>
                <ZIndex>1</ZIndex>
                <Style>
                    <Border>
                        <Style>None</Style>
                    </Border>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                </Style>
            </Textbox>
        </ReportItems>
        <Height>6.01667in</Height>
        <Style />
    </Body>
    <Width>7.92333in</Width>   
</Report>

我想获取所有 Textbox 名称和值。这是我尝试过的方法，但它不起作用：

XDocument data = XDocument.Load("..\\..\\testxml.rdl");

            var elements = from c in data.Elements("ReportItems")
                           select c;
            foreach (var element in elements)
            {                
                Console.WriteLine("Element : " + element.Attribute("Name").Value);

            }
            Console.ReadKey();

但是当我将查询更改为这样的内容时，

var elements = from c in data.Elements().Elements().ElementAt(0).Elements().ElementAt(0).Elements()
                           select c;

它就起作用了。

非常感谢这方面的任何帮助。

编辑：在答案的帮助下，我能够得到想要的结果。非常感谢你:)

XDocument data = XDocument.Load("..\\..\\testxml.rdl");            
            XNamespace ns = data.Root.Name.Namespace;
            var elements = from c in data.Descendants(ns + "Textbox")
                           select c;
            foreach (var element in elements)
            {                
                Console.WriteLine("Element : " + element.Attribute("Name").Value);                
            }
            Console.ReadKey();

蒂亚。

拉贾

原文

Given below is my xml:

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
    <Body>
        <ReportItems>
            <Textbox Name="txtCurrentDate">
                <CanGrow>true</CanGrow>
                <KeepTogether>true</KeepTogether>
                <Paragraphs>
                    <Paragraph>
                        <TextRuns>
                            <TextRun>
                                <Value>=Today()</Value>
                                <Style>
                                    <FontWeight>Medium</FontWeight>
                                    <Format>d</Format>
                                </Style>
                            </TextRun>
                        </TextRuns>
                        <Style>
                            <TextAlign>Left</TextAlign>
                        </Style>
                    </Paragraph>
                </Paragraphs>
                <Left>0.36958in</Left>
                <Height>0.22917in</Height>
                <Width>1in</Width>
                <Style>
                    <Border>
                        <Style>None</Style>
                    </Border>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                </Style>
            </Textbox>
            <Textbox Name="txtName">
                <CanGrow>true</CanGrow>
                <KeepTogether>true</KeepTogether>
                <Paragraphs>
                    <Paragraph>
                        <TextRuns>
                            <TextRun>
                                <Value>Mark Wilkinson</Value>
                                <Style />
                            </TextRun>
                        </TextRuns>
                        <Style />
                    </Paragraph>
                </Paragraphs>
                <Top>0.22917in</Top>
                <Left>0.36958in</Left>
                <Height>0.20833in</Height>
                <Width>3.22917in</Width>
                <ZIndex>1</ZIndex>
                <Style>
                    <Border>
                        <Style>None</Style>
                    </Border>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                </Style>
            </Textbox>
        </ReportItems>
        <Height>6.01667in</Height>
        <Style />
    </Body>
    <Width>7.92333in</Width>   
</Report>

I want to get all the Textbox names and values. This is what I tried and it does not work:

XDocument data = XDocument.Load("..\\..\\testxml.rdl");

            var elements = from c in data.Elements("ReportItems")
                           select c;
            foreach (var element in elements)
            {                
                Console.WriteLine("Element : " + element.Attribute("Name").Value);

            }
            Console.ReadKey();

but when I change the query to something like this

var elements = from c in data.Elements().Elements().ElementAt(0).Elements().ElementAt(0).Elements()
                           select c;

it works.

Any help in this regard is much appreciated.

Edit: With the help of answers I was able to get the desired results. Thank you so much :)

XDocument data = XDocument.Load("..\\..\\testxml.rdl");            
            XNamespace ns = data.Root.Name.Namespace;
            var elements = from c in data.Descendants(ns + "Textbox")
                           select c;
            foreach (var element in elements)
            {                
                Console.WriteLine("Element : " + element.Attribute("Name").Value);                
            }
            Console.ReadKey();

TIA.

Raja

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

桃扇骨 2024-11-19 16:50:06

您需要考虑命名空间：

XNamespace df = data.Root.Name.Namespace;

然后使用 df + "foo" 在根元素上定义的命名空间中选择具有本地名称 foo 的元素。

正如已经提到的，您可能想要选择后代，而不是子元素：

        var elements = from c in data.Descendants(df + "Textbox")
                       select c;

You need to take the namespace into account:

XNamespace df = data.Root.Name.Namespace;

Then use df + "foo" to select elements with local name foo in the namespace defined on the root element.

And as already mentioned you probably want to select descendants, not child elements:

        var elements = from c in data.Descendants(df + "Textbox")
                       select c;

回复收藏 0 原文

伴我心暖 2024-11-19 16:50:06

在这种情况下，您正在寻找 Descendants() 而不是 Elements()。 Elements() 仅选择直接子级。

文档

XContainer.Descendants 方法 (XName) - 按文档顺序返回此文档或元素的后代元素的过滤集合。集合中仅包含具有匹配 XName 的元素
XContainer.Elements 方法 (XName) - 按文档顺序返回此元素或文档的子元素的过滤集合。集合中仅包含具有匹配 XName 的元素。

注意：根据您的示例代码，使用 Descendants() 仍会引发异常，因为并非所有 ReportItems 元素都有 Name > 属性。您需要执行类似 Console.WriteLine("Element : " + (element.Attributes("Name").Any() ? element.Attribute("Name").Value : "(no name)") 的操作);

回复收藏 0 原文

伏妖词 2024-11-19 16:50:06

 if (openFileDialog1.ShowDialog() == DialogResult.OK)
        {
            filepath = openFileDialog1.FileName;
            try
            {

                XElement xe = XElement.Load(filepath);
              // 

                string sql = "insert OR IGNORE into price_list (name,his_code,specs,unit,spell,price) values(@name,@his_code,@specs,@unit,@spell,@price);";
                int count = 0;
                foreach (XElement el in xe.Descendants("row"))
                {
                    SQLiteParameter[] ps =
                    {
                        new SQLiteParameter("@his_code",el.Element("aka079").Value),
                        new SQLiteParameter("@name",el.Element("aka061").Value),
                        new SQLiteParameter("@specs",el.Element("aka073").Value),
                        new SQLiteParameter("@unit",el.Element("aka067").Value),
                        new SQLiteParameter("@spell",SpellCode.GetSpellCode(el.Element("aka061").Value)),
                        new SQLiteParameter("@price",el.Element("aka071").Value),
                    };

                    if (SqliteHelper.ExecuteNonQuery(sql, ps) > 0)
                    {
                        count++;
                    }

                }

            }
            catch (Exception ex)
            {
                MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message);
            }

只需将 XElements() 更改为 Descendants()，它可能会起作用

 if (openFileDialog1.ShowDialog() == DialogResult.OK)
        {
            filepath = openFileDialog1.FileName;
            try
            {

                XElement xe = XElement.Load(filepath);
              // 

                string sql = "insert OR IGNORE into price_list (name,his_code,specs,unit,spell,price) values(@name,@his_code,@specs,@unit,@spell,@price);";
                int count = 0;
                foreach (XElement el in xe.Descendants("row"))
                {
                    SQLiteParameter[] ps =
                    {
                        new SQLiteParameter("@his_code",el.Element("aka079").Value),
                        new SQLiteParameter("@name",el.Element("aka061").Value),
                        new SQLiteParameter("@specs",el.Element("aka073").Value),
                        new SQLiteParameter("@unit",el.Element("aka067").Value),
                        new SQLiteParameter("@spell",SpellCode.GetSpellCode(el.Element("aka061").Value)),
                        new SQLiteParameter("@price",el.Element("aka071").Value),
                    };

                    if (SqliteHelper.ExecuteNonQuery(sql, ps) > 0)
                    {
                        count++;
                    }

                }

            }
            catch (Exception ex)
            {
                MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message);
            }

just change XElements() to Descendants(),it will work probably

回复收藏 0 原文

~没有更多了~