How do I read LookUp fields with multiple values in SharePoint?

c# .net wcf sharepoint moss
Matt Cashatt picture Matt Cashatt · Dec 6, 2011 · Viewed 17.8k times · Source

Hi and thanks for looking!

Background

I have inherited an old .NET project based on SharePoint 2007 and have designed and external core library which merely accesses SP data, therefore making SP just a backend. Yes, I know it would be better to migrate to SQL, but the client doesn't agree.

The previous developers used a simple read method to read the data in a SP list:

  SPList list = CurrentRootWeb.Lists["SomeListName"];

And then they access list properties through a dictionary of sorts (i.e. for each item in list, get item["SomeValue"]).

I am not skilled in SharePoint, so I don't know if this is the most efficient manner to go about accessing it's data.

Problem

How do I read LookUp fields with multiple values in SharePoint?

Every property they request seems to want a string in return. So item[SomeString] is okay, but item[SomeList] makes everything barf! I would have thought that a multi-value lookup list column comes in as a serialized or delimited string holding the selected values (example: "red;blue;green"). What am I missing?

Thanks!

Answer

justforkix09 picture justforkix09 · Dec 7, 2011

If you are specifically interested in LookUp fields with multiple values not just MultiChoice feilds, then following code should help:

item.Fields["LookFieldName"].Type == SPFieldType.Lookup;
SPFieldLookup LookUpField = item.Fields["LookFieldName"] as SPFieldLookup;
if (LookUpField.AllowMultipleValues)
{
    SPFieldLookupValueCollection valueCollection = item[Field.Id] as SPFieldLookupValueCollection;

    string[] arrLookupValues = (from SPFieldLookupValue val in valueCollection select val.LookupValue).ToArray<string>();


 }

Related questions

WCF Service Client: The content type text/html; charset=utf-8 of the response message does not match the content type of the binding

I've got a WCF Service running on my local IIS server. I've added it as a service reference to a C# Website Project and it adds fine and generates the proxy classes automatically. However, when I try and call any …

Read More
Error 5 : Access Denied when starting windows service

I'm getting this error when I try to start a windows service I've created in C#: My Code so far: private ServiceHost host = null; public RightAccessHost() { InitializeComponent(); } protected override void OnStart(string[] args) { host = new ServiceHost(typeof(RightAccessWcf)); host.Open(); } …

Read More
How can I ignore a property when serializing using the DataContractSerializer?

I am using .NET 3.5SP1 and DataContractSerializer to serialize a class. In SP1, they changed the behavior so that you don't have to include DataContract/DataMember attributes on the class and it will just serialize the entire thing. This is …

Read More