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
Post a Comment