Convert existing node to xml attribute

Question

Output   1 1 85230830-b0ae-4f20-98f1-f96b62337f14-00000021 Sales Create No     Expected Output No

John · Answer

Gotcha objxml.Save(Server.MapPath("Test.xml")); Response.Redirect("Test.xml");

John · Answer

I m using like this   XmlDocument objxml = new XmlDocument(); XmlNode objxmlDecl; objxmlDecl = objxml.CreateNode(XmlNodeType.XmlDeclaration, "", ""); objxml.AppendChild(objxmlDecl); XmlElement objRoot; objRoot = objxml.CreateElement("ENVELOPE"); objxml.AppendChild(objRoot); Console.WriteLine(objxml.InnerXml);   how to create an redirect to an xml file now

Bikesh Srivastava · Answer

use xmlelement class

Nigel Fernandes · Answer

You will need to create the xml manually by using a loop ( for / while).

John · Answer

Sorry can u give me an example

Nigel Fernandes · Answer

Using writeXML will automatically convert columns to nodes.   You will have to write a for loop with conditions to make it into attributes.   Also you can read this if its helps: http://stackoverflow.com/questions/10231621/how-to-export-a-datatable-to-xml-with-all-columns-as-attributes

John · Answer

MemoryStream str = new MemoryStream(); ds.WriteXml(str); str.Seek(0, SeekOrigin.Begin); StreamReader sr = new StreamReader(str); string xmlstr; xmlstr = sr.ReadToEnd();   this is my code to generate the xml string

Nigel Fernandes · Answer

Hi what function are you using to generate the above output ? Can you share your code?