使用数组循环记录. [英] Looping the Records using Array.

问题描述

我有以下记录作为数组，我需要根据拆分每个记录进行循环.如下所示.

I have following Records as array, I need to loop according to split each records . Like below.

"INSTRUMENT LOW=0.00" ,
OPEN_INTEREST=0. 

请告诉我如何循环和继续.
数组值:

Please advise me how to loop and proced.
Array Value :

"<instruments>

<instrument low="0.00" open_interest="0" volume="0" instrument_id="#UCPSMCRCOSW" trade_datetime="2012-06-18T12:00:00Z" underlier="#UCPSMCRCOSW" high="0.00" open="0.00" close="77.95" />

<instrument low="0.0000" open_interest="0" volume="0" instrument_id="#UCPSMCRCOESA" trade_datetime="2012-06-18T12:00:00Z" underlier="#UCPSMCRCOESA" high="0.0000" open="0.0000" close="73.8167" />

<instrument low="0.00" open_interest="0" volume="0" instrument_id="#UCPSMCRCOES" trade_datetime="2012-06-18T12:00:00Z" underlier="#UCPSMCRCOES" high="0.00" open="0.00" close="72.77" />

<instrument low="0.0000" open_interest="0" volume="0" instrument_id="#UCPNCRAWTSA" trade_datetime="2012-06-18T12:00:00Z" underlier="#UCPNCRAWTSA" high="0.0000" open="0.0000" close="70.2500" />

<instrument low="0.0000" open_interest="0" volume="0" instrument_id="#UCPNCRAWTIA" trade_datetime="2012-06-18T12:00:00Z" underlier="#UCPNCRAWTIA" high="0.0000" open="0.0000" close="74.2500" />

<instrument low="0.0000" open_interest="0" volume="0" instrument_id="#UCPNCRAWOKSA" trade_datetime="2012-06-18T12:00:00Z" underlier="#UCPNCRAWOKSA" high="0.0000" open="0.0000" close="73.7500" />

<instrument low="0.0000" open_interest="0" volume="0" instrument_id="#UCPNCRAKNCMA" trade_datetime="2012-06-18T12:00:00Z" underlier="#UCPNCRAKNCMA" high="0.0000" open="0.0000" close="73.5000" />

<instrument low="0.0000" open_interest="0" volume="0" instrument_id="#UCPNCRAEKANA" trade_datetime="2012-06-18T12:00:00Z" underlier="#UCPNCRAEKANA" high="0.0000" open="0.0000" close="68.2500" />

</instruments>"

推荐答案

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml.Linq;

namespace ConsoleApplication7
{
    class Program
    {
        static void Main(string[] args)
        {
            string xml = @"<instruments>
<instrument low='0.00' open_interest='0' volume='0' instrument_id='#UCPSMCRCOSW' trade_datetime='2012-06-18T12:00:00Z' underlier='#UCPSMCRCOSW' high='0.00' open='0.00' close='77.95' />

<instrument low='0.0000' open_interest='0' volume='0' instrument_id='#UCPSMCRCOESA' trade_datetime='2012-06-18T12:00:00Z' underlier='#UCPSMCRCOESA' high='0.0000' open='0.0000' close='73.8167' />

<instrument low='0.00' open_interest='0' volume='0' instrument_id='#UCPSMCRCOES' trade_datetime='2012-06-18T12:00:00Z' underlier='#UCPSMCRCOES' high='0.00' open='0.00' close='72.77' />

<instrument low='0.0000' open_interest='0' volume='0' instrument_id='#UCPNCRAWTSA' trade_datetime='2012-06-18T12:00:00Z' underlier='#UCPNCRAWTSA' high='0.0000' open='0.0000' close='70.2500' />

<instrument low='0.0000' open_interest='0' volume='0' instrument_id='#UCPNCRAWTIA' trade_datetime='2012-06-18T12:00:00Z' underlier='#UCPNCRAWTIA' high='0.0000' open='0.0000' close='74.2500' />

<instrument low='0.0000' open_interest='0' volume='0' instrument_id='#UCPNCRAWOKSA' trade_datetime='2012-06-18T12:00:00Z' underlier='#UCPNCRAWOKSA' high='0.0000' open='0.0000' close='73.7500' />

<instrument low='0.0000' open_interest='0' volume='0' instrument_id='#UCPNCRAKNCMA' trade_datetime='2012-06-18T12:00:00Z' underlier='#UCPNCRAKNCMA' high='0.0000' open='0.0000' close='73.5000' />

<instrument low='0.0000' open_interest='0' volume='0' instrument_id='#UCPNCRAEKANA' trade_datetime='2012-06-18T12:00:00Z' underlier='#UCPNCRAEKANA' high='0.0000' open='0.0000' close='68.2500' />

</instruments>";

            var list = XElement.Parse(xml).Elements("instrument")
                .Select(x =>
                    new {
                        Name = x.Name,
                        low = x.Attribute("low").Value
                    });

        }
    }
}

这篇关于使用数组循环记录.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！