|
Posted by John Bell on 09/07/05 21:31
Hi
http://www.perfectxml.com/Articles/XML/ExportSQLXML.asp#5 is an example of
using writexml. Having elements in separate lines will depend on the
stylesheet used to display the data, have you tried looking at it with
Internet Explorer or XML Notepad?
John
"Piyoosh Rai" <3.something@gmail.com> wrote in message
news:NeETe.41$OD.2359@news.uswest.net...
> Hi guys,
>
> I have been trying to write data from a database to XML files and
> although i have been successful in doing that, the file(s) that are made
> are not of the form that I would want.
>
> I am using:
> SQLDataSet.WriteXml(strFileName, XmlWriteMode.WriteSchema);
>
> to generate the files where strFileName is the name of the file. The
> files when viewed with XML Editor are seen as lines of data instead of
> the regularly generated XML where each row is one below the other. When
> viewed with WordPad/Notepad i see elements />< betweeen the data
> and somehow I think this has to do something with the problem.
>
> Can someone help me with this?? Any help or suggestion would be greatly
> appreciated.
>
> Thanks.
>
> *** Sent via Developersdex http://www.developersdex.com ***
[Back to original message]
|