Read XML data in VB.NET from SQL Server (xml datatype column)

Question

_{Friday, December 26, 2008 10:30 AM}

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!

All replies (5)

_{Friday, December 26, 2008 1:51 PM | 1 vote}

Following site will explain all the detail from xml datatype column

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

---

_{Tuesday, December 1, 2009 11:11 AM}

Following site will explain all the detail from xml datatype column

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

---

Gaurav Khanna

Do you know any other site with vb.net samples?

---

_{Tuesday, December 1, 2009 11:20 AM}

Some more links

http://msdn.microsoft.com/en-us/library/ms189887.aspx
http://www.developer.com/net/net/article.php/3406251/Work-with-XML-Data-Type-in-SQL-Server-2005-from-ADONET-20.htm
http://www.codeproject.com/KB/database/XMLdDataType.aspx
http://www.codeguru.com/csharp/csharp/cs_data/xml/article.php/c8151/#moreGaurav Khanna

---

_{Tuesday, December 1, 2009 11:26 AM}

here is the sample in VB.NET, u can find a neat explination for each and every statement...

http://www.15seconds.com/Issue/050601.htm

and also download the below document sure it will help u a lotz, u can learn many more with XML data type in SQL Server

XML Support in Microsoft SQL Server

http://download.microsoft.com/download/f/1/c/f1cf7b8d-7fb9-4b71-a658-e748e67f9eba/XML_Support_in_SQL.doc

hope it helps...

Narayanan Dayalan - Zeetaa Business Solutions Please "Mark As Answer", if my answer works well with ur Query

---

_{Monday, December 7, 2009 5:25 AM}

did u try the above link and the document ??? did it solve ur issue, let me know if u need any more help...

Narayanan Dayalan - Zeetaa Business Solutions Please "Mark As Answer", if my answer works well with ur Query