OleDb2Xml
page 1 of 1
Published: 03 Oct 2003
Unedited - Community Contributed
Abstract
The ASP.NET Dataset makes using XML in your web pages easy. But, what if all your data is in a database how do you convert it to XML? If you are using a database that is compatible with OleDb, this utility will quickly convert your database tables to XML.
by Andrew Mooney
Feedback
Average Rating: 
Views (Total / Last 10 Days): 15530/ 25

Quickly Convert Your OleDb Database to XML Files.

The ASP.NET Dataset makes using XML in your web pages easy. But, what if all your data is in a database how do you convert it to XML? If you are using a database that is compatible with OleDb, this utility will quickly convert your database tables to XML files. The following code sample will make a new XML file for every table in your database. The download contains the web page source in both C#.NET and VB.NET.

When using this utility on large databases you may find that the responseDeadlockInterval property of the processModel in the machine.config file's default setting of three minutes is not long enough to complete the conversion. To change the responseDeadlockInterval you can edit the machine.config file, which should be in the following location: %systemroot%\Microsoft.NET\Framework\v1.0.3705\CONFIG\machine.config. Look for the processModel section and change the responseDeadlockInterval. In my example I changed it to five minutes.

[ Run Sample ] | [ View Source ] | [ Download ]



User Comments

No comments posted yet.






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2017 ASPAlliance.com  |  Page Processed at 2017-02-19 11:42:19 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search