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]

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.ExecuteXmlReader());
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/d...lientSqlCommandClassExecuteXmlReaderTopic.asp>

 

[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]

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>

 

[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]

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.