I am trying to combine two
SharePoint lists into one so I can return items from two separate lists as one entity.
I have multiple Objects but I haven't found a good way to combine them no matter which ones I use.
Is there a simple way to combine the following?
SPList pubList = web.Lists["public"]; SPList secureList = web.Lists["secure"];
SPListItemCollection pubFiles = retrieveDocs(web, meta, pubList); SPListItemCollection secureFiles = retrieveDocs(web, meta, secureList);
or convert these
DataTable pubTable = pubFiles.GetDataTable(); DataTable secureTable = secureFiles.GetDataTable(); pubTable.Merge(secureTable);