将XML值插入Sqlserver [英] Insert XML values into Sqlserver

问题描述

我有一个这样的XML文件

Hi,

I have an XML file like this

<details>
<detail>
<id>1</id>
<name>sample</name>
<street>xyz</street>
</detail>
</details>

现在我想只读ID和街道。我想插入数据库。

如何在Asp.net中实现这一点C＃



请帮助

提前致谢

Now I want to read only id and street. and I want to insert into databse.
How can I achieve this usin Asp.net C#

Please help
Thanks in advance

推荐答案

http://www.programcall.com/11/dotnet/how-to-read-data-from-xml-string-- and-insert-to-table-sql-server.aspx [ ^ ]

http://stackoverflow.com/questions/4758992/how-to-insert- xml-data-into-table-in-sql-server-2005 [ ^ ]

希望这会有所帮助。

http://www.programcall.com/11/dotnet/how-to-read-data-from-xml-string--and-insert-to-table-sql-server.aspx[^]
http://stackoverflow.com/questions/4758992/how-to-insert-xml-data-into-table-in-sql-server-2005[^]
Hope this will help.

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