Working With XML Server Control in ASP.NET

Megha Goyal
12y
21.4k
0
1

Article

Suppose a Webshop wants to create a Web application that can store the details of the books available for sale in XML format and we want to store the details of the books and display them in tabular format. To show the data in tabular format we will use the XSLT file and a XML server control.

Let's have a look at the following steps:

Step 1

Go to the Visual Studio 2010.

Step 2

Click on File -> New -> WebSite.

Step 3

Now select the ASP.NET Website template from the available templates.

Step 4

Now give the name to your application and click on the ok button.

Step 5

Now right-click on the project name in the Solution Explorer and select Add New Item from it.

Step 6

Now select the XML File template from the available templates.

Step 7

Now give the name to your file .i.e. book.xml and click the Add button.

Step 8

Now add the following code in this file and press ctrl+s to save this file.

<?xml version="1.0" encoding="utf-8" ?>
<Books>
<Book>
    <BookId>B001</BookId>
    <Title>Getting Started with XML</Title>
    <Price>$2.5</Price>
    <Author>
      <FirstName>Micheal</FirstName>
      <LastName>Hicks</LastName>
    </Author>
    <Author>
      <FirstName>John</FirstName>
      <LastName>Williams</LastName>
    </Author>
</Book>
<Book>
    <BookId>B002</BookId>
    <Title>Understanding XML</Title>
    <Price>$22.15</Price>
    <Author>
      <FirstName>David</FirstName>
      <LastName>Simpson</LastName>
    </Author>
</Book>
</Books>

Step 9

Now again right-click on the project name in Solution Explorer and select Add New Item.

Step 10

Now select XSLT file from the available templates.

Step 11

Now give a name to your file and click on the Add button.

Step 12

Now add the following code in this file named my_stylesheet.xsl.

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="Author">
    <xsl:value-of select="FirstName"/>
    <xsl:value-of select="LastName"/>
    <xsl:if test="position()!=last()">, </xsl:if>
</xsl:template>
<xsl:template match="/">
<html>
    <head>
      <title>Books at webshop</title>
    </head>
    <body>
      <h1>Books at webshop</h1>
      <table border="3" cellspacing="2" cellpadding="6">
        <thead align="center" bgcolor="silver">
          <th>Book Id</th>
          <th>Title</th>
          <th>price</th>
          <th>Author(s)</th>
        </thead>
        <tbody>
          <xsl:for-each select="Books/Book">
            <tr>
              <td>
                <font color="green">
                  <xsl:value-of select="BookId"/>
                </font>
              </td>
              <td>
                <xsl:value-of select="Title"/>
              </td>
              <td>
                <xsl:value-of select="Price"/>
              </td>
              <td>
                <xsl:apply-templates select="Author"/>
              </td>
            </tr>

          </xsl:for-each>
        </tbody>
      </table>
    </body>
</html>
</xsl:template>
</xsl:stylesheet>