Reading an XML data from SQL2008 database

Question

0.00/5 (No votes)

See more:

Hi guys,

I wanted to ask you for your assistance. I have an SQL2008 database within which there is a table "tblA" with two columns. One is "PID" (for PrID)and the other is "XMlCol", in which XML document is saved. I wanted each row with the XML info, to parsed to a datagrid, and when i click each PID, a subform will display the relative XML attached to a datagrid. Can you guys please say something in VB.Net how this can be accomplished. I pray for your urgent reply...thank you guys.

Posted 20-Jul-12 23:57pm

Member 3274870

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2012-07-21T00:03:00

Solution 1

You can read the XML as a string from your DB, then you can parse it in code to turn it in to the data you need.

Posted 21-Jul-12 0:03am

Christian Graus

Comments

Member 3274870 21-Jul-12 6:10am

Thx christian, but can you give me a simple example on how to do it?

Christian Graus 21-Jul-12 6:22am

If you don't know how to parse XML, why are you working with it ? You can use LINQ to XML, or the XmlDocument class and XPath, whichever you prefer. There's no way to create a 'simple example' without doing a lot of typing and generating something that you can't copy and paste and is probably less detailed than an article on the web.

Member 3274870 21-Jul-12 6:28am

Thx Christian, infact i just figured it out and am currently compiling. I guess i was totaly blacked out. You really did help.Thankyou anyway.

Member 3274870 · Answer 2 · 2012-07-22T00:42:00

hi guys, this was my first encounter with XML into a database row and i had a long trials figuring out how it can be handled. With Christian's help i managed to use strings and populate a grid. In addition to his help i found this great article, and it really really really helped. I guess it will help other too. The Article is written by Venu Gopal,(http://technico.qnownow.com/2012/06/19/how-save-xml-data-database/) thank you Christian and CodeProject as well.