Displaying linked data source as Sharepoint list

Question

As titled,

Is this possible?

I have created a linked data source, which is a combination of more than 5 SP lists, and i've created a dataview sheet using the linked data source. But what i actually want is to display it as a Sharepoint list, so that i can have the ability to perform things on it, especially to export it out as excel.

Is there a way i can achieve this?

Answer 1

You can make custom list, from colums of your lists(dataview columns), and add there ListItems. SPList myCustomList = SPContext.Current.Web.Lists["Custom List"];
SPListItem myListItem = myList.Items.Add();
myListItem["Column 1"] = "value 1";
myListItem["Column 2"] = "value 2";
myListItem["Column 3"] = "value 3";