Solved

To put together an xml file...

Posted on 2014-10-19
4
138 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

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…
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…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

863 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now