Pages

Wednesday, December 26, 2012

Create a Sharepoint list programmatically in c#



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;


namespace ConsoleApplication1
{
   class Program
   {
       static void Main(string[] args)
       {
           {
               // choose your site
               SPSite site = new SPSite("http://a3599m1d/");
               SPWeb web = site.OpenWeb();
               SPListCollection lists = web.Lists;
              // create new Generic list called "My List" 
              lists.Add("Project List", "Project list escription",                     SPListTemplateType.GenericList);

               SPList newList = web.Lists["Project List"];
             // create Text type new column called "My Column"
              newList.Fields.Add("Project Name", SPFieldType.Text, true);
              newList.Fields.Add("Project Mode", SPFieldType.Text, true);
              newList.Fields.Add("Project Type", SPFieldType.Text, true);
   
              SPView view = newList.DefaultView;
              view.ViewFields.Add("Project Name");
              view.ViewFields.Add("Project Mode");
              view.ViewFields.Add("Project Type");
              view.Update();

              Console.Write("List created successfully");
              Console.Read();
           }

       }
   }
}

Results:
SharePoint List:






public void createList()
{
   
// choose your site
    SPSite site =
new SPSite("http://a3599m1d:111/");
    SPWeb web = site.OpenWeb();
    SPListCollection lists = web.Lists;
    // create new Generic list called "My List"
    lists.Add("My List", "My list Description", SPListTemplateType.GenericList);

    SPList newList = web.Lists["My List"];
    // create Text type new column called "My Column"
    newList.Fields.Add(
"My Column", SPFieldType.Text, true);
    /*create lookup type new column called "Lookup Column"
    * Here I am going to get the information from the "Title"
    * column of a list called "User Roles"
    */

    SPList targetList = web.Lists[
"User Roles"];
    newList.Fields.AddLookup("Lookup Column", targetList.ID, false);
    SPFieldLookup lkp = (SPFieldLookup)newList.Fields[
"Lookup Column"];
    lkp.LookupField = targetList.Fields[
"Title"].InternalName;
    lkp.Update();
    // make new column visible in default view
    SPView view = newList.DefaultView;
    view.ViewFields.Add(
"My Column");
    view.ViewFields.Add(
"Lookup Column");
    view.Update();
}






No comments:

Post a Comment