"den 2005" <den2005@d...> wrote in message
news:ACF810FA-93F7-4B2E-8B27-C4A39416519C@m......
> This exact problem has been resolved.
>
> This works exactly what I wanted.
>
> <xsl:template match="/">
> <Products>
> <xsl:for-each select="NewDataSet/Products">
> <xsl:element name="Product">
> <xsl:attribute name="Name"><xsl:value-of
> select="ProductName"/></xsl:attribute>
> <xsl:attribute name="ID"><xsl:value-of
> select="ProductID"/></xsl:attribute>
> <UnitPrice><xsl:apply-templates select="UnitPrice" /></UnitPrice>
> <Quantity><xsl:apply-templates select="Quantity" /></Quantity>
> <ReorderLevel><xsl:apply-templates select="ReorderLevel" /></ReorderLevel>
> </xsl:element>
> </xsl:for-each>
> </Products>
> </xsl:template>
>

How about this:-

<xsl:template match="/">
 <Products>
  <xsl:for-each select="NewDataSet/Products">
   <Product Name="{ProductName}" ID="{ProductID}">
    <xsl:copy-of select="UnitPrice" />
    <xsl:copy-of select="Quantity" />
    <xsl:copy-of select="ReorderLevel" />
   </Product>
  </xsl:for-each>
 </Products>
</xsl:template>


> den2005
>
> -- 
> MCP Year 2005, Philippines
>
>
> "den 2005" wrote:
>
> > Hi everybody,
> >
> >    I need transform the xml file generated from dataset to a xml file
with 2
> > columns as attributes. Is there anyone using XSL stylesheet to transform
the
> > original xml to desired xml result? Thanks in advanced.
> >
> > Original Xml File Structure:
> > <?xml version="1.0" standalone="yes"?>
> > <NewDataSet>
> >   <Products>
> >     <ProductID>01</ProductID>
> >     <ProductName>Raffles Chips</ProductName>
> >     <UnitPrice>8.2500</UnitPrice>
> >     <Quantity>1000</Quantity>
> >     <ReorderLevel>50</ReorderLevel>
> >   </Products>
> >   <Products>
> >     <ProductID>02</ProductID>
> >     <ProductName>GG Corn Chips</ProductName>
> >     <UnitPrice>7.5000</UnitPrice>
> >     <Quantity>1000</Quantity>
> >     <ReorderLevel>50</ReorderLevel>
> >   </Products>
> >   <Products>
> >     <ProductID>03</ProductID>
> >     <ProductName>J&J V-Cut Chips</ProductName>
> >     <UnitPrice>7.5000</UnitPrice>
> >     <Quantity>2000</Quantity>
> >     <ReorderLevel>100</ReorderLevel>
> >   </Products>
> >   <Products>
> >     <ProductID>04</ProductID>
> >     <ProductName>te</ProductName>
> >     <UnitPrice>5.2500</UnitPrice>
> >     <Quantity>56</Quantity>
> >     <ReorderLevel>4</ReorderLevel>
> >   </Products>
> >   <Products>
> >     <ProductID>05</ProductID>
> >     <ProductName>Jack</ProductName>
> >     <UnitPrice>4.5000</UnitPrice>
> >     <Quantity>200</Quantity>
> >     <ReorderLevel>1</ReorderLevel>
> >   </Products>
> >   <Products>
> >     <ProductID>06</ProductID>
> >     <ProductName>GHH</ProductName>
> >     <UnitPrice>8.0000</UnitPrice>
> >     <Quantity>920</Quantity>
> >     <ReorderLevel>7</ReorderLevel>
> >   </Products>
> > </NewDataSet>
> >
> > Desired Xml Transformation(Result):
> > <?xml version="1.0" encoding="utf-8"?>
> > <Products>
> > <Product Name="Raffles Chips" ID="01">
> > <UnitPrice>8.2500</UnitPrice>
> > <Quantity>1000</Quantity>
> > <ReorderLevel>50</ReorderLevel>
> > </Product>
> > <Product Name="GG Corn Chips" ID="02">
> > <UnitPrice>7.5000</UnitPrice>
> > <Quantity>1000</Quantity>
> > <ReorderLevel>50</ReorderLevel>
> > </Product>
> > <Product Name="J&J V-Cut Chips" ID="03">
> > <UnitPrice>7.5000</UnitPrice>
> > <Quantity>2000</Quantity>
> > <ReorderLevel>100</ReorderLevel>
> > </Product>
> > <Product Name="te" ID="04">
> > <UnitPrice>5.2500</UnitPrice>
> > <Quantity>56</Quantity>
> > <ReorderLevel>4</ReorderLevel>
> > </Product>
> > <Product Name="Jack" ID="05">
> > <UnitPrice>4.5000</UnitPrice>
> > <Quantity>200</Quantity>
> > <ReorderLevel>1</ReorderLevel>
> > </Product>
> > <Product Name="GHH" ID="06">
> > <UnitPrice>8.0000</UnitPrice>
> > <Quantity>920</Quantity>
> > <ReorderLevel>7</ReorderLevel>
> > </Product>
> > </Products>
> >
> >
> > den2005
> >
> > -- 
> > MCP Year 2005, Philippines