XMLDOM save

[Dikkuuhh]

I must get a lot of information out of my database into a XMLDOM. The
database part is done, all the information is in SQLDataReaders, but
how can i convert all that information into a XMLDOM??

I must get it nice so i can load the information later..

Greetz Koen

[Martin Honnen]

Dikkuuhh wrote:

I must get a lot of information out of my database into a XMLDOM. The
database part is done, all the information is in SQLDataReaders, but
how can i convert all that information into a XMLDOM??

What are you using, the Microsoft .NET Framework? That has an
SqlDataReader you can create with the ExecuteReader method of an SqlCommand.
But SqlComand also has method ExecuteXmlReader so you can do e.g.
XmlDocument xmlDocument = new XmlDocument();
xmlDocument.Load(sqlCommandInstance.ExecuteXmlRead er());
xmlDocument.Save(@"file.xml");
Check the MSDN documentation about ExecuteXmlReader, it works only with
special FOR XML SQL commands issued:
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataSqlClientSqlCommandClassExecuteXmlR eaderTopic.asp>

--

Martin Honnen
http://JavaScript.FAQTs.com/

[Dikkuuhh]

I`m using ASP.NET 2.0, but i don`t understand what you are saying...

Do you have a small sample code where it happens??

Thanx

Koen

Martin Honnen wrote:

Dikkuuhh wrote:

I must get a lot of information out of my database into a XMLDOM. The
database part is done, all the information is in SQLDataReaders, but
how can i convert all that information into a XMLDOM??

What are you using, the Microsoft .NET Framework? That has an
SqlDataReader you can create with the ExecuteReader method of an SqlCommand.
But SqlComand also has method ExecuteXmlReader so you can do e.g.
XmlDocument xmlDocument = new XmlDocument();
xmlDocument.Load(sqlCommandInstance.ExecuteXmlRead er());
xmlDocument.Save(@"file.xml");
Check the MSDN documentation about ExecuteXmlReader, it works only with
special FOR XML SQL commands issued:
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataSqlClientSqlCommandClassExecuteXmlR eaderTopic.asp>

--

Martin Honnen
http://JavaScript.FAQTs.com/

[Martin Honnen]

Dikkuuhh wrote:

I`m using ASP.NET 2.0, but i don`t understand what you are saying...

Do you have a small sample code where it happens??

I did post a code sample and a link to the documentation of the method
ExecuteXmlReader.
Here is more about that
<http://samples.gotdotnet.com/quickstart/howto/doc/adoplus/xmlfromsqlsrv.aspx>
--

Martin Honnen
http://JavaScript.FAQTs.com/

[Dikkuuhh]

I`m a newbie if it comes to xml so i didn`t get result in your sample
and your link.....

Can you give me a small sample working?

Many thanx,

Koen
Martin Honnen wrote:

Dikkuuhh wrote:

I`m using ASP.NET 2.0, but i don`t understand what you are saying...

Do you have a small sample code where it happens??

I did post a code sample and a link to the documentation of the method
ExecuteXmlReader.
Here is more about that
<http://samples.gotdotnet.com/quickstart/howto/doc/adoplus/xmlfromsqlsrv.aspx>
--

Martin Honnen
http://JavaScript.FAQTs.com/

[Martin Honnen]

Dikkuuhh wrote:

I`m a newbie if it comes to xml so i didn`t get result in your sample
and your link.....

Can you give me a small sample working?

I did post a sample, I also posted links to documentation and more
complete samples. If you can't work with them then you would at least to
explain in detail what you have tried, where it failed to get further
help. But I suggest you then take the questions to an appropriate
Microsoft group.

--

Martin Honnen
http://JavaScript.FAQTs.com/