Programmatically Add SharePoint Columns and Formatting theses Column's properties

Question

Hello everyone, i'm new here! =)

I need some help to create Sharepoint columns and setting up the column's format or properties programmatically.

I am able to create columns programmatically already, but am not able to set where i want radio buttons, dropdownlist for eg. Choice Type column. Any one can give me a suggestion or example?

This is what i used for creating columns:

private void btnCreateColumn_Click(object sender, EventArgs e)
        {
            SPSite mainsite = new SPSite("http://moss:3602");
            SPWeb web = mainsite.AllWebs[0];
            string ListSelected;
            ListSelected = cmbLstNames.SelectedItem.ToString();
            SPList taskList = web.Lists[ListSelected];
            SPFieldCollection Fields = taskList.Fields;
            SPFieldType UserChosenFieldType = SPFieldType.Text;
            string FieldType = "";
            FieldType = cmbListType.SelectedItem.ToString();
            try
            {
                #region SPField Types Definition
                /*UserChosenFieldType is optional instead you can use any one of the case UserChosenFieldType such as "AllDayEven" to create only one type of Site Template without Option*/

                switch (FieldType)
                {
                    case "AllDayEvent": UserChosenFieldType = SPFieldType.AllDayEvent; break;
                    case "Attachments": UserChosenFieldType = SPFieldType.Attachments; break;
                    case "Boolean": UserChosenFieldType = SPFieldType.Boolean; break;
                    case "Calculated": UserChosenFieldType = SPFieldType.Calculated; break;
                    case "Choice": UserChosenFieldType = SPFieldType.Choice; break;
                    case "Computed": UserChosenFieldType = SPFieldType.Computed; break;
                    case "ContentTypeId": UserChosenFieldType = SPFieldType.ContentTypeId; break;
                    case "Counter": UserChosenFieldType = SPFieldType.Counter; break;
                    case "CrossProjectLink": UserChosenFieldType = SPFieldType.CrossProjectLink; break;
                    case "Currency": UserChosenFieldType = SPFieldType.Currency; break;
                    case "DateTime": UserChosenFieldType = SPFieldType.DateTime; break;
                    case "Error": UserChosenFieldType = SPFieldType.Error; break;
                    case "File": UserChosenFieldType = SPFieldType.File; break;
                    case "GridChoice": UserChosenFieldType = SPFieldType.GridChoice; break;
                    case "Guid": UserChosenFieldType = SPFieldType.Guid; break;
                    case "Integer": UserChosenFieldType = SPFieldType.Integer; break;
                    case "Invalid": UserChosenFieldType = SPFieldType.Invalid; break;
                    case "Lookup": UserChosenFieldType = SPFieldType.Lookup; break;
                    case "MaxItems": UserChosenFieldType = SPFieldType.MaxItems; break;
                    case "ModStat": UserChosenFieldType = SPFieldType.ModStat; break;
                    case "MultiChoice": UserChosenFieldType = SPFieldType.MultiChoice; break;
                    case "Note": UserChosenFieldType = SPFieldType.Note; break;
                    case "Number": UserChosenFieldType = SPFieldType.Number; break;
                    case "PageSeparator": UserChosenFieldType = SPFieldType.PageSeparator; break;
                    case "Recurrence": UserChosenFieldType = SPFieldType.Recurrence; break;
                    case "Text": UserChosenFieldType = SPFieldType.Text; break;
                    case "ThreadIndex": UserChosenFieldType = SPFieldType.ThreadIndex; break;
                    case "Threading": UserChosenFieldType = SPFieldType.Threading; break;
                    case "URL": UserChosenFieldType = SPFieldType.URL; break;
                    case "User": UserChosenFieldType = SPFieldType.User; break;
                    case "WorkflowEventType": UserChosenFieldType = SPFieldType.WorkflowEventType; break;
                    case "WorkflowStatus": UserChosenFieldType = SPFieldType.WorkflowStatus; break;

                }
                #endregion

                if (rdbtnYes.Checked)
                    Fields.Add(txtColumnName.Text, UserChosenFieldType, true);

                else
                    Fields.Add(txtColumnName.Text, UserChosenFieldType, false);
                MessageBox.Show("Custom field created dynamically");
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error encountered attempting to add a new field" + Environment.NewLine + ex.Message);
            }
        }

        private void loadColumnTypes()
        {
            cmbListType.Items.Add("AllDayEvent");
            cmbListType.Items.Add("Attachments");
            cmbListType.Items.Add("Boolean");
            cmbListType.Items.Add("Calculated");
            cmbListType.Items.Add("Choice");
        }
        #endregion

Bhushan Gawale · Answer

Hi, you have done half part what you are trying to do .. after creating a field with choice type , you need to change the edit format of the choice field type , becuase by default edit format of the choice field type is dropdown here is the example solution SPList list = web.Lists["TaskList"]; SPFieldCollection fields = list.Fields; SPField field = new SPField(fields, "Choice", "Radio"); fields.Add(field); list.Update(); SPFieldChoice rdField = list.Fields["Radio"] as SPFieldChoice; rdField.EditFormat = SPChoiceFormatType.RadioButtons ; rdField.Choices.Add("Choice1"); rdField.Choices.Add("Choice2"); rdField.Update(); list.Update(); web.Update();

Bhushan Gawale · Answer

Hi you can refer msdn link: http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfieldchoice_members.aspx

Peterson Yap · Answer

Thank you very much! i think that pretty much solved my problem, is there documentation to this that i can further read on altering column type formatting?

Peterson Yap · Answer

I am trying to write a Window Application that allows me to add columns into a document or library or custom list. I am able to add all default columns types whenever the below is invoke, UserChosenFieldType is a variable that i use to overload into the Fields.Add(txtColumnName.Text, UserChosenFieldType, true); method, an example of the possible value is case "Choice": UserChosenFieldType = SPFieldType.Choice ; break; if (rdbtnYes.Checked) Fields.Add(txtColumnName.Text, UserChosenFieldType, true); I am able to add in the Choice Type Column with no problem but it is always by default shown as a drop down menu, i would like it to be radio buttons, how do i go about that? thanks

Bhushan Gawale · Answer

can you explain more what exactly you are trying to do ? what does this mean? " I am able to create columns programmatically already, but am not able to set where i want radio buttons, dropdownlist "

Peterson Yap · Answer

bump! still need some help!!

Programmatically Add SharePoint Columns and Formatting theses Column's properties

Answers (6)