Solved

To put together an xml file...

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

Expert Comment

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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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…
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…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

630 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