Update: If you want a quicker solution, please check out my new CAML Viewer Web Part for SharePoint 2010.

In this post we will see how we can generate complex CAML queries easily. We will also see how we can use this query to fetch data from the list.

If you want to create a complex query, first create a list view based on the required criteria. Then use the below code to get the query.

SPWeb web = SPControl.GetContextWeb(this.Context);
SPList spList = web.Lists["Mylist"];
SPView view = spList.Views["Myview"];
Response.Write(view.Query.ToString());

Once we have this CAML query we can easily extract data from SharePoint list. Below is the code to fetch data from SharePoint list using CAML query

SPQuery query = new SPQuery();
query.Query = view.Query.ToString();
SPListItemCollection cole = spList.GetItems(query);
foreach (SPListItem item in cole)
{
Response.Write(item["Title"] +"<br />");
}