Solved

To put together an xml file...

Posted on 2014-10-19
4
144 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 143

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 34

Author Comment

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

Expert Comment

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

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Custom Ribbon doesn't refresh 7 108
XSLT Help 12 34
XSL FO - text wrapping and empty spaces 1 43
XML XSL Choose example 3 37
The Client Need Led Us to RSS I recently had an investment company ask me how they might notify their constituents about their newsworthy publications.  Probably you would think "Facebook" or "Twitter" but this is an interesting client.  Their cons…
Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

740 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