title: How to get XML data from a column in an SQL table?
body: <p>I have a table in SQL and one of its column is an XML datatype. How will I be able to get its value from SQL to ASP.NET (C#) code-behind? I want to store it as an Xml type and not as string type because I need to manipulate the values and the attributes inside of it. I tried getting it and putting it on a string type variable and what I get is something like this: AAYYYNYNYNStarLight. I would want to get this instead: </p>
  
  <pre><code>&lt;ANSWERS&gt;
  &lt;Answer item="ddl_3"&gt;A&lt;/Answer&gt;
  &lt;Answer item="ddl_8"&gt;A&lt;/Answer&gt;
  &lt;Answer item="ddl_13"&gt;Y&lt;/Answer&gt;
  &lt;Answer item="ddl_16"&gt;Y&lt;/Answer&gt;
  &lt;Answer item="ddl_19"&gt;Y&lt;/Answer&gt;
  &lt;Answer item="ddl_22"&gt;N&lt;/Answer&gt;
  &lt;Answer item="ddl_26"&gt;Y&lt;/Answer&gt;
  &lt;Answer item="ddl_30"&gt;N&lt;/Answer&gt;
  &lt;Answer item="ddl_34"&gt;Y&lt;/Answer&gt;
  &lt;Answer item="ddl_38"&gt;N&lt;/Answer&gt;
  &lt;Answer item="ddl_42"&gt;StarLight&lt;/Answer&gt;
  &lt;/ANSWERS&gt;
  </code></pre>
  
  <p>How can I do it and be able to manipulate each node? I'm a complete noob about XML and any help will be much appreaciated. :)</p>
  
  <p>Edit: cleaned up the xml</p>