Last post Sep 22, 2015 04:13 PM by a2h
Member
17 Points
151 Posts
Sep 22, 2015 03:11 PM|sreekanth.jonna|LINK
Hi,
I am generating XML from an excel, but when ever i have empty data in any elements it is not closing the tag as expected.
Current OutPut:
<?xml version="1.0" encoding="utf-8"?> <Events> <Event> <ID>3655918</ID> <Status/>
Expected OutPut:
<?xml version="1.0" encoding="utf-8"?> <Events> <Event> <ID>3655918</ID> <Status></Status>
Below is the code which i tried..
var settings = new XmlWriterSettings(); settings.Indent = true; settings.IndentChars = "\t"; settings.Encoding = Encoding.UTF8; settings.OmitXmlDeclaration = true; var sb = new StringBuilder(); XmlWriter writer = XmlWriter.Create(sb, settings); writer.WriteStartDocument(); writer.WriteStartElement("Events"); foreach (var item in uniqueEventIds) { writer.WriteStartElement("Event"); writer.WriteElementString("ID", EventDetails.Rows[0]["Event Id"].ToString()); writer.WriteElementString("Status", EventDetails.Rows[0]["Status"].ToString()); }
Please correct me..thanks in advance
sree
All-Star
50841 Points
9895 Posts
Sep 22, 2015 04:13 PM|A2H|LINK
sreekanth.jonna Expected OutPut: <?xml version="1.0" encoding="utf-8"?> <Events> <Event> <ID>3655918</ID> <Status></Status>
You can try with the below code
var settings = new XmlWriterSettings(); settings.Indent = true; settings.IndentChars = "\t"; settings.Encoding = Encoding.UTF8; settings.OmitXmlDeclaration = true; var sb = new StringBuilder(); XmlWriter writer = XmlWriter.Create(sb, settings); writer.WriteStartDocument(); writer.WriteStartElement("Events"); foreach (var item in uniqueEventIds) { writer.WriteStartElement("Event"); writer.WriteStartElement("ID"); writer.WriteString(EventDetails.Rows[0]["Event Id"].ToString()); writer.WriteEndElement(); writer.WriteStartElement("Status"); writer.WriteString(EventDetails.Rows[0]["Status"].ToString()); writer.WriteEndElement(); }
Member
17 Points
151 Posts
End Tag for Empty Elements
Sep 22, 2015 03:11 PM|sreekanth.jonna|LINK
Hi,
I am generating XML from an excel, but when ever i have empty data in any elements it is not closing the tag as expected.
Current OutPut:
Expected OutPut:
Below is the code which i tried..
Please correct me..thanks in advance
sree
All-Star
50841 Points
9895 Posts
Re: End Tag for Empty Elements
Sep 22, 2015 04:13 PM|A2H|LINK
You can try with the below code
Aje
My Blog | Dotnet Funda