Clever Geek Handbook

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


source to share


4 answers


Use XSL Transform to create insert statement.



0


source


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


source


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


source


can't use xsl transform, you need string to query and not another xml

0


source






More articles:


All Articles