1:-XSLT file: Books.xsl
This is your XSLT file code
-------------------------------
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>
<xsl:template match="/">
<books>
<xsl:apply-templates select="//book"/>
</books>
</xsl:template>
<xsl:template match="book">
<xsl:if test="price > 200">
<book>
<xsl:attribute name="name">
<xsl:value-of select="name"/>
</xsl:attribute>
<xsl:attribute name="specialization">
<xsl:value-of select="specialization"/>
</xsl:attribute>
<xsl:attribute name="author">
<xsl:value-of select="author"/>
</xsl:attribute>
<xsl:attribute name="publication">
<xsl:value-of select="publication"/>
</xsl:attribute>
<xsl:attribute name="price">
<xsl:value-of select="price"/>
</xsl:attribute>
</book>
</xsl:if>
</xsl:template>
</xsl:stylesheet>
--------------------------
2:-GridView Control
------------------------
add a gridview control in your web page with xmlDataSource as follows:
<asp:GridView ID="gvXML" runat="server" DataSourceID="XmlDataSource1">
<HeaderStyle BackColor="Gray" />
</asp:GridView>
<asp:XmlDataSource ID="XmlDataSource1" runat="server" TransformFile="~/BindGridView.xsl">
</asp:XmlDataSource>
Note:This control always look data in <book name="ask" price="1220"> </book>
format
----------------------------
3:-C# code
Add this code in your Code-Behind file
--------------------------
SqlConnection myCon = new SqlConnection(@"data source=192.168.2.200\sql2k;uid=sa;pwd=bench;database=DMS1");
SqlDataAdapter da = new SqlDataAdapter("select name, price, specialization, author, publication from book", myCon);
DataSet ds = new DataSet();
ds.DataSetName = "books";
da.Fill(ds, "book");
xmlDataSource2.Data = ds.GetXml();
After doing the above steps you will get the following output
| name | specialization | author | publication | price |
|---|---|---|---|---|
| ASP.Net 3.5 | Web Programming Using C# and VB | Bill Thomas | Wrox | 560.00 |
| C# 3.5 | C# 2008 Powered by Microsoft | Microsoft Team | Wrox | 600.00 |
