Click here to Skip to main content
15,922,894 members
Home / Discussions / C#
   

C#

 
GeneralRe: A strange question I think Pin
Christer Claesson17-May-04 13:07
Christer Claesson17-May-04 13:07 
GeneralRe: A strange question I think Pin
Colin Angus Mackay18-May-04 0:42
Colin Angus Mackay18-May-04 0:42 
GeneralMailto via code with attachment option Pin
myNameIsRon17-May-04 10:26
myNameIsRon17-May-04 10:26 
GeneralRe: Mailto via code with attachment option Pin
Heath Stewart17-May-04 10:52
protectorHeath Stewart17-May-04 10:52 
Generalregd Datagrid Pin
karteek17-May-04 8:39
karteek17-May-04 8:39 
GeneralRe: regd Datagrid Pin
Heath Stewart17-May-04 8:53
protectorHeath Stewart17-May-04 8:53 
GeneralRe: regd Datagrid Pin
Jay Shankar17-May-04 23:11
Jay Shankar17-May-04 23:11 
GeneralRe: regd Datagrid Pin
karteek17-May-04 23:19
karteek17-May-04 23:19 
GeneralRe: regd Datagrid Pin
Jay Shankar17-May-04 23:38
Jay Shankar17-May-04 23:38 
Generalmanaging the edit of a dataGrid Pin
HappyPaws17-May-04 8:36
HappyPaws17-May-04 8:36 
GeneralRe: managing the edit of a dataGrid Pin
Heath Stewart17-May-04 8:51
protectorHeath Stewart17-May-04 8:51 
GeneralDirectShow filters Pin
ro_angel_bv17-May-04 8:36
ro_angel_bv17-May-04 8:36 
Generalinterface members as internal Pin
Mike Hodnick17-May-04 7:50
Mike Hodnick17-May-04 7:50 
GeneralRe: interface members as internal Pin
Heath Stewart17-May-04 8:03
protectorHeath Stewart17-May-04 8:03 
GeneralRe: interface members as internal Pin
Mike Hodnick17-May-04 9:26
Mike Hodnick17-May-04 9:26 
GeneralBitmap file Pin
Saleh Alshadheli17-May-04 6:45
Saleh Alshadheli17-May-04 6:45 
GeneralRe: Bitmap file Pin
Dave Kreskowiak17-May-04 6:55
mveDave Kreskowiak17-May-04 6:55 
GeneralRe: Bitmap file Pin
Heath Stewart17-May-04 7:21
protectorHeath Stewart17-May-04 7:21 
GeneralPotential Field Algorithms Pin
sodium17-May-04 6:45
sodium17-May-04 6:45 
GeneralRe: Potential Field Algorithms Pin
Dave Kreskowiak17-May-04 7:14
mveDave Kreskowiak17-May-04 7:14 
GeneralRe: Potential Field Algorithms Pin
sodium17-May-04 20:11
sodium17-May-04 20:11 
GeneralRe: Potential Field Algorithms Pin
Dave Kreskowiak18-May-04 0:08
mveDave Kreskowiak18-May-04 0:08 
GeneralConverting xsd to csv using xslt Pin
tunde17-May-04 6:44
tunde17-May-04 6:44 
Smile | :) I am having a problem with xsd convertion to csv file. The code below describes how I attempted to approach the problem. The code works but the output is not properly format.

ObjBISReports As DsReports (a type dataset)
.. after the dataset has been filled using sqldatadapter
ObjBISReports.WriteXml("C:\Tunde.xml", XmlWriteMode.IgnoreSchema)

Dim xslt As New XslTransform()
xslt.Load("F:\Alliance International\Projects\AIA Database Application\Application2\Components\GetOutStanding.xslt")

Dim doc As New XmlDocument()
doc.Load("C:\Tunde.xml")

'Create an XmlTextWriter which outputs to a file.
Dim fileName As String = "C:\tunde.csv"

Dim writer As XmlWriter = New XmlTextWriter(fileName, Nothing)

'Transform the data and send the output to the console.
xslt.Transform(doc, Nothing, writer)
writer.Close()

This is the stylesheet format:

"<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>

<xsl:template match="DsReports">
<xsl:apply-templates select="GetOutStandingBills"/>
</xsl:template>

<xsl:template match="GetOutStandingBills">
<xsl:for-each select="*">
<xsl:value-of select="."/>
<xsl:if test="position() != last()">
<xsl:value-of select="','"/>
</xsl:if>
</xsl:for-each>
<xsl:text>&#10;</xsl:text>
</xsl:template>

</xsl:stylesheet>"

Please if anyone knows a much effective means of converting xsd to csv or excel could you let me know.
Thank You




Tunde Olawuwo
GeneralRe: Converting xsd to csv using xslt Pin
Heath Stewart17-May-04 7:17
protectorHeath Stewart17-May-04 7:17 
GeneralRe: Converting xsd to csv using xslt Pin
tunde17-May-04 13:02
tunde17-May-04 13:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.