Reader Level:
Articles

Site Column in SharePoint 2010 Programmatically Using VS 2010

By Vijay Prativadi on Aug 12, 2012
Today, in this article let’s play around with one of the interesting and most useful concepts in SharePoint 2010.
  • 0
  • 0
  • 12789

Introduction

 

Today, in this article let's play around with one of the interesting and most useful concepts in SharePoint 2010.

Question: What is a Site column?

In simple terms "It is a specific column which can be used across any list or libraries for a site or subsites".

 

Step 1: Open SharePoint 2010 Central Administration and navigate to a specific site.

 

Step 2: Open Visual Studio 2010 and create an "Empty SharePoint project":

 

Output1.jpg
 

Step 3: Select "Deploy as a farm solution" and click the "Finish" button. Now an empty project will be created, as in:

 

Output2.jpg
 

 Step 4: Add a new visual webpart for that project.

 

Output3.jpg
 

 Step 5: The complete code of visualwebpart1usercontrol.ascx looks like this:

 

<%@ Assembly Name="$SharePoint.Project.AssemblyFullName$" %>

<%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register TagPrefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls"

    Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register TagPrefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register TagPrefix="asp" Namespace="System.Web.UI" Assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" %>

<%@ Import Namespace="Microsoft.SharePoint" %>

<%@ Register TagPrefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages"

    Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@  Control Language="C#" AutoEventWireup="true" CodeBehind="SiteColumnWPUserControl.ascx.cs"

    Inherits="SiteColumnApp.SiteColumnWP.SiteColumnWPUserControl" %>

<div align="center" style="font-family: Verdana; font-weight: bold">

    <table>

        <tr>

            <td>

                <asp:label id="Label1" runat="server" text="Please Enter Site Column Name: " forecolor="Brown"></asp:label>

            </td>

            <td>

                <asp:textbox id="TextBox1" runat="server"></asp:textbox>

            </td>

        </tr>

        <tr>

            <td colspan="2">

                <asp:button id="Button1" runat="server" text="Create Site Column" onclick="Button1_Click"

                    backcolor="Orange" />

            </td>

        </tr>

        <tr>

            <td colspan="2">

                <asp:label id="Label2" runat="server"></asp:label>

            </td>

        </tr>

    </table>

</div>
 

Step 6: The complete code of visualwebpart1usercontrol.ascx.cs looks like this:

 

using System;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using Microsoft.SharePoint;

namespace SiteColumnApp.SiteColumnWP

{

    public partial class SiteColumnWPUserControl : UserControl

    {

        protected void Page_Load(object sender, EventArgs e)

        {

        }

        protected void Button1_Click(object sender, EventArgs e)

        {

            if (string.IsNullOrEmpty(TextBox1.Text))

            {

                Label2.Text = "Please Enter Some Values.";

                Label2.ForeColor = System.Drawing.Color.Red;

            }

            else

            {

                SPSite site = new SPSite("http://win-5d57sl2rvt1:6901/");

                SPWeb web = site.OpenWeb();

                string internal_Name = web.Fields.Add(TextBox1.Text, SPFieldType.Currency, true);

                SPFieldCurrency currency = (SPFieldCurrency)web.Fields.GetFieldByInternalName(internal_Name);

                currency.Currency = SPCurrencyFieldFormats.India;

                currency.DisplayFormat = SPNumberFormatTypes.TwoDecimals;

                currency.ValidationMessage = "Incorrect Currency";

                currency.Update();

                Label2.Text = TextBox1.Text + " - Site Column is successfully created.";

                Label2.ForeColor = System.Drawing.Color.Green; TextBox1.Text = string.Empty;

            }

        }

    }

}

 

Step 7: Deploy the solution file and add the created webpart to the SharePoint site:

 

Step 8: The output of the application looks like this:

 

Output4.png
 

 

Step 9: The Site column entering output of the application looks like this:

 

Output5.png
 

 

 

Step10: The Site column created output of the application looks like this:

 

Output6.png
 

 


 

Output7.jpg

I hope this article is useful for you.

Vijay Prativadi

Hey Everyone, It's Vijay. I am SDE mostly up on Microsoft Technologies. If you are thinking to know what I do mostly when at work. I get a chance to work upon few Microsoft technologies. All the way along my core tech... Read more

COMMENT USING

Trending up