c# - How to load an XML Document to display as specific input format -
I am currently trying to load a CM program in a CM program so that I can do it as a soap request Can send
Here is the XML document that I am trying to reference. It has a potential endless row.
& lt ;? XML version = "1.0" encoding = "UTF-8"? & Gt; & Lt; Rowset & gt; & Lt; ROW num = "1" & gt; & Lt; USER_ID & gt; & Lt; / USER_ID & gt; & Lt; FIRST_NAME & gt; John & lt; / FIRST_NAME & gt; & Lt; MIDDLE_NAME & gt; & Lt; / MIDDLE_NAME & gt; & Lt; LAST_NAME & gt; Do & lt; / LAST_NAME & gt; & Lt; EMPLOYEE_NO & gt; 12345 & lt; / EMPLOYEE_NO & gt; & Lt; HOME_PHONE & gt; & Lt; / HOME_PHONE & gt; & Lt; EMPLOYEE_STATUS_ & gt; & Lt; / EMPLOYEE_STATUS_ & gt; & Lt; HIRE_DATE & gt; 05/17/2010 and lt; / HIRE_DATE & gt; & Lt; Department & gt; Engineering & lt; / Department & gt; & Lt; POSITION & gt; Control Engineer & lt; / POSITION & gt; & Lt; Shift & gt; N & lt; / Shift & gt; & Lt; REPORTS_TO & gt; Everhart, Robert & lt; / REPORTS_TO & gt; & Lt; PAY_TYPE & gt; H & lt; / PAY_TYPE & gt; & Lt; EMPLOYEE_TYPE & gt; R & lt; / EMPLOYEE_TYPE & gt; & Lt; TERMINATION_DATE & gt; & Lt; / TERMINATION_DATE & gt; & Lt; PCN_CODE & gt; Company_RV & lt; / PCN_CODE & gt; & Lt; / Row & gt; & Lt; ROW num = "2" & gt; & Lt; USER_ID & gt; RV12345 & lt; / USER_ID & gt; & Lt; FIRST_NAME & gt; Jane & lt; / FIRST_NAME & gt; & Lt; MIDDLE_NAME & gt; G & lt; / MIDDLE_NAME & gt; & Lt; LAST_NAME & gt; Do & lt; / LAST_NAME & gt; & Lt; EMPLOYEE_NO & gt; 123,455 & lt; / EMPLOYEE_NO & gt; & Lt; HOME_PHONE & gt; & Lt; / HOME_PHONE & gt; & Lt; EMPLOYEE_STATUS_ & gt; & Lt; / EMPLOYEE_STATUS_ & gt; & Lt; HIRE_DATE & gt; 09/15/2008 and lt; / HIRE_DATE & gt; & Lt; Department & gt; Shipping & lt; / Department & gt; & Lt; POSITION & gt; Shipping Coordinator & lt; / POSITION & gt; & Lt; Shift & gt; 2 & lt; / Shift & gt; & Lt; REPORTS_TO & gt; Hajkova, Karin & lt; / REPORTS_TO & gt; & Lt; PAY_TYPE & gt; H & lt; / PAY_TYPE & gt; & Lt; EMPLOYEE_TYPE & gt; R & lt; / EMPLOYEE_TYPE & gt; & Lt; TERMINATION_DATE & gt; & Lt; / TERMINATION_DATE & gt; & Lt; PCN_CODE & gt; Company_RV & lt; / PCN_CODE & gt; I need to format this file in:
& lt; As a result & gt; & Lt; ROWCOUNT & gt; 1 & lt; / ROWCOUNT & gt; & Lt; Rows & gt; & Lt; Line & gt; & Lt; Columns & gt; & Lt; Columns & gt; & Lt; VALUE & gt; Jdoe & lt; / Pricing & gt; & Lt; Name & gt; User_id & lt; / Name & gt; & Lt; / Column & gt; & Lt; Columns & gt; & Lt; VALUE & gt; John & lt; / Pricing & gt; & Lt; Name & gt; FIRST_NAME & lt; / Name & gt; And further forward Once the XML file has been loaded and can be massaged in the correct format, the XML data variable will be placed in a soap envelope.
Serializing the XML on the memory to create an XSD tool with the original XML Try it.
Use XmlSerializer to get everything in memory:
XmlSerializer serializer = New XmlSerializer (XmlClassTypeYouCreatedOnXsdTool); XmlReader Reader = New XmlTextReader (xml); Var Example = Serializer Dairyialize (Reader); Use the same xsd tool with the output XML form that you want to create to create another serial class.
Create a function to convert one object to another and then send your SOAP messages to the object or to create XML in your SOAP message, similar XmlSerializer and Serialize call.
Comments
Post a Comment