//  首先获取到SPWeb对象web

SPListCollection lists  =  web.Lists;

SPList scoreList  =  lists[ " Score " ];

SPList passList  =  lists[ " Pass " ];

 

SPQuery query  =   new  SPQuery();

query.Query  =   " <Where><Geq><FieldRef Name='Score'/> "   +

     " <Value Type='Number'>60</Value></Geq></Where> " ;

SPListItemCollection items  =  scoreList.GetItems(query);

 

foreach (SPListItem item  in  items)

{

     string  title  =  item[ " Title " ]  +   " （合格） " ;

    item[ " Title " ]  =  title;

    item.Update();

}

 

SPListItem newItem  =  passList.Items.Add();

newItem[ " Count " ]  =  items.Count;

newItem.Update();