FabRed
asked on
Import data from XML file to database table.
Hi.
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:
firstname
lastname
address
postalcode
city
e-mail
telephone
Can someone pls help me with some code to accomplish this?!? I am using Visual Studio, visual basic and SQL Server.
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:
firstname
lastname
address
postalcode
city
telephone
Can someone pls help me with some code to accomplish this?!? I am using Visual Studio, visual basic and SQL Server.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.