Populating InfoPath Drop Down List Box with SharePoint Fields Choice

Populate InfoPath drop-down programmatically from Sharepoint Field Choice

  • Article 1: How to code C-Sharp on infopath form 2010
  • Article 2: How to set the value of a Field in Infopath
  • Article 3: How to set value of a field from sharepoint list
  • Article 4: Populating InfoPath Drop Down List Box with SharePoint List Lookup Data 
  • Article 5: Populating InfoPath Drop Down List Box with SharePoint Fields Choice
  • Article 6: Deploy an InfoPath 2010 Form with Managed Code to a Browser Enabled Sharepoint Document Library

Download Infopath Form at here

Designing  and coding infopath

Open Infopath | Design user interface follows as

Go to File => Form Options => Programming
Form template code language: C#
Go to File => Form Options => Security and Trust
Configure follows as:
Ads not by this site
Ads not by this site
Go to Tab Developer | click to Loading Event ribbon
Right click to myFields | Add
Ads not by this site
Name: GroupStatus
Type: Group
Check to Repeating
Ads not by this site
Right click to GroupStatus | Add
Ads not by this site
Name: Displayname
Continue Right click to GroupStatus | Add then input Name: Value
Ads not by this site
Ads not by this site
Right click to DropdownList “Country” | Drop-Down List Box Properties…
At List box choices------------------------------
Check to radio button “Get choice from fields in this from”, then click to Entries, select value follows as
Add reference to Microsoft.sharepoint.dll
Ads not by this site
Ads not by this site
Using  using Microsoft.SharePoint;
Add method AddStatus (); to FormEvents_Loading
Paste this method  to below FormEvents_Loading method public void AddStatus ()
using Microsoft.Office.InfoPath;
using System;
using System.Xml;
using System.Xml.XPath;
using Microsoft.SharePoint;

namespace SetValueToDropdownListInfoPathFromChoiceField
{
    public partial class FormCode
    {
        // NOTE: The following procedure is required by Microsoft InfoPath.
        // It can be modified using Microsoft InfoPath.
        public void InternalStartup()
        {
            EventManager.FormEvents.Loading += new LoadingEventHandler(FormEvents_Loading);
        }

        public void FormEvents_Loading(object sender, LoadingEventArgs e)
        {
            AddStatus();
        }

        public void AddStatus()
        {
            try
            {
                SPSite site = new SPSite("http://win-67038mbkel7");
                SPWeb web = site.OpenWeb();
                SPList list = web.Lists["Tasks"];
                SPFieldMultiChoice spFieldMultiChoice = (SPFieldMultiChoice)list.Fields["Status"];
                XPathNavigator nav = this.CreateNavigator().SelectSingleNode("/my:myFields/my:GroupStatus",
                    this.NamespaceManager);
                for (int item = 0; item < spFieldMultiChoice.Choices.Count; item++)
                {
                    XPathNavigator newNode = null;
                    newNode = nav.Clone();
                    newNode.SelectSingleNode("/my:myFields/my:GroupStatus/my:Displayname",
                        this.NamespaceManager).
                        SetValue(spFieldMultiChoice.Choices[item].ToString());
                    newNode.SelectSingleNode("/my:myFields/my:GroupStatus/my:Value",
                        this.NamespaceManager).
                        SetValue(spFieldMultiChoice.Choices[item].ToString());
                    nav.InsertAfter(newNode);
                    newNode = null;
                }
                nav.DeleteSelf();
                nav = null;
            }
            catch
            {

            }
        }
    }
}


Build project then click F5, result as below


Ads not by this site

Comments

Post a Comment

Popular posts from this blog

C# - Changing controls properties in other forms in C#

Image
The controls you add to a form have something called Properties. A property of a control is things like its Height, its Width, its Name, its Text, and a whole lot more besides. To see what properties are available for a button, make sure the button is selected. If a control is selected, it will have white squares surrounding it. If your button is not selected, simply click it once. Now look in the bottom right of Visual C# Express, just below the Solution Explorer. You should see the Properties Window.
Read more

Displaying Message Boxes in C#

Image
A MessageBox is a predefined dialog box that displays application-related information to the user. Message boxes are also used to request information from the user. To display information to the user in a message box Navigate to where you would like to add the code for the message box. Add code using the MessageBox.Show method. The following code demonstrates how to call the Show method of the MessageBox class to display information to the user. The call to the Show method uses the optional style parameter to specify the type of icon to display in the message box that best fits the type of message box being displayed:  public void PerformCalculations()  { // Code is entered here that performs a calculation // Display a message box informing the user that the calculations // are complete MessageBox.Show ("The calculations are complete", "My Application",  MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk); } Message boxes can also receive input. The Show method o...
Read more

How to set value of a field from sharepoint list

Image
Download infopath form coding at  here Designing  and coding infopath Article 1:  How to code C-Sharp on infopath form 2010 Article 2 : How to set the value of a Field in Infopath Article 3 : How to set value of a field from sharepoint list Article 4 : Populating InfoPath Drop Down List Box with SharePoint List Lookup Data  Article 5 :  Populating InfoPath Drop Down List Box with SharePoint Fields Choice Article 6 : Deploy an InfoPath 2010 Form with Managed Code to a Browser Enabled Sharepoint Document Library In article  How to set the value of a Field in Infopath  we learn how to code basic infopath, now we continue code to get data from sharepoint list then display to fields of infopath form Open Infopath | Design user interface follows as Go to File => Form Options => Programming Form template code language: C# Ads not by this site Go to File => Form Options => Security and Trust Conf...
Read more