Import data from XML file to database table.
Posted on 2006-05-04
I am trying to learn how to use XML files (I have never worked with XML before!), and need some help. What I wish to do is to import customer-data from a XML-file (customer.xml, which is saved in my projects bin-folder in the Debug folder.) to my database table called customer.
When the user clicks on import customerdata the system is supposed to read the customer.xml file and save the customer information in the customer table. When the transfer is complete the system is to write a message to the user telling how many customers that was imported.
The customer table is like this:
Can someone pls help me with some code to accomplish this?!? I am using Visual Studio, visual basic and SQL Server.