Hi at all 
!
Since the last days I'm writing on a small database application based on SQL-Server Express.
The database consists of multiple tables. One table for example has two coloumns ("ICAO-Code" and "Airport").
Now to the point. The application should be able to import Data from an XML-File. Let's show it:
<icaocode>EDDK</icaocode>
<airport>Koln/Bonn</airport>
The Innertext-Values from those nodes should be written in the coloumns from my Table in the SQL Server-Database.
How I can do this effectively (There are 100 and more nodes!)
Thank you very much...
P.S.: I would be very happy if you'll have a code-example......but if you have not an example, I won't be angry...
Reading XML into SQL-Server
mikecoop83
Simplest way to code this is probably to import the file into a DataSet, then write the dataset to the database using SqlDataAdapter + SqlCommand, etc. You might need to tweak the command text to map the element/columns names correctly.
MSDN has some useful articles explaining how to use DataSet, including code snippets. http://msdn.microsoft.com/library/default.asp url=/library/en-us/vbcon/html/vboricodeexamplesfordataaccess.asp