Summary How to convert the return value from XML with XmlConvert and ToInt32?

Sometimes you will require to convert some values from a XML file to another datatype. In a XML file every data is stored as a string. Luckily the XmlConvert class contains many functions to make the conversion possible. In this example I will show you how you can convert a string to an integer with the function ToInt32. In the following XML file I will try to convert the attribute ID from the MainCategory element to an integer.  

Additional information

<%@ import namespace="System.Xml" %> <%@ page language="C#" debug="true"%> <script runat="server"> void page_load(object sender, System.EventArgs e){ // Load the XmlDocument with the file XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(Server.MapPath("XmlConvertWithToInt32.xml")); // Create a new XmlNodeReader object and load the // category node XmlNodeReader nodeReader = new XmlNodeReader(xmlDoc); // Read the node while (nodeReader.Read()) { // Check attribute value if(nodeReader.GetAttribute("ID") != null){ int nID = XmlConvert.ToInt32(nodeReader.GetAttribute("ID")); // printout the result Response.Write(nID.ToString()); } } } </script>

Further additional information

<?xml version="1.0" encoding="utf-8"?> <CategoryList> <Category> <MainCategory ID="01">VC++</MainCategory> <Description>VC++ Articles</Description> <Active>Yes</Active> </Category> <Category> <MainCategory ID="02">XML</MainCategory> <Description>XML Articles</Description> <Active>Yes</Active> </Category> <Category> <MainCategory ID="03">XSL</MainCategory> <Description>XSL Articles</Description> <Active>Yes</Active> </Category> <Category> <MainCategory ID="04">XPath</MainCategory> <Description>XPath Articles</Description> <Active>Yes</Active> </Category> <Category> <MainCategory ID="05">XQuery</MainCategory> <Description>XQuery Articles</Description> <Active>Yes</Active> </Category> </CategoryList>

---

Rate this article on a scale of 1 to 10 (0 votes, average 0)

Your vote : 1 2 3 4 5 6 7 8 9 10  

Updating...

<< XSLT		.NET and XML (67)Ajax (2)BizTalk (55)CSS (114)JavaScript (64)LAMP (6)Microsoft ASP (90)PHP XML (89)reBlogger (0)Schemas, xsd, xdr (45)SEO (3)SQL XML (76)System.XML (39)Uncategorized (137)WCF, WS, SOAP (55)XALAN (22)XHTML (97)XML DOM (119)XmlSerializer (34)XQuery (24)XSLT (252)

Updating comments...

---

Updating comments...

Leave a comment for this article
Your name
Your email (optional)
Your comment
Optional: Upload an attachment
Enter the code shown: