Click here to Skip to main content
12,954,276 members (73,088 online)
Rate this:
Please Sign up or sign in to vote.
See more:

In my sql table one of column having XML column which hold data in xml format.

I want to fetch that sql table xml column data into c# code, stored it into string variable. once i store it into string variable i want to store all xml attribute key and value into Collection.

XML column data available in below format

How i achieve it in

Please suggest any one approach!
Posted 26-Jan-13 18:14pm
Updated 26-Jan-13 19:38pm
Sandeep Mewara 27-Jan-13 1:42am
And what have you tried so far? Where are you stuck?

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You can use the XML parser or LINQ

XML Parsing...
XmlDocument xmlDoc= new XmlDocument();

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

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,524
CHill60 3,490
Maciej Los 3,123
ppolymorphe 2,030
Jochen Arndt 1,975

Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 27 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100