Sharepoint Fields and update / retrive Values

Lookup Field
Field Class: SPFieldLookup Field Value Class: SPFieldLookupValue
Populating Information: item[“FieldName”] = new SPFieldLookupValue(“Title”);
 // SharePoint will do the lookup as long as the LookupValue’s are unique item.Update(); or item[“FieldName”] = new SPFieldLookupValue(1, “Title”); item.Update(); Retrieving Information: SPFieldLookupValue itemValue = item[“FieldName”] as SPFieldLookupValue; int id = itemValue.LookupId; string value = itemValue.LookupValue;
Multiple Lookup Field
Field Class: SPFieldLookup Field Value Class: SPFieldLookupValueCollection
Populating Information: SPFieldLookupValueCollection itemValues = SPFieldLookupValueCollection(); itemValues.Add(new SPFieldLookupValue(1, “Title”)); item[“FieldName”] = itemValues; item.Update(); Retrieving Information: SPFieldLookupValueCollection itemValues = item[“FieldName”] as SPFieldLookupValueCollection; foreach (SPFieldLookupValue itemValue in itemValues) {   int id = itemValue.LookupId;   string value = itemValue.LookupValue; }
User Field
Field Class: SPFieldUser Field Value Class: SPFieldUserValue
Populating Information: web.EnsureUser(@”domain\username”); SPUser user = web.AllUsers[@”domain\username”]; item[“FieldName”] = user; item.Update(); Retrieving Information: string currentValue = item[“FieldName”].ToString(); SPFieldUser userField = list.Fields.GetFieldByInternalName(“FieldName”); SPFieldUserValue itemValue = (SPFieldUserValue)userField.GetFieldValue(currentValue); SPUser user = itemValue.User;
URL Field
Field Class: SPFieldUrl Field Value Class: SPFieldUrlValue
Populating Information: SPFieldUrlValue urlValue = new SPFieldUrlValue(); urlValue.Url = “”; urlValue.Description = “Google”; item[“FieldName”] = urlValue; item.Update(); Retrieving Information: SPFieldUrlValue urlValue = new SPFieldUrlValue(item[“FieldName”].ToString()); string url = urlValue.Url; string description = urlValue.Description;
Multiple Choice Field
Field Class: SPFieldMultiChoice Field Value Class: SPFieldMultiChoiceValue
Populating Information: SPFieldMultiChoiceValue itemValue = new SPFieldMultiChoiceValue(); itemValue.Add(“Choice 1”); itemValue.Add(“Choice 2”); itemValue.Add(“Choice 3”); item[“FieldName”] = itemValue; item.Update(); Retrieving Information: SPFieldMultiChoiceValue itemValue = new SPFieldMultiChoiceValue(item[“FieldName”].ToString()); foreach (string choice in itemValue) {   // value is in choice }

About sharepointsriram

9+ Yrs of IT experience
This entry was posted in Sharepoint 2010 Server Object Model. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s