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 ]