This code is used for copying entire list item in to another list using workflows
private void onWorkflowActivated1_Invoked(object sender, ExternalDataEventArgs e)
{
SPSite mySourceSite = new SPSite("http://fivenumber:5/");
SPWeb mySourceWeb = mySourceSite.OpenWeb();
SPList mySourceList = mySourceWeb.Lists["Source List"];
SPQuery mySourceListQuery = new SPQuery();
mySourceListQuery.Query = "" +
"" +
"" +
"" +
"";
SPListItemCollection mySourceItemColl = mySourceList.GetItems(mySourceListQuery);
int count = 0;
foreach (SPListItem mySourceListItem in mySourceItemColl)
{
string SourceEmpId = mySourceListItem["Employee Id"].ToString();
string SourceEmpName = mySourceListItem["Employee Name"].ToString();
string SourceDesig = mySourceListItem["Designation"].ToString();
string SourceAge = mySourceListItem["Age"].ToString();
SPSite myDestinationSite = new SPSite("http://fivenumber:50");
SPWeb myDestinationWeb = myDestinationSite.OpenWeb();
SPList myDestinationList = myDestinationWeb.Lists["Destination List"];
SPListItem myDestinationListItem = myDestinationList.Items.Add();
myDestinationListItem["Employee Id"] = SourceEmpId;
myDestinationListItem["Employee Name"] = SourceEmpName;
myDestinationListItem["Designation"] = SourceDesig;
myDestinationListItem["Age"] = SourceAge;
myDestinationWeb.AllowUnsafeUpdates = true;
myDestinationListItem.Update();
myDestinationWeb.AllowUnsafeUpdates = false;
count++;
Console.WriteLine(count+" item(s) copied");
}
}
Try This!!!!!!!!!!!
No comments:
Post a Comment