Convert DataTable to SPListItemCollection

Question

Consider the following code:-

SPListItemCollection collListItems = emp_info.GetItems(query);
dt = collListItems.GetDataTable();

Now i want to convert the dt object back to SPListItemCollection object

Is this possible in one of the following ways

1.)

SPListItemCollection collec1= dt as SPListItemCollection;

2.)

  SPListItemCollection collec1= (SPListItemCollection)dt;

If not is there any other way where i can convert DataTable object back to a SPListItemCollection object.

Anyone with any ideas, Thanks....

Answer 1

You have to iterate through DataTable and fill into SPListitemCollection object.

Also check following link for the code details:

http://social.technet.microsoft.com/Forums/sharepoint/en-US/f772b759-28b7-4330-b4a2-ef7541f3e79c/how-to-convert-datatable-into-splistitemcollection

Answer 2

The above mentioned techniques would have only work if DataTable would have been derived from SPListItemCollection.

Since its not the case, so you will have to iterate over the rows in DataTable and will have to create list items for each row and associate it with appropriate properties.