[ad_1]
\n<\/p>\n
Before anybody gives me negative points for this highly unusual solution, please understand the problems.
\n1) The multiple Folder nested tags
\n2) The html text<\/p>\n
I using a xml template file to read intial xml. This xml is complicated so I don’t think it is wise to create the xml from scratch. <\/p>\n
Use the following xml template for main file<\/p>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<kml xmlns=\"http:\/\/www.opengis.net\/kml\/2.2\" xmlns:gx=\"http:\/\/www.google.com\/kml\/ext\/2.2\"\n xmlns:kml=\"http:\/\/www.opengis.net\/kml\/2.2\" xmlns:json=\"http:\/\/www.w3.org\/2005\/Json\">\n <Folder>\n <name>***COUNTRY***<\/name>\n <open>1<\/open>\n <Folder>\n <name>***CITY TYPE***<\/name>\n <open>1<\/open>\n <Folder>\n <name>***SIZE***<\/name>\n <Folder>\n <name>***STATUS***<\/name>\n <Document>\n <name>POINTS<\/name>\n <StyleMap id=\"Licerio0_0\">\n <Pair>\n <key>normal<\/key>\n <styleUrl>#Licerio0_0N<\/styleUrl>\n <\/Pair>\n <Pair>\n <key>highlight<\/key>\n <styleUrl>#Licerio0_0H<\/styleUrl>\n <\/Pair>\n <\/StyleMap>\n <Style id=\"Licerio0_0N\">\n <IconStyle>\n <color>ff00ff00<\/color>\n <scale>0.4<\/scale>\n <Icon>\n http:\/\/maps.google.com\/mapfiles\/kml\/shapes\/shaded_dot.png\n <\/Icon>\n <\/IconStyle>\n <LabelStyle>\n <color>ff00ff00<\/color>\n <scale>0.6<\/scale>\n <\/LabelStyle>\n <BalloonStyle>\n <text>$How to generate an xml file from datatable [closed]<\/text>\n <\/BalloonStyle>\n <LineStyle>\n <antialias>0<\/antialias>\n <\/LineStyle>\n <PolyStyle>\n <fill>0<\/fill>\n <outline>0<\/outline>\n <\/PolyStyle>\n <\/Style>\n <Placemark>\n <name>***CITY NAME***<\/name>\n <description>\n <![CDATA[<img src=\"http:\/\/upload.wikimedia.org\/wikipedia\/commons\/***COUNTRY***.png\"width=\"47\" height=\"67\">\n <br>RSID = <b>***CITY NAME***<\/b><ul>\n <li>PIN = ***PIN***\n <li>LONGITUDE = ***LONGITUDE***\n <li>LATITUDE = ***LATITUDE***\n <li>SCALE = ***SCALE***\n <li>TOTAL TILT = ***TILT***\n <li>CH = ***CH***\n <li>REGION = ***REGION***<\/ul><\/li>]]>\n <\/description>\n <styleUrl>#Licerio0_0<\/styleUrl>\n <Point>\n <gx:drawOrder>3<\/gx:drawOrder>\n <coordinates>***LONGITUDE***,***LATITUDE***,***SCALE***<\/coordinates>\n <\/Point>\n <\/Placemark>\n <\/Document>\n <\/Folder>\n <\/Folder>\n\n <\/Folder>\n <\/Folder>\n<\/kml>\n<\/code><\/pre>\nThe use following template for 2nd file<\/p>\n
<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<kml xmlns=\"http:\/\/www.opengis.net\/kml\/2.2\" xmlns:gx=\"http:\/\/www.google.com\/kml\/ext\/2.2\"\n xmlns:kml=\"http:\/\/www.opengis.net\/kml\/2.2\" xmlns:json=\"http:\/\/www.w3.org\/2005\/Json\">\n <name>LINES<\/name>\n <Style id=\"Zamoras0_0\">\n <\/Style>\n <Placemark>\n <name>***Site Id***<\/name>\n <styleUrl>#Zamoras0_0<\/styleUrl>\n <MultiGeometry>\n <LineString>\n <gx:drawOrder>3<\/gx:drawOrder>\n <coordinates>***LONGITUDE***,***LATITUDE***,***SCALE***<\/coordinates>\n <\/LineString>\n <\/MultiGeometry>\n <\/Placemark>\n<\/kml>\n<\/code><\/pre>\nThen use code below<\/p>\n
using System;\nusing System.Collections.Generic;\nusing System.Linq;\nusing System.Text;\nusing System.Data;\nusing System.Xml;\nusing System.Xml.Linq;\n\nnamespace ConsoleApplication9\n{\n class Program\n {\n const string FILENAME1 = @\"c:\\temp\\test1.xml\";\n const string FILENAME2 = @\"c:\\temp\\test2.xml\";\n static void Main(string[] args)\n {\n DataTable dt = new DataTable();\n dt.Columns.Add(\"countryname\", typeof(string));\n dt.Columns.Add(\"citytype\", typeof(string));\n dt.Columns.Add(\"size\", typeof(string));\n dt.Columns.Add(\"status\", typeof(string));\n dt.Columns.Add(\"cityname\", typeof(string));\n dt.Columns.Add(\"pin\", typeof(int));\n dt.Columns.Add(\"LONGITUDE\", typeof(double));\n dt.Columns.Add(\"LATITUDE\", typeof(double));\n dt.Columns.Add(\"SCALE\", typeof(double));\n dt.Columns.Add(\"TOTAL\", typeof(int));\n dt.Columns.Add(\"TILT\", typeof(string));\n dt.Columns.Add(\"CH\", typeof(string));\n dt.Columns.Add(\"REGION\", typeof(string));\n dt.Columns.Add(\"streets\", typeof(string));\n\n dt.Rows.Add(new object[] { \"USA\", \"Corperation\", \"LARGE\", \"WORKING\", \"newyork\", 676306, 24.4251, 25.6011, 0.0, 87, \"NEM\", \"\", \"\", \"firststreet\" });\n dt.Rows.Add(new object[] { \"USA\", \"Corperation\", \"LARGE\", \"WORKING\", \"newyork\", 676306, 24.4251, 25.6011, 0.0, 87, \"NEM\", \"\", \"\", \"downtownstreet\" });\n dt.Rows.Add(new object[] { \"USA\", \"Corperation\", \"LARGE\", \"WORKING\", \"chicago\", 676306, 24.4251, 25.6011, 0.0, 87, \"NEM\", \"\", \"\", \"chicstreet\" });\n dt.Rows.Add(new object[] { \"USA\", \"Corperation\", \"LARGE\", \"WORKING\", \"la\", 676306, 24.4251, 25.6011, 0.0, 87, \"NEM\", \"\", \"\", \"lastreet\" });\n dt.Rows.Add(new object[] { \"USA\", \"Corperation\", \"MEDIUM\", \"WORKING\", \"buffalo\", 676306, 24.4251, 25.6011, 0.0, 87, \"NEM\", \"\", \"\", \"buffalostreet\" });\n dt.Rows.Add(new object[] { \"USA\", \"Corperation\", \"MEDIUM\", \"WORKING\", \"buffalo\", 676306, 24.4251, 25.6011, 0.0, 87, \"NEM\", \"\", \"\", \"cowstreet\" });\n dt.Rows.Add(new object[] { \"USA\", \"Corperation\", \"MEDIUM\", \"WORKING\", \"denver\", 676306, 24.4251, 25.6011, 0.0, 87, \"NEM\", \"\", \"\", \"street\" });\n dt.Rows.Add(new object[] { \"USA\", \"Corperation\", \"MEDIUM\", \"NOT WORKING\", \"lasvegas\", 676306, 24.4251, 25.6011, 0.0, 87, \"NEM\", \"\", \"\", \"street\" });\n dt.Rows.Add(new object[] { \"USA\", \"Corperation\", \"SMALL\", \"WORKING\", \"trenton\", 676306, 24.4251, 25.6011, 0.0, 87, \"NEM\", \"\", \"\", \"street\" });\n dt.Rows.Add(new object[] { \"USA\", \"Village\", \"SMALL\", \"WORKING\", \"albany\", 676306, 24.4251, 25.6011, 0.0, 87, \"NEM\", \"\", \"\", \"street\" });\n dt.Rows.Add(new object[] { \"USA\", \"Village\", \"SMALL\", \"WORKING\", \"hartford\", 676306, 24.4251, 25.6011, 0.0, 87, \"NEM\", \"\", \"\", \"street\" });\n dt.Rows.Add(new object[] { \"SPAIN\", \"Corperation\", \"MEDIUM\", \"WORKING\", \"BARCELONA\", 11111, 34.4251, 25.6011, 0.0, 82, \"LEV\" });\n dt.Rows.Add(new object[] { \"ITALY\", \"Corperation\", \"LARGE\", \"WORKING\", \"ITALY\", 21111, 14.4251, 15.6011, 0.0, 80, \"MIR\" });\n\n XDocument doc1 = XDocument.Load(FILENAME1);\n XElement kml = (XElement)doc1.FirstNode;\n XNamespace ns = kml.Name.Namespace;\n XElement document = doc1.Descendants().Where(x => x.Name.LocalName == \"Document\").FirstOrDefault();\n string documentStr = document.ToString();\n kml.RemoveAll();\n\n XDocument doc2 = XDocument.Load(FILENAME2);\n XElement linesDoc = (XElement)doc2.FirstNode;\n string linesStr = linesDoc.ToString();\n\n\n var countryRows = dt.AsEnumerable().GroupBy(x => x.Field<string>(\"countryname\"));\n foreach (var country in countryRows)\n {\n XElement newCountry = new XElement(ns + \"Folder\", new object[] {\n new XElement(ns + \"name\", country.Key),\n new XElement(ns + \"open\", 1)\n });\n kml.Add(newCountry);\n\n var cityTypeRows = country.GroupBy(x => x.Field<string>(\"citytype\"));\n foreach (var cityTypeRow in cityTypeRows)\n {\n XElement newCityType = new XElement(ns + \"Folder\", new object[] {\n new XElement(ns + \"name\", cityTypeRow.Key),\n new XElement(ns + \"open\", 1)\n });\n newCountry.Add(newCityType);\n\n var citySizeRows = cityTypeRow.GroupBy(x => x.Field<string>(\"size\"));\n foreach (var citySizeRow in citySizeRows)\n {\n XElement newCitySize = new XElement(ns + \"Folder\", new object[] {\n new XElement(ns + \"name\", citySizeRow.Key)\n });\n newCityType.Add(newCitySize);\n\n var cityStatusRows = cityTypeRow.GroupBy(x => x.Field<string>(\"status\"));\n foreach (var cityStatusRow in cityStatusRows)\n {\n XElement newStatus = new XElement(ns + \"Folder\", new object[] {\n new XElement(ns + \"name\", cityStatusRow.Key)\n });\n newCitySize.Add(newStatus);\n\n var cityRows = cityTypeRow.GroupBy(x => x.Field<string>(\"cityname\"));\n foreach (var city in cityRows)\n {\n\n string newDocumentStr = documentStr;\n newDocumentStr = newDocumentStr.Replace(\"***CITY NAME***\", city.Key);\n newDocumentStr = newDocumentStr.Replace(\"***PIN***\", city.FirstOrDefault().Field<int>(\"pin\").ToString());\n newDocumentStr = newDocumentStr.Replace(\"***LONGITUDE***\", city.FirstOrDefault().Field<double>(\"LONGITUDE\").ToString());\n newDocumentStr = newDocumentStr.Replace(\"***LATITUDE***\", city.FirstOrDefault().Field<double>(\"LATITUDE\").ToString());\n newDocumentStr = newDocumentStr.Replace(\"***SCALE***\", city.FirstOrDefault().Field<double>(\"SCALE\").ToString());\n newDocumentStr = newDocumentStr.Replace(\"***TOTAL***\", city.FirstOrDefault().Field<int>(\"TOTAL\").ToString());\n newDocumentStr = newDocumentStr.Replace(\"***TILT***\", city.FirstOrDefault().Field<string>(\"TILT\"));\n newDocumentStr = newDocumentStr.Replace(\"***CH***\", city.FirstOrDefault().Field<string>(\"CH\"));\n newDocumentStr = newDocumentStr.Replace(\"***REGION***\", city.FirstOrDefault().Field<string>(\"REGION\"));\n\n XElement newCity = XElement.Parse(newDocumentStr);\n newCitySize.Add(newCity);\n foreach (var street in city)\n {\n if (street.Field<object>(\"streets\") != null)\n {\n string newlinesStr = linesStr;\n newlinesStr = newlinesStr.Replace(\"***LONGITUDE***\", street.Field<double>(\"LONGITUDE\").ToString());\n newlinesStr = newlinesStr.Replace(\"***LATITUDE***\", street.Field<double>(\"LATITUDE\").ToString());\n newlinesStr = newlinesStr.Replace(\"***SCALE***\", street.Field<double>(\"SCALE\").ToString());\n newlinesStr = newlinesStr.Replace(\"***Site Id***\", street.Field<string>(\"streets\").ToString());\n\n XElement newLine = XElement.Parse(newlinesStr);\n newCity.Add(newLine.Elements());\n }\n }\n }\n }\n }\n }\n }\n }\n }\n}\n<\/code><\/pre>\n<\/p><\/div>\n