OPENXML allows access to XML data as though it is a relational rowset. It provides rowset view of internal representation of XML document. The records in the rowset can be stored in database table. Above illustration explain the process of OPENXML. To write queries against an XML document by using OPENXML, you must first call sp_xml_preparedocument. This parses the XML document and returns a handle to the parsed document that is ready for consumption. The parsed document is a document object model (DOM) tree representation of various nodes in the XML document.

In this article I’m going to explain how to bind GridView from XML file in ASP.NET using C#. I’ve already written few articles about XML. In this article I’ll show you how to bind GridView from XML. First we have to create XML file and write some sample data about employee details. Then we’ve to read that data from XML file and we can display the data to GridView.

In this article I’m going to explain how to bind GridView from XML file in ASP.NET using C#. I’ve already written few articles about XML. In this article I’ll show you how to bind GridView from XML. First we have to create XML file and write some sample data about employee details. Then we’ve to read that data from XML file and we can display the data to GridView.

In this article I’m going to explain how to bind DataList from XML file in ASP.NET using C#. The DataList Web server control displays data in a format that you can define using templates and styles. The DataList control is useful for data in any repeating structure, such as a table. The DataList control can display rows in different layouts, such as ordering them in columns or rows.

In this article I’m going to explain how to insert delete update records in XML file using ASP.NET and C#. XML was created to structure, store and transport data. What is XML? XML stands for EXtensible Markup Language XML is a markup language much like HTML XML was designed to carry data, not to display data XML tags are not predefined. You must define your own tags