title: CAML query on sharepoint list
body: <p>I have a sharepoint list with the following fields:</p>
  
  <p>Product Name
  Product Description
  Price
  Product Type</p>
  
  <hr>
  
  <p>Product Type can be either a CD or DVD</p>
  
  <p>I would like to be able to obtain all data/records on the list based on a CAML query for Product Type. Here is my CAML query:</p>
  
  <p>string prodType1= "CD";
  string prodType2= "DVD";</p>
  
  <pre><code>string camlquery = 
  @"&lt;Where&gt;
  &lt;Eq&gt;
  &lt;FieldRef Name='Products_x0020_Type'/&gt;
  &lt;Value Type='Text'&gt;" + prodType1 + @"&lt;/Value&gt;
  &lt;/Eq&gt;
  &lt;/Where&gt;";
  </code></pre>
  
  <p>I want to be able to bring back all data/records for product type CD. How can I acieve this with CAML, if possible. If not possible what other method would be recommended for this.</p>
  
  <p>I have been scratching my head with this for a over a week now, any help will be greatly appreciated.</p>
  
  <p>Many Thanks in Advance</p>