Add/Copy SPListItem object to Sharepoint List

Question

explanation:

I have fetched list items based on conditions. Like this.

var query = from SPListItem oItem in splist.Items
                                    where Convert.ToDateTime(oItem["Status"]).Equals("Completed")
                                    select oItem;


 foreach (SPListItem item in query)
 {
      // I get each SPListItem based on my condition
      // Now i want add/copy each list items to same list
 }

How do i add SPListItem whole object to same list?

Answer 1

You can try following:

foreach (SPListItem item in query)
{
          SPListItem newItem = list.Items.Add();
          foreach (SPField field in list.Fields)
          {
                  if (!field.ReadOnlyField)
                        newItem[field.Id] = item[field.Id];                            
           }
           newItem.Update();
 }

Answer 2

try this:

foreach(SPListItem item in splist.Items)
    {
      foreach(SPField field in splist.Fields)
        {
          SPListItem newItem=splist.Items.Add();
          newItem[field.ID]=item[field.ID];                       
          newItem.Update();
        }
     }