How to wrap ns0 and xmlns:ns0="http://xxx" to plain XML document

Tech-Archive recommends: Speed Up your PC by fixing your registry



Hi

I have a xml file i need to wrap ns0 and
xmlns:ns0="http://SQLReceiveProject";.
I get a file from my client as this
<Data>
<BB>
<ID>1</ID>
</BB>
<Group>
<Info FirstName="xx" LastName="vv" />
<Info FirstName="yy" LastName="zz" />
</Info>
</Group>
</Data>

while i am trying to insert in SQL above xml file i am getting error.

If i use below xml file it will insert into SQL because ns0 and url is
wrap with this file. This xml file is generated Instance from the
schema.

<ns0:Data xmlns:ns0="http://SQLReceiveProject.Schema1";>
<BB>
<ID>ID</ID>
</BB>
<Group>
<Info>
<FirstName>xx</FirstName>
<LastName>vv</LastName>
</Info>
</Group>
</ns0:Data>

Who to wrap ns0 and url or uri to plain xml file what i have to do. I
gone through some of the article they say to use XML Assembler. i did
not no how it works.

Can any one guide me on this. I will be very greatfuly to them.

thanks
wask

.



Relevant Pages

  • Re: MIDAS/Datasnap Alternative
    ... provider is as simple as adding a provider definition ... We simply send our updated XML file to the server, ... having to click on a query component to open up the SQL property. ... I could perform the following from the client. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: How to wrap ns0 and xmlns:ns0="http://xxx" to plain XML document
    ... while i am trying to insert in SQL above xml file i am getting error. ... If i use below xml file it will insert into SQL because ns0 and url is ... Who to wrap ns0 and url or uri to plain xml file what i have to do. ... custom pipeline component to do so, but that would be much more work (it's ...
    (microsoft.public.biztalk.general)
  • Re: How to wrap ns0 and xmlns:ns0="http://xxx" to plain XML document
    ... Tomas Restrepo wrote: ... while i am trying to insert in SQL above xml file i am getting error. ... Who to wrap ns0 and url or uri to plain xml file what i have to do. ... custom pipeline component to do so, but that would be much more work (it's ...
    (microsoft.public.biztalk.general)
  • XML and SQL database
    ... I have a XML file from the client and I need to insert data from XML to SQL ... how to insert data FROM dataset to database. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: MS patch-scanner for Win-NT, 2K, IIS, SQL
    ... MS patch-scanner for Win-NT, 2K, IIS, SQL ... XML file from the following location - mssecure.xml Possible ... and on a NT 4 Server, but the scanner works fine on a W2K Server ...
    (Focus-Microsoft)