Exporting from XMLReader to an XML file

[Leszek]

Hello,

I have an XmlReader object containg some Xml code. I would like to export
this document from the reader to an Xml file.

How to do this?

Thanks for any hints,
Leszek Taratuta

Below there is the code I'm using:
string myXmlQuery = "SELECT 1 AS Tag, NULL AS Parent, [Filename] AS
[Content!1!Filen ame!element], [Caption] AS [Content!1!Capti on!element],
[Content] AS [Content!1!!CDAT A] FROM Content FOR XML EXPLICIT";

SqlConnection myConnection = new SqlConnection(" data
source=WEBSERVE R;database=myDB ;user id=;password=);

try

{

myConnection.Op en();

SqlCommand myCommand = new SqlCommand(myXm lQuery, myConnection);

System.Xml.XmlR eader myXmlReader = myCommand.Execu teXmlReader();

string output="";

output = "<?xml version=\"1.0\" encoding=\"utf-8\"?>";

output += "<Contents> ";

while (myXmlReader.Re ad())

{

string tmp = "";

// ERROR: It does not generate the closing tag!

if (myXmlReader.Na me != "") tmp += "<"+myXmlReader .Name+">";

if (myXmlReader.Va lue != "") tmp += myXmlReader.Val ue;

output += tmp;

}

output += "</Contents>";

myConnection.Cl ose();

if (myXmlReader != null) myXmlReader.Clo se();

// Save the modified XML document.

FileStream file = File.Create(@"c :\test.xml");

StreamWriter myWriter = new StreamWriter(fi le);

myWriter.Write( output);

myWriter.Close( );

// Close the XmlReader

myXmlReader.Clo se();

}

catch(Exception exc)

{

MessageBox.Show (exc.ToString() +"\n\n"+exc.Get Type());

}

finally

{

myConnection.Cl ose();

}

[Oleg Tkachenko]

Leszek wrote:

I have an XmlReader object containg some Xml code. I would like to export
this document from the reader to an Xml file.

How to do this?
Using XmltexWriter obviously.

XmlWriter w = new XmlTextWriter(" foo.xml", Encoding.UTF8);
reader.MoveToCo ntent();
w.WriteNode(rea der);
w.Close();
output = "<?xml version=\"1.0\" encoding=\"utf-8\"?>";

Oh, please, don't use this technique. It's year 2003 today, not 1999.
Always use XML classes (e.g. XmlTextWriter) to produce XML.
--
Oleg Tkachenko
XmlInsider
http://blog.tkachenko.com

[Leszek]

Thanks. It works fine, although there is another problem related to
obtaining well-formed XML code from the SQL database. I can't generate a
root wrapper for the code, so the XmlTextWriter.W riteNode() method exports
only the first branch instead of the whole document.
Below there is code I am using:

// The following query generates a bunch of <Content> elements witout a root
wrapper!
string myXmlQuery = "SELECT 1 AS Tag, " +
" NULL AS Parent, " +
" [Filename] AS [Content!1!Filen ame!element], "
+
" [Caption] AS [Content!1!Capti on!element], " +
" [Content] AS [Content!1!!CDAT A] " +
"FROM Content " +
"WHERE IsRemoved=0 " +
"FOR XML EXPLICIT;" +

// Create a new connection to a SQL Srv database
SqlConnection myConnection = new SqlConnection(" ...");

try
{
myConnection.Op en();

// Generate XML code. Put the code into the reader.
SqlCommand myCommand = new SqlCommand(myXm lQuery, myConnection);
System.Xml.XmlR eader reader = myCommand.Execu teXmlReader();

// Write XML code to an output file (only the first <Content>elemen t
is written)
System.Xml.XmlT extWriter writer = new
System.Xml.XmlT extWriter(@"c:\ test.xml", Encoding.UTF8);
reader.MoveToCo ntent();
writer.WriteNod e(reader, false);

// Close
reader.Close();
writer.Close();
}
catch(Exception exc)
{
// O kurcze, something went wrong
MessageBox.Show (exc.ToString() +"\n\n"+exc.Get Type());
}
finally
{
myConnection.Cl ose();
}

I would appreciate any help.
Thanks,

Leszek Taratuta

"Oleg Tkachenko" <oleg@NO!SPAM!P LEASEtkachenko. com> wrote in message
news:O0******** ******@TK2MSFTN GP11.phx.gbl...

Leszek wrote:

I have an XmlReader object containg some Xml code. I would like to export this document from the reader to an Xml file.

How to do this?

Using XmltexWriter obviously.

XmlWriter w = new XmlTextWriter(" foo.xml", Encoding.UTF8);
reader.MoveToCo ntent();
w.WriteNode(rea der);
w.Close();

output = "<?xml version=\"1.0\" encoding=\"utf-8\"?>";

Oh, please, don't use this technique. It's year 2003 today, not 1999.
Always use XML classes (e.g. XmlTextWriter) to produce XML.
--
Oleg Tkachenko
XmlInsider
http://blog.tkachenko.com

[Scott Caskey [MSFT]]

You could try:

writer.WriteSta rtElement("root ");
writer.WriteRaw (reader.ReadOut erXml, false);
writer.WriteEnd Element();

This should wrap your xml inside a root node.

Scott

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Leszek" <ta******@5thbu siness.com> wrote in message
news:Oq******** ******@tk2msftn gp13.phx.gbl...

Thanks. It works fine, although there is another problem related to
obtaining well-formed XML code from the SQL database. I can't generate a
root wrapper for the code, so the XmlTextWriter.W riteNode() method exports
only the first branch instead of the whole document.
Below there is code I am using:

// The following query generates a bunch of <Content> elements witout a root wrapper!
string myXmlQuery = "SELECT 1 AS Tag, " +
" NULL AS Parent, " +
" [Filename] AS [Content!1!Filen ame!element], " +
" [Caption] AS [Content!1!Capti on!element], " + " [Content] AS [Content!1!!CDAT A] " +
"FROM Content " +
"WHERE IsRemoved=0 " +
"FOR XML EXPLICIT;" +

// Create a new connection to a SQL Srv database
SqlConnection myConnection = new SqlConnection(" ...");

try
{
myConnection.Op en();

// Generate XML code. Put the code into the reader.
SqlCommand myCommand = new SqlCommand(myXm lQuery, myConnection);
System.Xml.XmlR eader reader = myCommand.Execu teXmlReader();

// Write XML code to an output file (only the first <Content>elemen t is written)
System.Xml.XmlT extWriter writer = new
System.Xml.XmlT extWriter(@"c:\ test.xml", Encoding.UTF8);
reader.MoveToCo ntent();
writer.WriteNod e(reader, false);

// Close
reader.Close();
writer.Close();
}
catch(Exception exc)
{
// O kurcze, something went wrong
MessageBox.Show (exc.ToString() +"\n\n"+exc.Get Type());
}
finally
{
myConnection.Cl ose();
}

I would appreciate any help.
Thanks,

Leszek Taratuta

"Oleg Tkachenko" <oleg@NO!SPAM!P LEASEtkachenko. com> wrote in message
news:O0******** ******@TK2MSFTN GP11.phx.gbl...

Leszek wrote:

I have an XmlReader object containg some Xml code. I would like to export this document from the reader to an Xml file.

How to do this?

Using XmltexWriter obviously.

XmlWriter w = new XmlTextWriter(" foo.xml", Encoding.UTF8);
reader.MoveToCo ntent();
w.WriteNode(rea der);
w.Close();

output = "<?xml version=\"1.0\" encoding=\"utf-8\"?>";

Oh, please, don't use this technique. It's year 2003 today, not 1999.
Always use XML classes (e.g. XmlTextWriter) to produce XML.
--
Oleg Tkachenko
XmlInsider
http://blog.tkachenko.com

[Leszek]

Thanks for your response.

I have tried your method but it does not work. The
writer.WriteRaw (reader.ReadOut erXml()) method does not export anything. It
seems that this is still the same problem: the XML code held by the reader
is not well-formed (there is no a root wrapper).

Does anybody have an idea how to add the root wrapper to the XML code?

Thanks,
Leszek

Below there is complete code:

// Maybe a solution would be to generate a well-formed XML document at
first place, I mean directly from the SQL Server database instead of dealing
with XML code without a root wrapper?
string myXmlQuery = "SELECT 1 AS Tag, " +
" NULL AS Parent, " +
" [Filename] AS [Content!1!Filen ame!element], "
+
" [Caption] AS [Content!1!Capti on!element], " +
" [Content] AS [Content!1!!CDAT A] " +
"FROM Content " +
"FOR XML EXPLICIT";

SqlConnection myConnection = new SqlConnection(" ...");

try
{
myConnection.Op en();
SqlCommand myCommand = new SqlCommand(myXm lQuery, myConnection);

System.Xml.XmlR eader reader = myCommand.Execu teXmlReader();
System.Xml.XmlT extWriter writer = new
System.Xml.XmlT extWriter(@"c:\ test.xml", Encoding.UTF8);

writer.WriteSta rtElement("Cont ents");
writer.WriteRaw (reader.ReadOut erXml()); // Does not write anything
:-(
writer.WriteEnd Element();

if (reader != null) reader.Close();
if (writer != null) writer.Close();
}
catch(Exception exc)
{
MessageBox.Show (exc.ToString() +"\n\n"+exc.Get Type());
}
finally
{
myConnection.Cl ose();
}

"Scott Caskey [MSFT]" <sc*****@online .microsoft.com> wrote in message
news:40******** @news.microsoft .com...

You could try:

writer.WriteSta rtElement("root ");
writer.WriteRaw (reader.ReadOut erXml, false);
writer.WriteEnd Element();

This should wrap your xml inside a root node.

Scott

--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Leszek" <ta******@5thbu siness.com> wrote in message
news:Oq******** ******@tk2msftn gp13.phx.gbl...

Thanks. It works fine, although there is another problem related to
obtaining well-formed XML code from the SQL database. I can't generate a
root wrapper for the code, so the XmlTextWriter.W riteNode() method exports only the first branch instead of the whole document.
Below there is code I am using:

// The following query generates a bunch of <Content> elements witout a root

wrapper!
string myXmlQuery = "SELECT 1 AS Tag, " +
" NULL AS Parent, " +
" [Filename] AS

[Content!1!Filen ame!element], "

+
" [Caption] AS [Content!1!Capti on!element],

" +

" [Content] AS [Content!1!!CDAT A] " +
"FROM Content " +
"WHERE IsRemoved=0 " +
"FOR XML EXPLICIT;" +

// Create a new connection to a SQL Srv database
SqlConnection myConnection = new SqlConnection(" ...");

try
{
myConnection.Op en();

// Generate XML code. Put the code into the reader.
SqlCommand myCommand = new SqlCommand(myXm lQuery, myConnection);
System.Xml.XmlR eader reader = myCommand.Execu teXmlReader();

// Write XML code to an output file (only the first

<Content>elemen t

is written)
System.Xml.XmlT extWriter writer = new
System.Xml.XmlT extWriter(@"c:\ test.xml", Encoding.UTF8);
reader.MoveToCo ntent();
writer.WriteNod e(reader, false);

// Close
reader.Close();
writer.Close();
}
catch(Exception exc)
{
// O kurcze, something went wrong
MessageBox.Show (exc.ToString() +"\n\n"+exc.Get Type());
}
finally
{
myConnection.Cl ose();
}

I would appreciate any help.
Thanks,

Leszek Taratuta

"Oleg Tkachenko" <oleg@NO!SPAM!P LEASEtkachenko. com> wrote in message
news:O0******** ******@TK2MSFTN GP11.phx.gbl...

Leszek wrote:

> I have an XmlReader object containg some Xml code. I would like to

export

> this document from the reader to an Xml file.
>
> How to do this?

Using XmltexWriter obviously.

XmlWriter w = new XmlTextWriter(" foo.xml", Encoding.UTF8);
reader.MoveToCo ntent();
w.WriteNode(rea der);
w.Close();

> output = "<?xml version=\"1.0\" encoding=\"utf-8\"?>";

Oh, please, don't use this technique. It's year 2003 today, not 1999.
Always use XML classes (e.g. XmlTextWriter) to produce XML.
--
Oleg Tkachenko
XmlInsider
http://blog.tkachenko.com

[Oleg Tkachenko]

Leszek wrote:

Thanks. It works fine, although there is another problem related to
obtaining well-formed XML code from the SQL database. I can't generate a
root wrapper for the code, so the XmlTextWriter.W riteNode() method exports
only the first branch instead of the whole document.

So loop over all top-level elements then:

XmlWriter w = new XmlTextWriter(" foo.xml", Encoding.UTF8);
reader.MoveToCo ntent();
while(reader.Re ad())
w.WriteNode(rea der);

--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel

[Leszek]

Thanks.
I still have some problems with well-formed XML. I generated a root wrapper
straight from SQL Server but now the XmlReader does not accept two
characters although they are within CDATA block: 'and -.

I do not understand it at all so in the meantime I exported the XML code
from SQL Server using an ugly solution: traversing all records and creating
XML tags in-fly then saving them to a text file.

Leszek

"Oleg Tkachenko" <oleg@no_!spam! _please!tkachen ko.com> wrote in message
news:Of******** ******@TK2MSFTN GP10.phx.gbl...

Leszek wrote:

Thanks. It works fine, although there is another problem related to
obtaining well-formed XML code from the SQL database. I can't generate a
root wrapper for the code, so the XmlTextWriter.W riteNode() method exports only the first branch instead of the whole document.

So loop over all top-level elements then:

XmlWriter w = new XmlTextWriter(" foo.xml", Encoding.UTF8);
reader.MoveToCo ntent();
while(reader.Re ad())
w.WriteNode(rea der);

--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel

[Oleg Tkachenko]

Leszek wrote:

I still have some problems with well-formed XML. I generated a root wrapper
straight from SQL Server but now the XmlReader does not accept two
characters although they are within CDATA block: 'and -. That sounds weird. Show us some sample.
I do not understand it at all so in the meantime I exported the XML code
from SQL Server using an ugly solution: traversing all records and creating
XML tags in-fly then saving them to a text file.

Really bad one :( But you still can use XmlWriter to build XML,
otherwise prepare to learn complete details of hardcore XML syntax.
--
Oleg Tkachenko
XmlInsider
http://blog.tkachenko.com