Convert an XML file to a string
public string xmldocumenttostring (XmlDocument doc) { MemoryStream stream = new MemoryStream (); XmlTextWriter writer = new XmlTextWriter (stream, null); Writer. formatting = formatting.indented; Doc. Save (writer); Convert StreamReader sr = new StreamReader (stream, System.Text.Encoding.UTF8); Stream. Position = 0; String xmlstring = Sr. ReadToEnd (); Sr. Close (); Stream. Close (); return xmlstring;
Turn a string into a DataTable
Private DataSet Getxmlimages (Stringsubfolder) {string[] Xmlfiles = directory.getfiles (sourcedirectory +"\\"+ subfolder,"*.xml", searchoption.alldirectories);if (Xmlfiles.length > 0) { string xmlfilepath = xmlfiles[0]; XmlDocument doc = new XmlDocument (); Doc. Load (Xmlfilepath); string xmlfile = xmldocumenttostring (DOC); DataSet Xmlinfo = new dataset (); xmlinfo = Convertxmltodataset (xmlfile); return Xmlinfo;} return null;}
Writing a DataTable to a database