This question already has an answer here:
- Parse xml data into an array in C# 3 answers
Below given is the xml file in which I have to read the element inside <expression> tag(EG:-Branch.Country) and store it in the array.
<queries> <query name="Query1"> <source> <model/> </source> <selection> <dataItem name="Country" aggregate="none" rollupAggregate="none"> <expression>[Sales (query)].[Branch].[Country]</expression> <XMLAttributes> <XMLAttribute name="RS_dataType" value="3" output="no"/> <XMLAttribute name="RS_dataUsage" value="attribute" output="no"/> </XMLAttributes> </dataItem> <dataItem name="Product line" aggregate="none" rollupAggregate="none"> <expression>[Sales (query)].[Products].[Product line]</expression> <XMLAttributes> <XMLAttribute name="RS_dataType" value="3" output="no"/> <XMLAttribute name="RS_dataUsage" value="attribute" output="no"/> </XMLAttributes> </dataItem> <dataItem name="Quantity" aggregate="total"> <expression>[Sales (query)].[Sales].[Quantity]</expression> <XMLAttributes> <XMLAttribute name="RS_dataType" value="1" output="no"/> <XMLAttribute name="RS_dataUsage" value="fact" output="no"/> </XMLAttributes> </dataItem> <dataItem name="Revenue" aggregate="total"> <expression>[Sales (query)].[Sales].[Revenue]</expression> <XMLAttributes> <XMLAttribute name="RS_dataType" value="2" output="no"/> <XMLAttribute name="RS_dataUsage" value="fact" output="no"/> </XMLAttributes> </dataItem> <dataItemListSummary refDataItem="Quantity" aggregateMethod="total" name="Total(Quantity)"/> <dataItemListSummary refDataItem="Revenue" aggregateMethod="total" name="Total(Revenue)"/> <dataItemListSummary refDataItem="Quantity" aggregateMethod="total" name="Total(Quantity)2"/> <dataItemListSummary refDataItem="Revenue" aggregateMethod="total" name="Total(Revenue)1"/> </selection> </query> </queries>
No comments:
Post a Comment