如何通过Windows服务解析XML文件并将数据从XML文件加载到SQL Server DB [英] How to parse XML file through windows service and load the data from XML file to SQL server DB

问题描述

开发人员，我有一个复杂的XML文件，应该在Windows服务中解析并填充SQL Server数据库中的数据。任何人都建议我如何执行此任务，我需要参考链接与示例示例用于解析Windows服务中的XML文件的C＃代码，并使用SQL Server Connection将数据导入数据库。我的示例XML文件如下所示。

Hi, Developers, I am having a Complex XML file which should be parsed in the Windows Service and populate the data in the SQL Server DataBase.Can anyone suggest me how to do this task and I need reference link with sample example with C# code to parse XML file in Windows Service and import the data into the DB with SQL Server Connection.My Sample XML file is below.

<pre><?xml version="1.0"?>

<!-- MAS Release 7.0 ( build: Jan 22 2010 19:12:10 ) -->

-<AMRDEF CreationTime="2013-08-09 00:18:42" version="7.0" Purpose="AMRDataRequest">


-<MeterReadings Purpose="OnRequestRead" CollectionTime="2013-08-09 19:57:11" Initiator="OnRequest" SourceIrn="30" SourceName="coll_0591_stuart" Source="Remote" Irn="21">

<Meter MediaType="900 MHz" ObservesDaylightSavings="true" TimeZoneOffset="300" Timezone="(GMT-05:00) Eastern Time (US & Canada)" TimeZoneIndex="11" Location="" SdpIdent="" AccountName="" AccountIdent="" RemovalDate="" InstallDate="2013-05-01 20:28:09" Description="" MeterType="REX" SerialNumber="03310266" IsActive="true" MeterName="03310266" MeterIrn="21"/>


-<ConsumptionData>

<ConsumptionSpec Multiplier="1" MeasurementPeriod="EndOfIntervalSnapshot" TouBucket="Total" Direction="Delivered" UOM="kWh"/>

<Reading Value="73180" TimeStamp="2013-08-09 00:00:00"/>

</ConsumptionData>


-<ConsumptionData>

<ConsumptionSpec Multiplier="1" MeasurementPeriod="EndOfIntervalSnapshot" TouBucket="Total" Direction="Received" UOM="kWh"/>

<Reading Value="0" TimeStamp="2013-08-09 00:00:00"/>

</ConsumptionData>


-<LoadProfileSummary>

<Channel Multiplier="0.1" Direction="Delivered" UOM="kWh" SumOfIntervalValues="155316.3" ReadingRangeEndTimestamp="2013-08-09 00:00:00" ReadingRangeStartTimestamp="2013-08-02 00:00:00" FirstIntervalTimestamp="2013-08-02 00:15:00" NumIntervalsRead="675" IntervalSeconds="900"/>

<Channel Multiplier="0.1" Direction="Received" UOM="kWh" SumOfIntervalValues="0" ReadingRangeEndTimestamp="2013-08-09 00:00:00" ReadingRangeStartTimestamp="2013-08-02 00:00:00" FirstIntervalTimestamp="2013-08-02 00:15:00" NumIntervalsRead="675" IntervalSeconds="900"/>

</LoadProfileSummary>


-<IntervalData>

<IntervalSpec Multiplier="0.1" Direction="Delivered" UOM="kWh" TimestampEnd="2013-08-09 00:00:00" TimestampStart="2013-08-02 00:15:00" Channel="1" Interval="15"/>


-<Reading TimeStamp="2013-08-02 00:15:00" RawReading="229.8">

<QualityFlags TestMode="1"/>

</Reading>


-<Reading TimeStamp="2013-08-02 00:30:00" RawReading="999999">

<QualityFlags TestMode="1" PulseOverflow="1"/>

</Reading>


-<Reading TimeStamp="2013-08-02 00:45:00" RawReading="999999">

<QualityFlags TestMode="1" PulseOverflow="1"/>

</Reading>


-<Reading TimeStamp="2013-08-02 01:00:00" RawReading="999999">

<QualityFlags TestMode="1" PulseOverflow="1"/>

</Reading>


-<Reading TimeStamp="2013-08-02 01:15:00" RawReading="999999">

<QualityFlags TestMode="1" PulseOverflow="1"/>

</Reading>


-<Reading TimeStamp="2013-08-02 01:30:00" RawReading="228.99">

<QualityFlags TestMode="1" PulseOverflow="1"/>

</Reading>

<Reading TimeStamp="2013-08-02 01:45:00" RawReading="230.2"/>

<Reading TimeStamp="2013-08-02 02:00:00" RawReading="230.3"/>

<!--<Reading TimeStamp="2013-08-02 02:15:00" RawReading="229.9" /> <Reading TimeStamp="2013-08-02 02:30:00" RawReading="230.3" /> <Reading TimeStamp="2013-08-02 02:45:00" RawReading="229.9" />-->


<Reading TimeStamp="2013-08-02 03:00:00" RawReading="230.3"/>

<Reading TimeStamp="2013-08-02 03:15:00" RawReading="229.9"/>

<Reading TimeStamp="2013-08-02 03:30:00" RawReading="230.3"/>

<Reading TimeStamp="2013-08-02 03:45:00" RawReading="229.9"/>

<Reading TimeStamp="2013-08-02 04:00:00" RawReading="230.4"/>

<Reading TimeStamp="2013-08-02 04:15:00" RawReading="229.8"/>

<Reading TimeStamp="2013-08-02 04:30:00" RawReading="230.1"/>

。



我尝试了什么：



我无法获得此任务的正确参考链接。

.

What I have tried:

I am unable to get correct reference links to this task.

推荐答案

Windows服务 - 用C＃创建基本的Windows服务 [ ^ ]



xml - 通过XMLDocument和XDocument解析XML文档 [ ^ ]



sql - 初学者指南，通过C＃访问SQL Server [ ^ ]

windows service - Creating a Basic Windows Service in C#[^]

xml - Parse XML Documents by XMLDocument and XDocument[^]

sql - Beginners guide to accessing SQL Server through C#[^]

这篇关于如何通过Windows服务解析XML文件并将数据从XML文件加载到SQL Server DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！