title: SharePoint GetListItems - Get all columns, filter by set List ID . C#
body: <p>In this WS conumer C# code - , what's the simplest way to Get back all list columns (I only see 10 attributes avaliable) and to filter a a set ID=3.  Do I have to qualify all of them in the ndViewFields? where do I place my caml Where? Thanks.</p>
  
  <pre><code>XmlDocument xmlDoc = new System.Xml.XmlDocument();
          XmlNode ndQuery = xmlDoc.CreateNode(XmlNodeType.Element, "Query", "");
          XmlNode ndViewFields = xmlDoc.CreateNode(XmlNodeType.Element, "ViewFields", "");
          XmlNode ndQueryOptions = xmlDoc.CreateNode(XmlNodeType.Element, "QueryOptions", "");
  
          ndQueryOptions.InnerXml = "&lt;IncludeMandatoryColumns&gt;FALSE&lt;/IncludeMandatoryColumns&gt;&lt;DateInUtc&gt;FALSE&lt;/DateInUtc&gt;&lt;ExpandUserField&gt;FALSE&lt;/ExpandUserField&gt;";
          //ndViewFields.InnerXml = "&lt;FieldRef Name='Title' /&gt;&lt;FieldRef Name='Title' /&gt;";  //you don't need to specifically request the 'ID' column since it will be returned regardless   
          ndViewFields.InnerXml = "&lt;FieldRef Name='Title' /&gt;";  //you don't need to specifically request the 'ID' column since it will be returned regardless   
          ndQuery.InnerXml = "&lt;OrderBy&gt;&lt;FieldRef Name='Title'/&gt;&lt;/OrderBy&gt;";
  
          try
          {
              XmlNode ndListItems = wList.GetListItems("MyList", string.Empty, ndQuery, ndViewFields,null, ndQueryOptions, null);
  
              foreach (XmlNode node in ndListItems)
              {
                  if (node.Name == "rs:data")
                  {
  
                      for (int f = 0; f &lt; node.ChildNodes.Count; f++)
  
                      {
                          if (node.ChildNodes[f].Name == "z:row")
                          {
                              //Add the employee ID to my 'employeeIDs' ArrayList   
                              Titles.Add(node.ChildNodes[f].Attributes["ows_Title"].Value);
  </code></pre>