| | |
Database table convert to xml document to cache
Please support our VB.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!
![]() |
•
•
Join Date: Mar 2005
Posts: 65
Reputation:
Solved Threads: 0
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
Does anyone know how to accomplish this task?
Thanks, Chester
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
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
Best regards,
Loren Soth
Crimson K. Software _________________________________________________________________ Crimson K. Blog
Loren Soth
Crimson K. Software _________________________________________________________________ Crimson K. Blog
![]() |
Similar Threads
- Multiple Table Reading From An Xml File (VB.NET)
- XML and hyperlink as one of the data (RSS, Web Services and SOAP)
- Append in xml document (C#)
- Searching and Comparing strings from an XML Document (Python)
- How can I create database/table images in MySQL (PHP)
- Send all items in a listBox to SQL server database table (ASP.NET)
- database table design problems (Database Design)
Other Threads in the VB.NET Forum
- Previous Thread: Validation Problems for Input Box data
- Next Thread: how to resize datagrid
| Thread Tools | Search this Thread |
"crystal .net .net2005 30minutes 2005 2008 access account arithmetic array assignment basic box button buttons center check code component connectionstring convert crystalreport data database databasesearch datagrid datagridview date design dissertation dissertations dissertationthesis dosconsolevb.net dropdownlist excel fade file-dialog firewall folder ftp generatetags hardcopy image images input insert intel isnumericfuntioncall math monitor navigate net networking opacity output passingparameters peertopeervideostreaming picturebox picturebox1 port problem problemwithinstallation project record reports" savedialog searchvb.net select serial shutdown string survey tcp temp temperature text textbox timer toolbox trim updown user useraccounts usercontrol vb vb.net vb.netcode vb.netformclosing()eventpictureboxmessagebox vb.nettoolboxvisualbasic2008sidebar vb2008 vbnet view visual visualbasic visualbasic.net visualstudio visualstudio2008 web winforms wpf





