|
|
Posted by John Bell on 09/14/05 00:04
Hi
It is still not clear! Maybe you could post some DDL, example data (as
insert statements) and the current output.
Here is an example that may help:
http://www.perfectxml.com/Articles/XML/ExportSQLXML.asp#3
John
"Piyoosh Rai" <3.something@gmail.com> wrote in message
news:PeDVe.13$YM2.1271@news.uswest.net...
>
> Hi guys,
>
> Apologies Simon for not making it clearer last time. What i am doing is
> reading a table from the SQL Server 2000 database and using:
>
> SQLDataSet.WriteXml(strFileName, XmlWriteMode.WriteSchema);
>
> to write to the DataSet. But I realised that when I do that the XML is
> generated correctly, the only error being that
> <xs:element name="Table"> comes in as the tablename instead of the
> actual table name.
>
> Any suggestions will be appreciated. Thank you.
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
Navigation:
[Reply to this message]
|