如何将sql xml列转换为XMLDocument？ [英] How to convert sql xml column to XMLDocument ?

问题描述

我在SQL中有一列

I have a column in SQL

CREATE TABLE [dbo].[SYS_LookUpTableSettings](
    [TableName] [varchar](150) NOT NULL,
    [FormWidth] [int] NULL,
    [FormHeight] [int] NULL,
    [ListViewStyleXML] [xml] NULL,
 CONSTRAINT [PK_SYS_LookUpTableSettings] PRIMARY KEY CLUSTERED

i想用这个xml映射到Listview列..

如何使用xm转换此列ListViewStyleXML l数据类型为XmlDocument ..











问候

Sun ..

i want to use this xml to mapping to Listview column..
how can i convert this column ListViewStyleXML using xml datatype to XmlDocument..





Regards
Sun..

推荐答案

请参阅：批量导入和导出XML文档（SQL Server）的示例 [ ^ ] - E部分。

See this: Examples of Bulk Import and Export of XML Documents (SQL Server)[^] - section E.

xmlDoc.LoadXml（String xml get from database）

xmlDoc.LoadXml("String xml get from database")

我假设您按照 http://msdn.microsoft.com/en-us/library/system.xml.xmldocument%28v=vs.110%29.aspx [ ^ ]



这个对象支持LoadXml方法和解决方案2提示非常简短。



（请考虑使用XDocument。）

当您在dot net中读取XML列时，它变为XmlType < a href =http://msdn.microsoft.com/en-us/library/system.data.sqltypes.sqlxml%28v=vs.110%29.aspx> http://msdn.microsoft.com/en -us / library / system.data.sqltypes.sqlxml％28v = vs.110％29.aspx [ ^ ]



这最终是一个XmlReader对象，你可以像这样操作：

I assume you man the specific XmlDocument object as defined in http://msdn.microsoft.com/en-us/library/system.xml.xmldocument%28v=vs.110%29.aspx[^]

This object support LoadXml method and solution 2 hints that very briefly.

(Consider using XDocument instead.)
When you read an XML column in dot net, it becomes a XmlType http://msdn.microsoft.com/en-us/library/system.data.sqltypes.sqlxml%28v=vs.110%29.aspx[^]

This is ultimately an XmlReader object which you could manipulate like this:

static void Main(string[] args)
        {
            using (var mem = new MemoryStream())
            {
                /* Simulates your XmlType data field */
                var writer = new StreamWriter(mem);
                var xml = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?><root><data>chicks</data></root>";
                writer.Write(xml);
                writer.Flush();
                mem.Position = 0;
                XmlReader rdr = XmlReader.Create(mem);

                /*Example of manimuplating data*/
                var xdoc = XDocument.Load(rdr);
                IEnumerable<XElement> found = xdoc.Root.Elements("data");
                Console.WriteLine("my data was: " + found.First().Value);
                Console.ReadKey();

            }
        }

这篇关于如何将sql xml列转换为XMLDocument？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！