Updating db via xml

Using XML files to cache often-used, but seldom changed data such as US state codes, employee types and other validation tables can avoid network roundtrips and speed up your application.

In addition, XML files are great for off-line applications where a user needs to add, edit and delete data when they can’t connect to a database.

User variables can be especially useful when you want to insert data from an XML file into table columns whose names do not match those of the XML fields.

To see how this works, we first create a table named This happens because the My SQL server looks for field names matching the column names of the target table.

An XML data file called is located in the \Xml folder of the Silverlight sample project for this article.

It is extremely easy to use PHPMy Admin to do any kind of importing or exporting of data and it is available to you for free.

All you really need is a good tutorial that shows you how to use the PHPMy Admin tool.

Word Press uses My SQL database and one of the benefits of My SQL database is that you can easily import or export data to and from any My SQL database table.

Many people probably do not know that there is a great tool called PHPMyadmin that you can access from your c Panel (most hosting provider will offer c Panel with your hosting account for free).


Leave a Reply