Here is a very good simple way to convert a list of objects to XML.<\/p>\n
First, create a class for your list of objects. This class could be declared next to your routine if it is just to capture query results for example.<\/p>\n
[Serializable()]\r\n public class QR\r\n {\r\n public string Name { get; set; }\r\n public string Address { get; set; }\r\n public string Street { get; set; }\r\n }<\/pre>\nHere is an example of populating the list from a BC AX query.<\/p>\n
List<QR> QueryResults = new List<QR>();\r\n\r\n DynRec = _DynAx.CreateAxaptaRecord(\"smmBusRelTable\");\r\n\r\n string fieldName = (\"BusRelAccount\");\r\n string fieldValue = (\"BRC00001\");\r\n\r\n DynRec.ExecuteStmt(string.Format(\"select * from %1 where %1.{0} == '{1}'\", fieldName, fieldValue));\r\n\r\n while (DynRec.Found)\r\n {\r\n QR newRecord = new QR();\r\n newRecord.Name = (string)DynRec.get_Field(\"Name\");\r\n newRecord.Address = (string)DynRec.get_Field(\"Address\");\r\n newRecord.Street = (string)DynRec.get_Field(\"Street\");\r\n QueryResults.Add(newRecord);\r\n DynRec.Next();\r\n }<\/pre>\nAnd… heres the routine to convert this list to XML.<\/p>\n
var xs = new XmlSerializer(QueryResults.GetType());\r\nvar xml = new StringWriter();\r\nxs.Serialize(xml, QueryResults);\r\n\r\nxml.ToString();<\/pre>\nAnd… finally to Deserialize the XML data;<\/p>\n
StringReader rdr = new StringReader(XMLDataString);\r\n\r\nXmlSerializer xmlSerializer = new XmlSerializer(typeof(List<QR>));\r\n\r\nvar result = (List<QR>)xmlSerializer.Deserialize(rdr);\r\n\r\nMessageBox.Show(result[0].Name);<\/pre>\n <\/p>\n","protected":false},"excerpt":{"rendered":"
Here is a very good simple way to convert a list of objects to XML. First, create a class for your list of objects. This class could be declared next to your routine if it is just to capture query … Continue reading