MandaPanda
New Member
I am trying to extract those subnodes, but I had got just headache so far...\[code\]<item> <airlineCode>AA</airlineCode> <arrivalDateTime>2010-11-08T22:48:00.000Z</arrivalDateTime> <crewMembers> <item> <employeeId>028840</employeeId> <isDepositor>Y</isDepositor> <isTransmitter>N</isTransmitter> </item> <item> <employeeId>097790</employeeId> <isDepositor>N</isDepositor> <isTransmitter>Y</isTransmitter> </item> </crewMembers></item>\[/code\]with the code I can get them, but I do not know how to select each one according to their tag name to insert them into a database.\[code\]XmlDocument xmlDoc = new XmlDocument();xmlDoc.Load("C:/Crew_Request_Sample.xml"); XmlNodeList elemList = xmlDoc.GetElementsByTagName("item");foreach (XmlNode node in elemList){ Debug.WriteLine(node.InnerText);}\[/code\]I need some direction, please.