Update a List in the morning !!!

Question

HI All, I have a requirement in which the custom list has to get updated everyday morning by deleting all the list items and adding new items. Can anyone tell me how to achieve this ?? Thank you.

Answer 1

Hi scvinod,

You have to create a timerjob to achive this. That TimerJob should scheduled to run everyday morning which handles the deletion and addition of items to that List.

Creating Custom Timerjob using http://www.andrewconnell.com/blog/articles/CreatingCustomSharePointTimerJobs.aspx

---

 Shantha Kumar T - MCPD
(B) http://www.ktskumar.com
(T) http://twitter.com/ktskumar
IOTAP

---

Shantha Kumar .T MCPD - SharePoint Developer 2010

Answer 2

check also how to create custom timer job in SharePoint 2010  in the following link

Creating Custom Timer Job in SharePoint 2010

Regards.

---

Ahmed Naji SharePoint Geek
MCP|MCTS
My Blog | DotnetFinder

Answer 3

HI,

 

Thanks for the reply...wen i delete or add the items in the list through timer jobs I'm getting this error " Collection was modified; enumeration operation may not execute ". Can I know any solution for this. Thank you.

Answer 4

Hi scvinod

check the below article

Deleting List Items in a SharePoint List

if it's not solve the problem you can Ask a question in SharePoint 2010 - Using Visual Studio with SharePoint and other programming

and show us your code .

Regards.

---

Ahmed Naji SharePoint Geek
MCP|MCTS
My Blog | DotnetFinder

Answer 5

It's because of you are deleting the listitems from first item to last item. If we do like that, after deletion of single items, that will update the index value of list item collection. Because of that we are getting the error.

Instead we have to enumerate the list collection from last item to first item and the delete them. For deleting the list items, try the following snippet,

 

SPWeb mySite = SPContext.Current.Web;
SPListItemCollection listItems = mySite.Lists.TryGetList([ListName]).Items;
int itemCount = listItems.Count;

 for (int k=itemCount - 1; k >= 0; k--)
{    
        listItems.Delete(k);   
}

 Shantha Kumar T - MCPD
(B) http://www.ktskumar.com
(T) http://twitter.com/ktskumar
IOTAP

 

---

Shantha Kumar .T MCPD - SharePoint Developer 2010

---