I created a web service(.NET) which returns a dataset. I save its output as
XML file.
Question: How can I import it to a database or a file.

XML Source seems not working(successful, but not get anything from XML file).

Any clue? Thanks!


Here is xml(you can create a web service to get a similar format):

<?xml version="1.0" encoding="utf-8"?>
<DataSet xmlns="http://msdn.compuware.com/">
<xs:schema id="NewDataSet" xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true"
msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Employee">
<xs:complexType>
<xs:sequence>
<xs:element name="LoginId" type="xs:string" minOccurs="0" />
<xs:element name="Title" type="xs:string" minOccurs="0" />
<xs:element name="RowGuid" msdataataType="System.Guid,
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
type="xs:string" minOccurs="0" />
<xs:element name="HireDate" type="xs:dateTime" minOccurs="0"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
<NewDataSet xmlns="">
<Employee diffgr:id="Employee1" msdata:rowOrder="0">
<LoginId>adventure-works\rob0</LoginId>
<Title>Senior Tool Designer</Title>
<RowGuid>59747955-87b8-443f-8ed4-f8ad3afdf3a9</RowGuid>
<HireDate>1998-01-05T00:15:18-05:00</HireDate>
</Employee>
<Employee diffgr:id="Employee2" msdata:rowOrder="1">
<LoginId>adventure-works\gail0</LoginId>
<Title>Design Engineer</Title>
<RowGuid>ec84ae09-f9b8-4a15-b4a9-6ccbab919b08</RowGuid>
<HireDate>1998-02-06T00:00:00-05:00</HireDate>
</Employee>
<Employee diffgr:id="Employee3" msdata:rowOrder="2">
<LoginId>adventure-works\jossef0</LoginId>
<Title>Design Engineer</Title>
<RowGuid>e39056f1-9cd5-478d-8945-14aca7fbdcdd</RowGuid>
<HireDate>1998-02-24T00:00:00-05:00</HireDate>
</Employee>
<Employee diffgr:id="Employee4" msdata:rowOrder="3">
<LoginId>adventure-works\dylan0</LoginId>
<Title>Research and Development Manager</Title>
<RowGuid>4f46deca-ef01-41fd-9829-0adab368e431</RowGuid>
<HireDate>1999-03-12T00:00:00-05:00</HireDate>
</Employee>
<Employee diffgr:id="Employee5" msdata:rowOrder="4">
<LoginId>adventure-works\ovidiu0</LoginId>
<Title>Senior Tool Designer</Title>
<RowGuid>f68c7c19-fac1-438c-9bb7-ac33fcc341c3</RowGuid>
<HireDate>2001-01-05T00:00:00-05:00</HireDate>
</Employee>
<Employee diffgr:id="Employee6" msdata:rowOrder="5">
<LoginId>adventure-works\michael8</LoginId>
<Title>Senior Design Engineer</Title>
<RowGuid>46286ca4-46dd-4ddb-9128-85b67e98d1a9</RowGuid>
<HireDate>2001-01-30T00:00:00-05:00</HireDate>
</Employee>
<Employee diffgr:id="Employee7" msdata:rowOrder="6">
<LoginId>adventure-works\sharon0</LoginId>
<Title>Design Engineer</Title>
<RowGuid>54f2fdc0-87c4-4065-a7a8-9ac8ea624235</RowGuid>
<HireDate>2001-02-18T00:00:00-05:00</HireDate>
</Employee>
</NewDataSet>
</diffgr:diffgram>
</DataSet>