SharePoint - Display Full List in Content Query Web Part in SharePoint 2010

Hi,
I created a first list on Page and
a second list in Content Query Web Part by selcting list from Query properties.

For page, it display all columns and rows.
For CQWP, it display only first column.How I display all columns for CQWP ?

Regards,
Nilesh...

Hello,

You pass query string in for First Page into Second Page then display only one Column.

You need fetch all record instead of pass single id.

try this.

and let me know your feedback

Hi,

If you need to retrieve items from a list when developing web parts, application pages or custom field types you can best use the SPQueryobject from the SharePoint object model. This object is located in the Microsoft.SharePoint namespace of the Microsoft.SharePoint.dll located in the Global Assembly Cache.

Instantiate the object as follows:

SPQuery qry = new SPQuery();

The most important property is the Query property, which needs to be set to your CAML query:

string camlquery = "<OrderBy><FieldRef Name='Country' /></OrderBy><Where>"

    + "<Eq><FieldRef Name='LastName' /><Value Type='Text'>Smith</Value></Eq>"

    + </Where>";

qry.Query = camlquery;

At this point you can execute the query on your list:

SPListItemCollection listItemsCollection = list.GetItems(qry);

A small remark with the GetItems method of the SPList instance: this method returns a collection of type SPListItemCollection. It is possible that it is easier working with a DataTable. In that case you can execute the query as follows:

DataTable listItemsTable = list.GetItems(qry).GetDataTable();

let me know whether its working for you or not

Hi

I am using only a single page in SharePoint 2010....
First I insert a list on Page...It display all rows and columns
Then insert a Content Query Web Part..choose a list from third option of CQWP..but displays only single column.

HI,

Code to Display Full List In Content Query Webpart

<DIV id="ListPlaceholder"><IMG src="/_layouts/images/GEARS_AN.GIF"></DIV>
 
    <!-- Paste the URL of the source list below: -->
    <iframe id="SourceList" style="display:none;" src="/site/Lists/Calendar/Current%20Month%20Events.aspx" onload="DisplayThisList()"></iframe>
 
    <script type="text/javascript">
    function DisplayThisList()
    {
      var placeholder = document.getElementById("ListPlaceholder");
      var displaylist = null;
      var sourcelist = document.getElementById("SourceList");
      try {
         if(sourcelist.contentDocument)
          // Firefox, Opera
          {
          displaylist = sourcelist.contentDocument.getElementById("WebPartWPQ2") ;
        }
         else if(sourcelist.contentWindow)
          // Internet Explorer
          {
          displaylist = sourcelist.contentWindow.document.getElementById("WebPartWPQ2") ;
        }
         else if(sourcelist.document)
          // Others?
          {
          displaylist = sourcelist.document.getElementById("WebPartWPQ2") ;
        }
      }
      catch(err)
      {
        alert ("Loading failed");
      }
      var allDescendants = displaylist.getElementsByTagName("*");
      placeholder.innerHTML = displaylist.innerHTML;
    }
    </script>