?
Solved

To put together an xml file...

Posted on 2014-10-19
4
Medium Priority
?
150 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 36

Accepted Solution

by:
mccarl earned 1400 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 600 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 36

Expert Comment

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

Featured Post

Create CentOS 7 Newton Packstack Running Keystone

A bug was filed against RDO for the installation of Keystone v3. This guide is designed to walk you through the configuration for using Keystone v3 with Packstack. You will accomplish this using various repos and the Answers file.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Create a Windows 10 custom Image with custom task bar and custom start menu using XML for deployment.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

719 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