How to query data from multiple lists in SharePoint

Question

I have several SharePoint lists and want to display data from them on a gridview control.

I beg you, please.

Grace

Answer 1

Two options that I can think of:

• SPSiteDataQuery
• Customize the search scope, metadata, and then query the scope using SQL Enterprise and FullTextSqlQuery

Answer 2

Your question inspired me to develop a web part that demonstrates:

• How to request SharePoint data in many ways the API offers and
• How to snap it to a grid view.

CodePlex. , , . :

• ( )
• GetListItems - ""
• SPQuery SPList
• SPSiteDataQuery
• CrossListQueryInfo -
• PortalSiteMapProvider SharePoint Server

, -.

, . , , CodePlex, .

Answer 3

SharePoint 2007 CrossListQueryCache CrossListQueryInfo. .