XML for Database in ASP.NET
Using VB.NET, how do I add values from an XML file to a SQL Server database using a similar schema?
0
mmcglynn
source
to share
4 answers
Use XSL Transform to create insert statement.
0
mmcglynn
source
to share
I don't know methods from the top of your head, but you should be able to load the file into a DataTable and then use ADO.net to get it into the database (look at the SqlBulkCopy class, re using SQL Server DB).
That should give you enough words to strike a blow and find a good example.
0
AlexCuse
source
to share
The easiest way is to use the ReadSml () method of the DataSet class. Then, as the user mentions above, the dataset contains one (1) DataTable. It's pretty easy to get it in SQL.
0
user39603
source
to share
can't use xsl transform, you need string to query and not another xml
0
titus
source
to share