How to query data for CQWP?

Question

I have added the CQWP successfully to the web part page programmatically. Now I want to query data for that web part i.e. I want to display the title of the file from the document library.

My code is:

SPSite site = new SPSite("http://........");       

SPWeb web = site.RootWeb;          

web.AllowUnsafeUpdates = true;

SPLimitedWebPartManager webParts = web.GetLimitedWebPartManager("SiteAssets/webparts.aspx", System.Web.UI.WebControls.WebParts.PersonalizationScope.Shared);

 ContentByQueryWebPart wp = new ContentByQueryWebPart();
 wp.Title = "My web part using OM";

 wp.ListUrl = web.Url + "/Sample Docs";
wp.ListName = "Sample Docs";            
wp.ItemXslLink = web.Url + "/Style Library/ItemStyle.xsl";
wp.CommonViewFields = "Title,Text";
webParts.AddWebPart(wp, "Right", 0);
webParts.SaveChanges(wp);
web.Update();
Console.WriteLine("Web part added successfully");
Console.ReadKey();

Document Library is in the root site with name Sample Docs.

I am getting the output like:

How to query data? Please help.

Answer 1

I would suggest you to check this out, it gives a good oversight of the posibilities and how to use the CQWP correctly. I hope this will help a bit.

Answer 2

You need to set the QueryOverride property of ContentByQueryWebPart class. Create the desired query by a tool like CAML query builder and assign it to QueryOverride

EDIT

For example, you can write query like this:

wp.QueryOverride= "<Where><Eq><FieldRef Name='Status'/>" +
    "<Value Type='Text'>Completed</Value></Eq></Where>";

Answer 3

there is another idea to do this which is adding your CQWP using the portal UI then export the webpart after that you can import the exported web part into any page using SPLimitedWebPartManager.ImportWebPart and here is an example to this http://avinash-moss-expert.blogspot.com/2010/08/add-web-part-programmatically-using.html