Tuesday, August 28, 2012

SharePoint 2010 Update List Data & Other List Data Programmatically


Update Record in Same List using Event Receiver.
 
public override void ItemAdded(SPItemEventProperties properties)
        {
    using (SPSite site = new SPSite(properties.WebUrl))
            {
                using (SPWeb web = properties.OpenWeb())
                {
                    SPList CurrentList = web.Lists[properties.ListId];
                    SPListItem item = CurrentList.GetItemById(properties.ListItemId);

   SPListItem curritem = spProductKey.GetItemById(intID);
                    curritem["LicenseKey"] = strencvalidatekey;
                    curritem["From Date"] = fromDate;
                    curritem["Is Registered"] = 1;
                    curritem["MAC Address"] = strMacAdd;
                    curritem["Processor Id"] = strProcessorID;
                    curritem["To Date"] = toDate;
                    curritem.Update();
}
    }
}

Update Record in other List using Event Receiver.

  public override void ItemAdded(SPItemEventProperties properties)
        {
  using (SPSite site = new SPSite(properties.WebUrl))
            {
                using (SPWeb web = properties.OpenWeb())
                {
   SPList spProductKey = web.Lists["Product Key Generation"];
                    SPQuery qBudgetsubList = new SPQuery();
                    qBudgetsubList.Query = @"<Where><Eq><FieldRef Name='Product_x0020_Key' /><Value Type='Text'>" + strProductKey + "</Value></Eq></Where>";
                    SPListItemCollection splist = spProductKey.GetItems(qBudgetsubList);

                    DataTable dt = new DataTable();
                    dt = splist.GetDataTable();
                    int intID = Convert.ToInt32(dt.Rows[0]["ID"]);

   SPListItem oItem = properties.ListItem;
                    oItem["Validate_x0020_Key"] = strencvalidatekey;
                    oItem.Update();
}
   }
}














No comments:

Post a Comment