473,405 Members | 2,185 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

URGENT HELP needed in creating xml from xsd schema

3
Hi all, I need urgent help with an xml issue. Let me explain the scenario:
My VB.NET app needs to read an xml (e.g. Sales Orders). This xml contains say 10 sales orders. Next the app needs to split the original xml into 10 individual SalesOrder xml files, each file containing a single sales order. The xml files created must be created based on a set xsd schema.See example below:
Here I have 2 sales orders in my original xml, I want to create 1 xml file for each Sales order.
e.g. <Sales Order>
<DocNum>"1234"</DocNum>
<ItemCode>"321"</ItemCode>
<DocDate>20070215</DocDate>
<Qty>1</Qty>
<Amount>$1500.00</Amount>
</Sales Order>
<Sales Order>
<DocNum>"1234"</DocNum>
<ItemCode>"321"</ItemCode>
<DocDate>20070215</DocDate>
<Qty>1</Qty>
<Amount>$1500.00</Amount>
</Sales Order>

Here are list of my issues:
1) Easier way to extract individual SalesOrders from the original xml: I can extract the inner text of all e.g. "DocNum" nodes in the original xml etc, but there must an easier way to extract all the childnodes inner text per SalesOrder node. (i.o.w. DocNum,ItemCode,DocDate,Qty,Amount together)

2) How to write the extracted xml information into an xml file based on a provided xsd file/schema.

I've been strugling for a week to find clear information on this and have been unsuccesfull thus far.
Any help would be greatly appreciated!
Thank you for your time
Feb 15 '07 #1
1 1527
shweta123
692 Expert 512MB
Hi,

Plase refer

this

There is information for both your questions.

Shweta
Feb 15 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Wolfgang Lipp | last post by:
my question is: do we need container elements for repeating elements in data-centric xml documents? or is it for some reason very advisable to introduce containers in xml documents even where not...
0
by: Jeremy Summers | last post by:
Has anyone run into problems creating typed datasets from complex schemas? I am attempting to create a Typed Dataset in Visual Studio .Net from a .xsd schema file for a industry standard web...
3
by: Kiran | last post by:
Hi, I want to back up my data in some table in SQL server and import it back using Bulk Load of SQL server 2K. I can use the following code to backup the data in XML ...
3
by: Mae | last post by:
Dear All, I have a problem here, I'm using C# Webform calling a webservices. The webservices return me a XMLnode, using this XMLnode I want to convert it to dataset so I can bind to the...
3
by: Sindarian | last post by:
I have a Schema from the folk that shows how they want the data received. I have my own database that has that data, but in a different way (they use 33 freaking tables to store what I do in 1)....
3
by: N. Spiker | last post by:
I am attempting to receive a single TCP packet with some text ending with carriage return and line feed characters. When the text is send and the packet has the urgent flag set, the text read from...
3
by: JMD | last post by:
A set of xsd files has been working fine for us at this site, but now it gives *intermittent* errors for someone at a different cite (who is consuming the code we are producing). Most of the time...
1
by: ah123 | last post by:
Hi guys, I am resonably new to XSD so I appologise if my question is simple. I am attempting to use an XSD to validate my XML document which previously used a DTD for validation. The problem is that...
1
by: kwartz | last post by:
Can someone please explain with examples to me 1. How storage parameters are select for a locally managed tablespace. 2. Creating appropriate indexes for a schema. 3. how to tune the database for...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.