SharePoint 2010 动态创建calculate column

 static void Main(string[] args)
        {
            using (SPSite site = new SPSite("http://serverName/sites/Vijai/"))
            {
                using (SPWeb web = site.OpenWeb())
                {
                    SPList list = web.Lists.TryGetList("Custom");
                    if (list != null)
                    {
                        ////Create a calculated field                  
                        string calculatedColumn = list.Fields.Add("CalculatedColumn", SPFieldType.Calculated, false);
                        ////Get the newly created calculated field                     
                        SPFieldCalculated calculatedField = list.Fields[calculatedColumn] as SPFieldCalculated;
                        ////Set the calculated field formula                     
                        calculatedField.Formula = "=[Title]";
                        ////Set the data type returned from this formula               
                        calculatedField.OutputType = SPFieldType.Text;
                        ////Update the calculated field                     
                        calculatedField.Update();
                    }
                }
            }
        }

 

posted @ 2013-03-11 14:49  山之子  阅读(249)  评论(0编辑  收藏  举报