Get SPListItem ItemsData

Question

I have the list of items in object SPListItem item. Is it possible to extract certain data from the ListItems property?

The reason I want to do that is because I have a FieldName "AssignedTo" which returns null, even though I can see its value when debugging when using the following statement:

SPField field = item.Fields.GetFieldByInternalName("AssignedTo");
if (field != null)
{

    SPFieldUserValue fieldValue = field.GetFieldValue(item["AssignedTo"].ToString()) as
                                                                                SPFieldUserValue;

    if (fieldValue != null)
    {
        assignToUser = fieldValue.User;
    }
}

Now, in the ListItems property I can go to ItemsData and I can see the value is there, but how can I get it?

Any help appreciated!

Answer 1

This code should work: (web is a variable that references the web object)

 SPFieldUserValue value = 
                new SPFieldUserValue(web, item["AssignedTo"].ToString());
 if (value)
    {
        assignToUser = value.User;
    }

Answer 2

You can try below code,

using (SPSite siteCol = new SPSite("http://server/sites/Contoso"))
    {
        using (SPWeb web = siteCol.RootWeb)
        {
            SPList list = web.GetList("/sites/Contoso/Lists/Books");

            SPListItem item = list.GetItemByIdSelectedFields(3, "Title", "ISBN", "Retail_x0020_Price");

            String bookISBN = (String)item["ISBN"];
        }
    }

Answer 3

Try this

SPFieldUserValue userField = item.Fields["AssignedTo"] as SPFieldUser;
string userName = item["AssignedTo"].ToString();

SPFieldUserValue fieldValue = (SPFieldUserValue)userField.GetFieldValue(userName);
SPUser user = fieldValue.User;

Taken from http://ethan-deng.blogspot.com/2013/03/get-spuser-from-user-column-there-are.html

Answer 4

You can try below code to get SPUser in AssignedTo columns for specific item.

If(task["Assigned To"] != null)
{
    string fieldValue = Convert.ToString(task["Assigned To"]);
    SPFieldUserValue assignedTo = (SPFieldUserValue)
    task.Fields["Assigned To"].GetFieldValue(fieldValue);
}