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:
Hi,

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.

Note-->
XML column data available in below format
<customer>
 <pri_one>1</pri_one> 
<cust_name>A</cust_name>
</customer>

How i achieve it in c#.net?

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

1 solution

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

Solution 1

You can use the XML parser or LINQ

XML Parsing...
XmlDocument xmlDoc= new XmlDocument();
xmlDoc.Load("yourXMLFile.xml");
  Permalink  

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