数据插入XML到sqlserver [英] Data insert xml to sqlserver

问题描述

嗨
我有xml格式的数据.但是我在sqlserver表中插入了相同的数据.

使用asp.net编码是C#

如何????????????

帮助我.......

Hi
i have data in xml format. but i insert the same data in sqlserver tables.

using asp.net coding is C#

how ????????????

help me.......

推荐答案

SQL确实具有很好的XML支持.在MSDN上阅读并尝试一下.如果您无法解决特定的问题，请不要犹豫地发布.

SQL does have a very good XML support. Read about it on MSDN and give it a try. Do not hesitate to post a specific question if you are not able to work your way through it.

使用LINQ从XML获取数据
或使用DATASET或DATATABLE [datasetObj.ReadXML()或datatableObj.ReadXML()]读取XML.

遍历已获取的Record，并将其插入所需的表中.
希望对您有帮助...

Fetch data from XML using LINQ
or Read XML using DATASET or DATATABLE [datasetObj.ReadXML() or datatableObj.ReadXML()].

Iterate through Record you have acquired and insert it into your desired table.
Hope it will help you......

要添加到以前的答案，这是MSDN中的一个起点:

To add to previous answers, here''s one starting point in MSDN: http://msdn.microsoft.com/en-us/library/ms189887.aspx[^]

这篇关于数据插入XML到sqlserver的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！