XML Data-Binding Powers Up in ASP.NET 2.0

XML Data-Binding Powers Up in ASP.NET 2.0

ML data is generally used to represent semi-structured or hierarchal data. Using XML documents as your data source allows you to receive XML documents from other sources and format the XML data to be compatible with your application. ASP.NET 1.0 let you use XML data sources, but much of that work required manual coding to get the data into a format suitable for display. In contrast, ASP.NET 2.0 provides a new XmlDataSource control that simplifies binding XML data to controls such as the TreeView and GridView?and it works with both hierarchical and tabular data.

Loading the XmlDataSource Control
Typically, you’d use the XmlDataSource control to display hierarchical XML data in read-only scenarios. However, because the control implements the IDataSource interface, it also works with tabular, or list-style, data. You can load the XmlDataSource control from either an XML file, by setting the DataFile property, or from a string containing XML, by setting the control’s Data property to the string.

While loading XML data, you can also specify an XML schema. The XmlDataSource control doesn’t use the schema, but data-bound controls can access it if required. To load a schema, you set the SchemaFile property value to the appropriate XML schema file. Alternatively, you can also store a schema in string form directly from code using the Schema property.

This article shows examples of how you might use the XmlDataSource control to display data in hierarchical and tabular data formats. To begin with, here’s a simple example that displays XML data from an XmlDataSource control in a TreeView control.

Binding the XmlDataSource Control to a TreeView Control
To begin, create the XML file shown below and save it as ProductDetails.xml. I’ll use that file as a data source throughout this article. The file contains a fragment of information on the various products in the Products table in the Northwind database.

                                                                                      

After creating the XML file, create a new ASP.NET page to consume it and display its information in a TreeView control. For example, the following page code shows a binding example using an XmlDataSource control and a TreeView control.

  <%@ Page Language="VB"%>           XML Data Binding with a TreeView Control                

?
Figure 1. TreeView Binding Example Page: Output from the XmlDataSource control is data-bound to a TreeView Control, which gets the data from the ProductDetails.xml file.

Note that the elements associate properties of individual TreeNode objects (such as DataMember, ValueField, and TextField) to attributes of XML nodes in the hierarchy. When you perform data binding, attributes in the XML elements are promoted to properties of the data item. Also note that the TreeView hierarchy exactly matches the hierarchy of the source XML; if the source XML doesn’t follow the same hierarchy, you would not get desirable results. Because of this, you would normally construct the XML specifically for binding to the TreeView.

When you execute the page, it will look similar to Figure 1.

XPath Data Binding Syntax
By default, the XmlDataSource control loads all the XML data in the XML file identified by the DataFile property or found inline in the Data property, but you can filter the data using an XPath query. The XPath property supports an XPath-syntax filter that the XmlDataSource control applies after it loads and transforms the XML data. The control supports the XPath-based data binding syntax on any data item that implements the IXPathNavigable interface. The syntax of the XPath expression is:

   XPath(expression, [formatString])

The property evaluates an XPath expression against the data item and returns a single value.

The following code example uses XPath data binding expressions to bind to attributes of the Product nodes. This particular example simply uses the ‘@’ prefix?the XPath syntax for a node attribute?to retrieve the attribute value in each expression. However, you can also use the XPath expression to refer to arbitrary items within the hierarchy.

   <%@Page Language="VB" Debug="True" %>           XPath Select Method Example           
XPath Select with a FormView Control

ID:
Name:
Price:
?
Figure 2. The XPath Example ASP.NET Page. The figure shows the result of data-binding a FormView control to the XmlDataSource control.

The ASP page described in the preceding code binds a FormView control to the XmlDataSource control. FormView is a new control supplied with ASP.NET 2.0, which can be directly associated with a DataSource control. After making the initial association, the FormView control, in conjunction with the DataSource control, handles Insert, Delete, Update, and Get operations. The example creates an ItemTemplate element inside the FormView control and specifies the XPath expression as part of the Label declarations. Figure 2 shows how the results look in a browser.

Paging is enabled in the screen shown in Figure 2, and users can click on the page numbers to navigate to the details of different products.

Performing XSL Transformations with the XmlDataSource Control
You can also transform the XML data before displaying it in a data-bound control by providing an Extensible Stylesheet Language (XSL) stylesheet for the transformation. You typically use the TransformFile property, which accepts a file name, to load the stylesheet from a file, but you can also load a stylesheet directly from a string using the Transform property.

Here’s an example XSL stylesheet that demonstrates how to apply an XSL Stylesheet file to the contents of the XmlDataSource control to transform that XML format into a different XML form before displaying the data in a TreeView control.

                                                                                                                                                                                                                                                                              

The XSL file transforms the ProductDetails.xml file into a different format?changing the names of the XML elements and the case of the attributes in the output. The next example shows how to apply the ProductDetails.xsl file to the ProductDetails.xml file, using a TreeView control to display the transformed XML content.

   <%@ Page Language="VB" %>           XML Transformation           
?
Figure 3. The Transformed XPath Example ASP.NET Page: The page shown in this figure was created by using an XSL Stylesheet file in conjunction with an XmlDataSource control to transform one XML format into another XML format, binding the result to the TreeView.

As part of the XmlDataSource control declaration, the DataFile and TransformFile attributes (properties) are set to ProductDetails.xml and ProductDetails.xsl respectively. After setting the attributes you can easily display the data in a TreeView control by setting the DataSourceID property of the TreeView control to the XmlDataSource control. Inside the TreeView declaration, you use the asp:TreeNodeBinding elements to specify which nodes and child nodes to display in the TreeView control.

Figure 3 shows the output produced by the page. Note that after the transformation, the top level node is products-list rather than Products as in the original ProductDetails.xml file. Apart from that, the data displayed is unchanged.

Displaying Hierarchical Data in a GridView Control
So far, you’ve seen how to display hierarchical information in a TreeView control and a FormView control. This section will provide you with an example on how to bind the XmlDataSource control to a DropDownList control and a GridView control. The example code uses the same ProductDetails.xml file as the XML source that you’ve already seen. As in the previous examples, add an XmlDataSource control to the ASP.NET page, but set the XPath attribute of the XmlDataSource control to Products/Product. This will filter for all the Product elements contained inside the root Products element.

Now, add a DropDownList and a GridView control to the page and set the DataSourceID attributes for both to the name of your XmlDataSource control (XmlDataSource1 by default). In the SelectedIndexChanged event of the XmlDataSource control, add code to set the XPath property of the XmlDataSource control to the value selected by the user in the DropDownList control. Finally, add a button to the ASP.NET page and inside the Click event of the button, add code to reset the XPath property of the XmlDataSource control to its original value (which is Products/Product). After making all of the changes, the code should look similar to Listing 1.

The code shown in Listing 1 uses the SelectedIndexChanged event of the DropDownList control to dynamically set the XPath property of the XmlDataSource control to the expression:

       XmlDataSource1.XPath = "Products/Product[@ID=" + _         DropDownList1.SelectedValue + "]"

In other words the XPath expression uses the value selected by the user in the DropDownList to obtain the Product element with that ID attribute value. In the button’s Click event, the code resets the XPath property to the default value, which is also set in the XPath attribute as part of the XmlDataSource control declaration.

Executing the code in Listing 1 results in a page where, when users select a product in the DropDownList, the output displayed by the GridView varies accordingly (see Figure 4).

?
Figure 4. A Bound GridView Control: When a user selects an item in the DropDownList, the page displays associated items in the GridView based on the ID attribute of the item selected.

Caching an XmlDataSource Control
For performance purposes, caching is enabled for the XmlDataSource control by default. You typically use the XmlDataSource with an XML file?and opening and reading an XML file on the server every time a page is requested can have a negative impact on the performance of your application. Caching reduces the processing load on your servers at the expense of memory; but in most cases this is a good trade-off. To cache data in an XmlDataSource control, set the EnableCaching property to true. You also need to set the CacheDuration property to the number of seconds that the cache stores data before refreshing the cache. You can also use the CacheExpirationPolicy to gain a finer level of control over the caching behavior.

This article showed you how to take advantage of the XmlDataSource control in an ASP.NET page to connect to XML data sources and display that information in data-bound controls such as a TreeView, FormView, GridView or DropDownList. Using the XmlDataSource control, you can apply an external XSL file to transform the contents of the XML file into another format before displaying that information in a data-bound control, and you can use XPath queries to extract the data.

devx-admin

devx-admin

Share the Post:
USA Companies

Top Software Development Companies in USA

Navigating the tech landscape to find the right partner is crucial yet challenging. This article offers a comparative glimpse into the top software development companies

Software Development

Top Software Development Companies

Looking for the best in software development? Our list of Top Software Development Companies is your gateway to finding the right tech partner. Dive in

India Web Development

Top Web Development Companies in India

In the digital race, the right web development partner is your winning edge. Dive into our curated list of top web development companies in India,

USA Web Development

Top Web Development Companies in USA

Looking for the best web development companies in the USA? We’ve got you covered! Check out our top 10 picks to find the right partner

Clean Energy Adoption

Inside Michigan’s Clean Energy Revolution

Democratic state legislators in Michigan continue to discuss and debate clean energy legislation in the hopes of establishing a comprehensive clean energy strategy for the

Chips Act Revolution

European Chips Act: What is it?

In response to the intensifying worldwide technology competition, Europe has unveiled the long-awaited European Chips Act. This daring legislative proposal aims to fortify Europe’s semiconductor

USA Companies

Top Software Development Companies in USA

Navigating the tech landscape to find the right partner is crucial yet challenging. This article offers a comparative glimpse into the top software development companies in the USA. Through a

Software Development

Top Software Development Companies

Looking for the best in software development? Our list of Top Software Development Companies is your gateway to finding the right tech partner. Dive in and explore the leaders in

India Web Development

Top Web Development Companies in India

In the digital race, the right web development partner is your winning edge. Dive into our curated list of top web development companies in India, and kickstart your journey to

USA Web Development

Top Web Development Companies in USA

Looking for the best web development companies in the USA? We’ve got you covered! Check out our top 10 picks to find the right partner for your online project. Your

Clean Energy Adoption

Inside Michigan’s Clean Energy Revolution

Democratic state legislators in Michigan continue to discuss and debate clean energy legislation in the hopes of establishing a comprehensive clean energy strategy for the state. A Senate committee meeting

Chips Act Revolution

European Chips Act: What is it?

In response to the intensifying worldwide technology competition, Europe has unveiled the long-awaited European Chips Act. This daring legislative proposal aims to fortify Europe’s semiconductor supply chain and enhance its

Revolutionized Low-Code

You Should Use Low-Code Platforms for Apps

As the demand for rapid software development increases, low-code platforms have emerged as a popular choice among developers for their ability to build applications with minimal coding. These platforms not

Cybersecurity Strategy

Five Powerful Strategies to Bolster Your Cybersecurity

In today’s increasingly digital landscape, businesses of all sizes must prioritize cyber security measures to defend against potential dangers. Cyber security professionals suggest five simple technological strategies to help companies

Global Layoffs

Tech Layoffs Are Getting Worse Globally

Since the start of 2023, the global technology sector has experienced a significant rise in layoffs, with over 236,000 workers being let go by 1,019 tech firms, as per data

Huawei Electric Dazzle

Huawei Dazzles with Electric Vehicles and Wireless Earbuds

During a prominent unveiling event, Huawei, the Chinese telecommunications powerhouse, kept quiet about its enigmatic new 5G phone and alleged cutting-edge chip development. Instead, Huawei astounded the audience by presenting

Cybersecurity Banking Revolution

Digital Banking Needs Cybersecurity

The banking, financial, and insurance (BFSI) sectors are pioneers in digital transformation, using web applications and application programming interfaces (APIs) to provide seamless services to customers around the world. Rising

FinTech Leadership

Terry Clune’s Fintech Empire

Over the past 30 years, Terry Clune has built a remarkable business empire, with CluneTech at the helm. The CEO and Founder has successfully created eight fintech firms, attracting renowned

The Role Of AI Within A Web Design Agency?

In the digital age, the role of Artificial Intelligence (AI) in web design is rapidly evolving, transitioning from a futuristic concept to practical tools used in design, coding, content writing

Generative AI Revolution

Is Generative AI the Next Internet?

The increasing demand for Generative AI models has led to a surge in its adoption across diverse sectors, with healthcare, automotive, and financial services being among the top beneficiaries. These

Microsoft Laptop

The New Surface Laptop Studio 2 Is Nuts

The Surface Laptop Studio 2 is a dynamic and robust all-in-one laptop designed for creators and professionals alike. It features a 14.4″ touchscreen and a cutting-edge design that is over

5G Innovations

GPU-Accelerated 5G in Japan

NTT DOCOMO, a global telecommunications giant, is set to break new ground in the industry as it prepares to launch a GPU-accelerated 5G network in Japan. This innovative approach will

AI Ethics

AI Journalism: Balancing Integrity and Innovation

An op-ed, produced using Microsoft’s Bing Chat AI software, recently appeared in the St. Louis Post-Dispatch, discussing the potential concerns surrounding the employment of artificial intelligence (AI) in journalism. These

Savings Extravaganza

Big Deal Days Extravaganza

The highly awaited Big Deal Days event for October 2023 is nearly here, scheduled for the 10th and 11th. Similar to the previous year, this autumn sale has already created

Cisco Splunk Deal

Cisco Splunk Deal Sparks Tech Acquisition Frenzy

Cisco’s recent massive purchase of Splunk, an AI-powered cybersecurity firm, for $28 billion signals a potential boost in tech deals after a year of subdued mergers and acquisitions in the

Iran Drone Expansion

Iran’s Jet-Propelled Drone Reshapes Power Balance

Iran has recently unveiled a jet-propelled variant of its Shahed series drone, marking a significant advancement in the nation’s drone technology. The new drone is poised to reshape the regional

Solar Geoengineering

Did the Overshoot Commission Shoot Down Geoengineering?

The Overshoot Commission has recently released a comprehensive report that discusses the controversial topic of Solar Geoengineering, also known as Solar Radiation Modification (SRM). The Commission’s primary objective is to

Remote Learning

Revolutionizing Remote Learning for Success

School districts are preparing to reveal a substantial technological upgrade designed to significantly improve remote learning experiences for both educators and students amid the ongoing pandemic. This major investment, which

Revolutionary SABERS Transforming

SABERS Batteries Transforming Industries

Scientists John Connell and Yi Lin from NASA’s Solid-state Architecture Batteries for Enhanced Rechargeability and Safety (SABERS) project are working on experimental solid-state battery packs that could dramatically change the

Build a Website

How Much Does It Cost to Build a Website?

Are you wondering how much it costs to build a website? The approximated cost is based on several factors, including which add-ons and platforms you choose. For example, a self-hosted