How do I display the results of a CAML query on a data grid in sharepoint 2007?

Question

I want to develop a custom web part for SharePoint 2007. How do I display the results of a CAML query on a data grid? The grid view should be customizable, and should not adversely affect performance.

Answer 1

Haven't had a chance to test this code yet, but this here is the basic idea.

public static void TestOneFuncOne()
{
    using (SPSite site = new SPSite("yoursiteurl"))
    {
        using (SPWeb web = site.OpenWeb())
        {
            SPList list = web.Lists["Tasks"];
            DataTable dt;
            SPQuery query = new SPQuery();
            query.query = "Your CAML Query Here";
            dt = list.GetItems(query).GetDataTable();
            YourGridview.DataSource = dt;
            YourGridview.DataBind();
        }
    }
}

Does it sufficiently answer your question Or you were looking for more information in terms of best practices to handle a large list etc?

Answer 2

There are many different options/combinations to consider. The method you choose will probably depend on your requirements.

Get the data from SharePoint:

• ObjectDataSource - The more general way to retrieve data. You would implement your own select method to return results from your CAML query.
• SPDataSource - The "sharepointized" datasource. The link actually has a code sample using SPDataSource with a regular GridView.

Then, you can simply hook one of those up to a GridView or SPGridView. I can recommend a very good tutorial using an ObjectDataSource with SPGridView: Building A SPGridView Control – Part 1: Introducing the SPGridView.

Answer 3

As Stuart Pegg has alluded to, you should probably look at using DataViewWebPart for this. When you say customizable, I am assuming you mean customizable through SharePoint designer, which DVWP is.

You can put the CAML query in either through the code in the page that you are inserting the DVWP into, or you can create it using the GUI tools that SPD provides you.