How to query data in SharePoint from multiple lists

Question

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

Please guide me.

Grace

Answer 1

Two options that I can think of:

1. SPSiteDataQuery
2. Set up a search scope, metadata, and then query your Scope using Enterprise Search SQL and FullTextSqlQuery