Copy list items from one site to another using visual studio workflow in share point:

In this post I will tell how to copy list items from one list to other in 5 simple steps ...

Step1:
Create 2 lists in your share point site. I have created 2 lists namely list1 and list2.

List1 – Has the following fields
1.       Title
2.       Age
3.       Date
4.       Employee Name

List2 – Has the following fields
1.       Title
2.       Age
3.       Date
4.       Emp name
      
       Step2:

Open visual studio and click open
File -> New -> Project … In Project Types which is in left pane select office 2007 and select “Share point 2007 sequential Workflow”

Step3:
Open workflow.cs file and double click onWorkflowActivated1


Step4:

Use this code inside that onWorkflowActivated1_Invoked function…
SPSite mySourceSite = new SPSite("http://productionsrv:1010/Lists/list1/AllItems.aspx/");
            SPWeb mySourceWeb = mySourceSite.OpenWeb();
            SPList mySourceList = mySourceWeb.Lists["list1"];
            SPListItem mySourceListItem = workflowProperties.Item;

            string SourceTitle = mySourceListItem["Title"].ToString();
            string SourceAge = mySourceListItem["Age"].ToString();
            string SourceDesig = mySourceListItem["Date"].ToString();
            string SourceEmpName = mySourceListItem["Employee name"].ToString();

            SPSite myDestinationSite = new SPSite("http://productionsrv:1010/Lists/list2/AllItems.aspx");
            SPWeb myDestinationWeb = myDestinationSite.OpenWeb();
            SPList myDestinationList = myDestinationWeb.Lists["list2"];
            SPListItem myDestinationListItem = myDestinationList.Items.Add();

            myDestinationListItem["Title"] = SourceTitle;
            myDestinationListItem["Age"] = SourceAge;
            myDestinationListItem["Date"] = SourceDesig;
            myDestinationListItem["Emp name"] = SourceEmpName;
            myDestinationWeb.AllowUnsafeUpdates = true;
            myDestinationListItem.Update();
            myDestinationWeb.AllowUnsafeUpdates = false;
Step5:

Build and deploy in visual studio, which will open your site automatically to that list site.
Now values entered in list1 will be copied to list2 automatically…!



Comments

Popular posts from this blog

How to copy SharePoint list workflow

Generate Auto number Field in SharePoint list

INFOPATH FORM HIDE/DISABLE FIELDS BASED ON SHAREPOINT GROUP MEMBERSHIP