读取XML文件以填充SQL Server表 [英] Read a XML file to populate a SQL server table

问题描述

Hello World !!!，早上好。



我正试图解决一个我以前从未工作过的问题，所以我推进了有点慢，我真的想节省时间，如果有人给我一个提示或答案或指示我一个特定的地方检查。



我需要阅读一个XML文件并从那里更新一个sql server表。一个表字段是xml类型，所以我需要注册我所使用的整个xml文件;另一个是xml文件的某些部分，例如电子发票XML文件的UUID和Stamp日期。



非常感谢高级版。



我尝试了什么：



我一直在通过互联网搜索并尝试我找到的一些建议和检查我做的旧程序，但我仍然没有达到我需要的。

解决方案

也许你可以使用 LINQToXML ，以下是C＃和VB.NET中的一些示例： LINQ to XML教程与实例| DotNetCurry [ ^

Hello World !!!, Good Morning.

I´m trying to solve a problem which I've never worked before, so I´m advancing a little bit slowly and I'd really like to save time if somebody gives me a hint or an answer or indicate me a specific place to check.

I need to read a XML File and update a sql server table from there. One the table fields is a xml-type, so I need to register the entire xml file I suposse; the other are certain parts of the xml file such as the UUID and the Stamp date of an electronic invoice XML file.

Thanks very much in advanced.

What I have tried:

I'd been searching thru the internet and trying some advices I've found and checking old programs I have made, but I still haven´t achieved what i need.

解决方案

Maybe you can use LINQToXML, here are some examples in C# and VB.NET: LINQ To XML Tutorials with Examples | DotNetCurry[^]

这篇关于读取XML文件以填充SQL Server表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！