How to get the formula for the calculated field in SharePoint 2010 using Client Object Model

I have a list named "CustomList" which contains a calculated field called "Calculated". I am going to get the formula for the calculated column using Client Object model.

 

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using Microsoft.SharePoint.Client;

 

namespace COM

{

    class Program

    {

        static void Main(string[] args)

        {

            // siteURL is the string that contains the site URL

            string siteUrl = "http://serverName:50000/sites/Testing";  

            // ClientContext object is used to get the context for the SharePoint objects

            ClientContext clientContext = new ClientContext(siteUrl);

            Web web = clientContext.Web;            

            List list = web.Lists.GetByTitle("CustomList");

            Field field = list.Fields.GetByTitle("Calculated");

            FieldCalculated calculatedField = clientContext.CastTo<FieldCalculated>(field);

            clientContext.Load(calculatedField);

            clientContext.ExecuteQuery();

            Console.WriteLine(calculatedField.Formula);  

            Console.ReadLine()

        }

    }

}

Ebook Download
View all
Learn
View all