Saving Xml Data into database without using dataset

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
Hi,
I downloaded a complex xml file from a remote server and I need to insert data in the xml into data base.
When I tried reading xml into dataset, it throws error which says "Nested table "TABLENAME" which inherits its namespace cannot have multiple parent tables in different namespaces." I know this issue. I assume, I cannot use dataset with this type of
xml file.
Instead of using dataset, in which way I could achieve this task? Can anyone explain me steps to follow or details.
Thanks in advance
P.S. I use VS2010 .net4 C# windows forms.
Please find the xml here.<br/>
<div style="color:black; background-color:white
<pre><span style="color:blue <<span style="color:#a31515 response<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 success<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 MsRps <span style="color:red xmlns<span style="color:blue =<span style="color:black "<span style="color:blue urn:testsample<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 MesRes<span style="color:blue >
<ack xmlns="
<span style="color:blue <<span style="color:#a31515 code<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 code<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 info<span style="color:blue >OK<span style="color:blue </<span style="color:#a31515 info<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 data<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 SSR <span style="color:red xmlns<span style="color:blue =<span style="color:black "<span style="color:blue urn:sample1<span style="color:black " <span style="color:red xmlns:caccs<span style="color:blue =<span style="color:black "<span style="color:blue urn:sample2<span style="color:black " <span style="color:red xmlns:cbccs<span style="color:blue =<span style="color:black "<span style="color:blue urn:sample3<span style="color:black " <span style="color:red xmlns:xsi<span style="color:blue =<span style="color:black "<span style="color:blue http://www.w3.org/2001/XMLSchema-instance<span style="color:black " <span style="color:red xsi:schemaLocation<span style="color:blue =<span style="color:black "<span style="color:blue urn:locationsample<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 EvnId<span style="color:blue >6.2<span style="color:blue </<span style="color:#a31515 EvnId<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 CvnId<span style="color:blue >4<span style="color:blue </<span style="color:#a31515 CvnId<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 PRN<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 cbccs<span style="color:blue :<span style="color:#a31515 IeBool<span style="color:blue >false<span style="color:blue </<span style="color:#a31515 cbccs<span style="color:blue :<span style="color:#a31515 IeBool<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LRRG<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 cbc<span style="color:blue :<span style="color:#a31515 NtId <span style="color:red xmlns:cbc<span style="color:blue =<span style="color:black "<span style="color:blue urn:test1<span style="color:black "<span style="color:blue >0130211371<span style="color:blue </<span style="color:#a31515 cbc<span style="color:blue :<span style="color:#a31515 NtId<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 cbccs<span style="color:blue :<span style="color:#a31515 HNQBool<span style="color:blue >true<span style="color:blue </<span style="color:#a31515 cbccs<span style="color:blue :<span style="color:#a31515 HNQBool<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 caccs<span style="color:blue :<span style="color:#a31515 HgQl<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 cbccs<span style="color:blue :<span style="color:#a31515 HgQlCode<span style="color:blue >14<span style="color:blue </<span style="color:#a31515 cbccs<span style="color:blue :<span style="color:#a31515 HgQlCode<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 caccs<span style="color:blue :<span style="color:#a31515 HgQl<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LRRG<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 EldPRN<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 caccs<span style="color:blue :<span style="color:#a31515 SDENLGn<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 cbc<span style="color:blue :<span style="color:#a31515 SrDate <span style="color:red xmlns:cbc<span style="color:blue =<span style="color:black "<span style="color:blue urn:test2<span style="color:black "<span style="color:blue >2009-09-01<span style="color:blue </<span style="color:#a31515 cbc<span style="color:blue :<span style="color:#a31515 SrDate<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 caccs<span style="color:blue :<span style="color:#a31515 EtySt<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 cbc<span style="color:blue :<span style="color:#a31515 EtCode <span style="color:red xmlns:cbc<span style="color:blue =<span style="color:black "<span style="color:blue urn:test3<span style="color:black "<span style="color:blue >20199<span style="color:blue </<span style="color:#a31515 cbc<span style="color:blue :<span style="color:#a31515 EtCode<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 caccs<span style="color:blue :<span style="color:#a31515 EtySt<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 caccs<span style="color:blue :<span style="color:#a31515 ENLpd<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 caccs<span style="color:blue :<span style="color:#a31515 ItnalYLl<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 cbc<span style="color:blue :<span style="color:#a31515 ItnalYLlCode <span style="color:red xmlns:cbc<span style="color:blue =<span style="color:black "<span style="color:blue urn:test4<span style="color:black "<span style="color:blue >8<span style="color:blue </<span style="color:#a31515 cbc<span style="color:blue :<span style="color:#a31515 ItnalYLlCode<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 caccs<span style="color:blue :<span style="color:#a31515 ItnalYLl<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 caccs<span style="color:blue :<span style="color:#a31515 ENLpd<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 caccs<span style="color:blue :<span style="color:#a31515 SDENLGn<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 caccs<span style="color:blue :<span style="color:#a31515 EldInSvc<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 caccs<span style="color:blue :<span style="color:#a31515 Sl<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 cbc<span style="color:blue :<span style="color:#a31515 PdrID <span style="color:red xmlns:cbc<span style="color:blue =<span style="color:black "<span style="color:blue urn:test5<span style="color:black "<span style="color:blue >1337<span style="color:blue </<span style="color:#a31515 cbc<span style="color:blue :<span style="color:#a31515 PdrID<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 caccs<span style="color:blue :<span style="color:#a31515 Sl<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 caccs<span style="color:blue :<span style="color:#a31515 EldInSvc<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 EldPRN<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 PRN<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 SSR<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 SatAtd <span style="color:red xmlns<span style="color:blue =<span style="color:black "<span style="color:blue urn:test6<span style="color:black " <span style="color:red xmlns:caccs<span style="color:blue =<span style="color:black "<span style="color:blue urn:test7<span style="color:black " <span style="color:red xmlns:cbccs<span style="color:blue =<span style="color:black "<span style="color:blue urn:nn:test8<span style="color:black " <span style="color:red xmlns:xsi<span style="color:blue =<span style="color:black "<span style="color:blue http://www.w3.org/2001/XMLSchema-instance<span style="color:black " <span style="color:red xsi:schemaLocation<span style="color:blue =<span style="color:black "<span style="color:blue urn:test9.xsd<span style="color:black "<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 EvnId<span style="color:blue >6.2<span style="color:blue </<span style="color:#a31515 EvnId<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 CvnId<span style="color:blue >6<span style="color:blue </<span style="color:#a31515 CvnId<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 PRN<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LRRG<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 cbc<span style="color:blue :<span style="color:#a31515 NtId <span style="color:red xmlns:cbc<span style="color:blue =<span style="color:black "<span style="color:blue urn:test9<span style="color:black "<span style="color:blue >0130211371<span style="color:blue </<span style="color:#a31515 cbc<span style="color:blue :<span style="color:#a31515 NtId<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 LRRG<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 CurrentSDENL<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 caccs<span style="color:blue :<span style="color:#a31515 ENLpd<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 cbccs<span style="color:blue :<span style="color:#a31515 PHDCV<span style="color:blue >1<span style="color:blue </<span style="color:#a31515 cbccs<span style="color:blue :<span style="color:#a31515 PHDCV<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 cbccs<span style="color:blue :<span style="color:#a31515 JAHCV<span style="color:blue >1<span style="color:blue </<span style="color:#a31515 cbccs<span style="color:blue :<span style="color:#a31515 JAHCV<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 cbccs<span style="color:blue :<span style="color:#a31515 UnJAHCV<span style="color:blue >1<span style="color:blue </<span style="color:#a31515 cbccs<span style="color:blue :<span style="color:#a31515 UnJAHCV<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 caccs<span style="color:blue :<span style="color:#a31515 ENLpd<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 CurrentSDENL<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 PRN<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 SatAtd<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 D<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 ack<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 MesRes<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 MsRps<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 success<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 response<span style="color:blue >
[/code]

<br/>

View the full article
 
Back
Top