CODEWITHSUNDEEP
sharepoint-2010
karpagam
karpagam

Reputation: 21

How to get the datatype of column from the sharepoint list?

  1. I want to get or retrieve the datatype of a particular column where the list is created in a sharepoint list.

    Can you help me for doing the task?

Upvotes: 2

Views: 6558

Answers (2)

Trisped
Trisped

Reputation: 6001

Building off of Rich Bennema's answer (referencing the Microsoft.SharePoint.Client and Microsoft.SharePoint.Client.RunTime version 16 libriaries and using the Microsoft.SharePoint.Client name space):

using (ClientContext cont = new ClientContext(SharePointUrl))
{
    cont.Credentials = new SharePointOnlineCredentials(Username, SecurePassword);

    FieldCollection fields = cont.Web.Lists.GetByTitle(SharePointListName).Fields;
    cont.Load(fields);
    cont.ExecuteQuery();

    var results =
            fields.Select(
                f => new
                {
                    f.InternalName,
                    f.TypeDisplayName,
                    TextMaxLength = (f is FieldText) ? ((FieldText)f).MaxLength : 0,
                    FieldChoices = (f is FieldChoice) ? ((FieldChoice)f).Choices : new string[0]
                }
            );
}

Upvotes: 0

Rich Bennema
Rich Bennema

Reputation: 10335

See SPField.Type (or SPField.TypeDisplayName).

SPList list = web.Lists["my list"];
SPField field = list.Fields["particular"];
SPFieldType fieldType = field.Type;
string fieldTypeName = field.TypeDisplayName;

Upvotes: 2

Related Questions