{"id":65654,"date":"2021-07-10T04:10:05","date_gmt":"2021-07-10T08:10:05","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/xml-related-classes-in-net-misc-net\/"},"modified":"2025-05-11T20:20:14","modified_gmt":"2025-05-11T20:20:14","slug":"xml-related-classes-in-net-misc-net","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=65654","title":{"rendered":"XML Related Classes in .Net #Misc .Net"},"content":{"rendered":"

Brought from our old site (yes, very old short-note): http:\/\/salearningschool.com\/displayArticle.php?table=Articles&articleID=633&title=XML%20Related%20Clasees%20in%20.Net<\/p>\n

XML in ADO.net VB.NET C#.NET<\/b><\/p>\n

XML is the foundation of .NET. .NET internally represents data as XML and hence can provide inter-operability and interaction among applications written in different platforms and languages [.Net compatible].<\/p>\n

XmlReader<\/b><\/p>\n

In .Net you can use XML with SqlCommand object. You first create a connection to the SQL server database using the SqlConnection object. Then you can use a SqlCommand object with that SqlConnection object to query sql server databases(in XML format). You can use the ExecuteXmlReader() method to execute a query. A select operation will return data that can be grabbed into a XMLReader [similar to DataReader object] object. You know that in SqlCommand object you can specify the Query or the stored procedure name to execute. XmlReader object has a Read method like the DataReader object that helps to navigate through the nodes. Mentionable, the query must have FOR XML clause.<\/p>\n

XML with DataSet<\/b><\/p>\n

DataSet object has two methods to work with XML. You can use ReadXml to read a XML file or stream. Also, you can use WriteXml to write the contents of the DataSet to a file, stream, or an XmlWriter or TextWriter object.<\/p>\n

XmlDataDocument Class<\/b><\/p>\n

You can load XML data into a XmlDataDocument object[from a file or from a dataset]. DOM can be used to manipulate the data. A DataSet containing XML data can also be loaded into a XmlDataDocument object(constructor parameter).<\/p>\n

XSLT Transform:<\/b><\/p>\n

XmlDataDocument and XslTransform classes are used to transform XML from one form to another. An XslTransform object contains the style definition and loads a style file using it’s Load method. The Transform method of XslTransform transforms XML data according to the style sheet rules. Transform takes a XmlDataDocument[or objects implemented IXPathNavigable interface] object as a source XML data to transform. Transform also, takes another parameter for the destination[a file, stream, XmlWriter, or TextWriter]<\/p>\n

All these apply for both VB.net and C#.net. I will provide some code examples in future.<\/p>\n

From: http:\/\/sitestree.com\/?p=3751
Categories:Misc .Net
Tags:
Post Data:2016-07-17 08:47:21<\/p>\n

\t\tShop Online: https:\/\/www.ShopForSoul.com\/<\/a>
\n\t\t(Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com<\/a>
\n\t\tIn Bengali: http:\/\/Bangla.SaLearningSchool.com<\/a>
\n\t\thttp:\/\/SitesTree.com<\/a>
\n\t\t8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a>
\n\t\tShop Online: https:\/\/www.ShopForSoul.com\/<\/a>
\n\t\tMedium: https:\/\/medium.com\/@SayedAhmedCanada <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Brought from our old site (yes, very old short-note): http:\/\/salearningschool.com\/displayArticle.php?table=Articles&articleID=633&title=XML%20Related%20Clasees%20in%20.Net XML in ADO.net VB.NET C#.NET XML is the foundation of .NET. .NET internally represents data as XML and hence can provide inter-operability and interaction among applications written in different platforms and languages [.Net compatible]. XmlReader In .Net you can use XML with SqlCommand object. You … <\/p>\n

Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1973,1917],"tags":[],"class_list":["post-65654","post","type-post","status-publish","format-standard","hentry","category-c-misc","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":69924,"url":"http:\/\/bangla.sitestree.com\/?p=69924","url_meta":{"origin":65654,"position":0},"title":"XML Related Clasees in .Net #18","author":"Author-Check- Article-or-Video","date":"August 22, 2021","format":false,"excerpt":"XML in ADO.net VB.NET C#.NETXML is the foundation of .NET. .NET internally represents data as XML and hence can provide interoperability and interaction among applications written in different platforms and languages[.Net compatible].XmlReader In .Net you can use XML with SqlCommand object. You first create a connection to the sql server\u2026","rel":"","context":"In "C# - Misc"","block_context":{"text":"C# - Misc","link":"http:\/\/bangla.sitestree.com\/?cat=1973"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":65664,"url":"http:\/\/bangla.sitestree.com\/?p=65664","url_meta":{"origin":65654,"position":1},"title":"XmlTextReader Overview #Misc .Net","author":"Author-Check- Article-or-Video","date":"July 10, 2021","format":false,"excerpt":"Brought from our old site: http:\/\/salearningschool.com\/displayArticle.php?table=Articles&articleID=626&title=XmlTextReader%20Overview Overview of .Net XmlReader and XmlWriter Object XmlReader Can read XML data both from file or stream. Readonly access. Also, provides information about the XML data. XmlTextReader class is derived from XmlReader. It provides faster access to XML data though it does not support\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":65662,"url":"http:\/\/bangla.sitestree.com\/?p=65662","url_meta":{"origin":65654,"position":2},"title":"Overview of XML programming in Dot Net #Misc .Net","author":"Author-Check- Article-or-Video","date":"July 10, 2021","format":false,"excerpt":"Brought from our old-site (a very old short-note): http:\/\/salearningschool.com\/displayArticle.php?table=Articles&articleID=625&title=%3Ch2%3EOverview%20of%20XML%20programming%20in%20Dot%20Net%3C\/h2%3E Overview of XML programming in Dot Net XML DOM (Document Object Model) Three ways to read XML documents in dot net are: XML DOM, SAX, XMLReader. DOM loads entire XML data into memory for processing, it is both read-write, I mean\u2026","rel":"","context":"In "C# - Misc"","block_context":{"text":"C# - Misc","link":"http:\/\/bangla.sitestree.com\/?cat=1973"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69380,"url":"http:\/\/bangla.sitestree.com\/?p=69380","url_meta":{"origin":65654,"position":3},"title":"Overview of XML programming in Dot Net #24","author":"Author-Check- Article-or-Video","date":"August 19, 2021","format":false,"excerpt":"Overview of XML programming in Dot Net XML DOM(Document Object Model) Three ways to read XML documents in dot net are: XML DOM, SAX, XMLReader.DOM loads entire XML data into memory for processing, it is both read-write, I mean you can change XML data and save. DOM uses data-structures to\u2026","rel":"","context":"In "C# - Misc"","block_context":{"text":"C# - Misc","link":"http:\/\/bangla.sitestree.com\/?cat=1973"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69382,"url":"http:\/\/bangla.sitestree.com\/?p=69382","url_meta":{"origin":65654,"position":4},"title":"XmlTextReader Overview #24","author":"Author-Check- Article-or-Video","date":"August 19, 2021","format":false,"excerpt":"Overview of .Net XmlReader and XmlWriter Object XmlReader Can read XML data both from file or stream. Readonly access. Also, provides information about the XML data. XmlTextReader class is derived from XmlReader. It provides faster access to XML data though it does not support validating DTD or XML schema. XmlValidatingReader\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":65652,"url":"http:\/\/bangla.sitestree.com\/?p=65652","url_meta":{"origin":65654,"position":5},"title":"Database Programming in .Net: ADO.Net Overview #Misc .Net","author":"Author-Check- Article-or-Video","date":"July 10, 2021","format":false,"excerpt":"Overview of ADO.net Purpose Components of ADO.net and their functions ADO.net provides disconnected database access to make minimum resource (RAM,Page Table,Heap) use. Database connections are open as long as the connection is required. Afterwards, the connection is just closed. If connections are kept active and if new connections are used\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/65654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=65654"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/65654\/revisions"}],"predecessor-version":[{"id":78155,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/65654\/revisions\/78155"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=65654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=65654"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=65654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}