从SQL Server读取VB.NET中的XML数据(xml数据类型列) [英] Read XML data in VB.NET from SQL Server (xml datatype column)

问题描述

大家好，

我想知道是否有人可以帮助我或给我一个如何使用XML的示例.

我需要创建一个多语言应用程序并需要保存具有xml数据类型的sql表中的控件标题

i开始了以下操作:

创建 TABLE Windows (
ID [ int] IDENTITY ( 1 ， 1 ) PRIMARY KEY NOT NULL，
表格 nvarchar ( 50 ) NULL，
列表 xml NULL
)

DECLARE @itemString nvarchar <字体颜色=#808080" size = 2>( max )
DECLARE @itemDoc xml

SET @itemString = '< Root>
结果<值>退出</值GT;结果</数据>结果<数据名称= QUOT; btnLogin">结果<值>登录</值GT;结果< ;/data<
</Root>'

SET @itemDoc = @itemString

插入 INTO dbo . Windows SELECT 'frmLogin' ， @itemDoc

我知道这不是很专业，但这就是我所做的一切，直到在SQL中知道.

现在我在VB.NET中遇到了问题，我不知道如何读取xml数据类型(如何从变量中获取值).如果有人可以给我一个如何读取xml的范例，那么我将继续以名称类似于变量"btnLogin"的形式为每个对象进行翻译.并将其controls.text属性赋予变量值.

抱歉，我的英语不好

欢迎任何帮助

提前谢谢！

解决方案

以下站点将解释xml数据类型列中的所有详细信息

http://msdn.microsoft.com/en-us/library/ms971534.aspx

Hi all,

I would like to know if anybody can help me or give me an example how to work with XML.

I need to create an multilingual application and need to save the controls captions in sql table with xml data type

i started the following:

CREATE TABLE Windows(
    ID [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
    Form nvarchar(50) NULL,
    List xml NULL
) 

DECLARE @itemString nvarchar(max)
DECLARE @itemDoc xml

SET @itemString = '<Root>
                             <data name="btnExit">
                                <value>Exit</value>
                             </data>
                             <data name="btnLogin">
                                <value>Login</value>
                             </data>
                            </Root>'

SET @itemDoc = @itemString

INSERT INTO dbo.Windows SELECT 'frmLogin', @itemDoc

I know this is not very professional but thats all i did until know in SQL

Now i have a problem in VB.NET i don't know how to read an xml data type (How to get the value from variables).

If somebody can give me an exmaple how to read the xml than i would continue translating for each objects in the form where name is like the variable "btnLogin" and give it the controls.text property to the variables value.

Sorry for my bad english

Any help is welcome

Thx in advance!

解决方案

Following site will explain all the detail from xml datatype column

http://msdn.microsoft.com/en-us/library/ms971534.aspx

这篇关于从SQL Server读取VB.NET中的XML数据(xml数据类型列)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！