Database table convert to xml document to cache

•

What is DaniWeb IT Discussion Community?

You're currently browsing the VB.NET section within the Software Development category of DaniWeb, a massive community of 397,802 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,450 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our VB.NET advertiser:

Thread Tools Display Modes

Views: 3317 | Replies: 1

•

Join Date: Mar 2005

Posts: 65

Reputation: cpopham is an unknown quantity at this point

Rep Power: 4

Solved Threads: 0

cpopham

Offline

Junior Poster in Training

Database table convert to xml document to cache

Aug 8th, 2006

I am building a website. I have a database table that contains tips. The tips table is simple, it contains an ID column and a Tip column. I have a datareader to read the table and fill a datatable, however, I would rather have the datareader create a cached xml document. I know how to read an xml file into cache with code, but I would like for the datareader to create a cached xml document.

Does anyone know how to accomplish this task?

Thanks, Chester

•

Join Date: Mar 2006

Posts: 219

Reputation: Lord Soth is an unknown quantity at this point

Rep Power: 3

Solved Threads: 2

Lord Soth

Offline

Posting Whiz in Training

Re: Database table convert to xml document to cache

Aug 13th, 2006

Hi,

If you want to avoid DB access for tips you can fill a dataset with a datatable containing the tips table for once and use save DataSet.WriteXML() to export the data to XML format. Then for re using you don't need to use XMLDocument or anything but you can directly use DataSet.ReadXML().

Loren Soth

Crimson K. Software _________________________________________________________________ Crimson K. Blog