Solved

To put together an xml file...

Posted on 2014-10-19
4
141 Views
Last Modified: 2014-10-20
I have the following text:
What this project does?

It uses the following stored procedures to add, update, and delete customers and/ or orders.

1. spAddCustomerOptionallyWithOrder
   First adds the customer, then if order information is also supplied, adds updates order related tables.

2. spUpdateCustomer
   Uplades changes to customer fields and also checks for concourency error.
   
3. spDeleteCustomer
   First deletes any orders this customer may have and then deletes the customer itself.

4. spDeleteOrderItem
   It deletes the composite primary key SoftwareID and OrderID from tblOrderDetails. Then it checks to see if
   there are no other records in this table with the same OrderID. If there were none, it deletes the same record from tblOrders as well.
 
5. spAddOrderToExistingCustomer
   First it adds a new OrderDate (which defuals to todays date). Then, It captures the auto generated OrderID to
   add it to tblOrderDetails along with SoftwareID and its matching quantity to complete the process.

6. spAddNewSoftwareTitles
   It opens a popup form to get Title, Description, and UnitPrice data from the user.

Open in new window


I want to put these lines in an xml file. Later, its content will be read and displayed on a winform.

Question: Could you please help me to put this xml file together?

Thanks.
0
Comment
Question by:Mike Eghtebas
  • 2
4 Comments
 
LVL 35

Accepted Solution

by:
mccarl earned 350 total points
ID: 40391317
See below for xml file with your lines in it...
<content>
<![CDATA[What this project does?

It uses the following stored procedures to add, update, and delete customers and/ or orders.

1. spAddCustomerOptionallyWithOrder
   First adds the customer, then if order information is also supplied, adds updates order related tables.

2. spUpdateCustomer
   Uplades changes to customer fields and also checks for concourency error.
   
3. spDeleteCustomer
   First deletes any orders this customer may have and then deletes the customer itself.

4. spDeleteOrderItem
   It deletes the composite primary key SoftwareID and OrderID from tblOrderDetails. Then it checks to see if
   there are no other records in this table with the same OrderID. If there were none, it deletes the same record from tblOrders as well.
 
5. spAddOrderToExistingCustomer
   First it adds a new OrderDate (which defuals to todays date). Then, It captures the auto generated OrderID to
   add it to tblOrderDetails along with SoftwareID and its matching quantity to complete the process.

6. spAddNewSoftwareTitles
   It opens a popup form to get Title, Description, and UnitPrice data from the user.
]]>
</content>

Open in new window

0
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 150 total points
ID: 40391319
above will work, but just put the whole text as 1 xml node. I presume however that you wanted to split the different parts into "sentences" or "paragraphs" or the like, but this depends on you exact needs;
the main key here is the <![CDATA[  ... ]]  construct that allows you to put "anything" as xml node content
0
 
LVL 33

Author Comment

by:Mike Eghtebas
ID: 40391349
Thank you.
0
 
LVL 35

Expert Comment

by:mccarl
ID: 40393389
You're welcome!
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VB.Net and XML XSD Files 1 59
Scraping specific data within an XML document 19 56
XML SQL 8 25
TSQL query to generate xml 4 35
The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question