Taxonomy Term Data Binding With Dropdown List In SharePoint App Model

Rupali Shinde

SharePoint SharePoint AppSharePoint App ModelTaxonomy Term Data Binding

9 Comments

Join the conversation! Your thoughts help the community grow.

F Moser7y ago
What would the assembly or name space be for SharePointContextProvider?
Venkatesh Kumar10y ago
is it possible to build/get term group data as tree structure or parent/child relationship using CSOM?
- Rupali Shinde10y ago
  do you mean to say using javascript ??
Santhakumar Munuswamy11y ago
Good one
Rupali Shinde11y ago
Thanks
Nilesh Jadav11y ago
Good Share mam !!
Rakesh11y ago
Good article Share
Rahul Suryawanshi11y ago
Nice share!
Harshad Pansuriya11y ago
Nice one

Term Store Manangement

How to access SharePoint Site Term Store Management?

Go to SharePoint Site, then Site Settings and select Term Store Management.

Term Store Management Concept

SharePoint APP Model

Step 1: Add Permission in AppManifest.xml file to read Taxonomy as follows.

permissions

Step 2: User Interface Design Page.

Taxonomy.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Texonomy.aspx.cs" Inherits="SP_TexonomyProWeb.Pages.Texonomy" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td>
<asp:Label ID="Label1" runat="server" Text="Region"></asp:Label></td>
<td>
<asp:DropDownList ID="ddlDepartment" runat="server"></asp:DropDownList></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td>
<asp:Label ID="Label2" runat="server" Text="Division"></asp:Label></td>
<td>
<asp:DropDownList ID="ddlJobTitle" runat="server"></asp:DropDownList></td>
</tr>
</table>
</div>
</form>
</body>
</html>

Taxonomy.aspx.cs

using Microsoft.SharePoint.Client.Taxonomy;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace SP_TexonomyProWeb.Pages
{
public partial class Texonomy : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string TermStoreName = "Managed Metadata Service";
string TermGroupName = "Texo";
BindTermstoDropdown(TermStoreName, TermGroupName, "Region", ddlDepartment);
BindTermstoDropdown(TermStoreName, TermGroupName, "Categories", ddlJobTitle);
}
protected void BindTermstoDropdown(string TermStoreName, string TermGroupName, string TermSetName, DropDownList ddl)
{
var spContext = SharePointContextProvider.Current.GetSharePointContext(Context);
using (var clientContext = spContext.CreateUserClientContextForSPHost())
{
clientContext.Load(clientContext.Web, web => web.Title);
clientContext.ExecuteQuery();
Response.Write(clientContext.Web.Title);
// Get the TaxonomySession
TaxonomySession taxonomySession = TaxonomySession.GetTaxonomySession(clientContext);
// Get the term store by name
TermStore termStore = taxonomySession.TermStores.GetByName(TermStoreName);
// Get the term group by Name
TermGroup termGroup = termStore.Groups.GetByName(TermGroupName);
// Get the term set by Name
TermSet termSet = termGroup.TermSets.GetByName(TermSetName);
// Get all the terms
TermCollection termColl = termSet.Terms;
clientContext.Load(termColl);
// Execute the query to the server
clientContext.ExecuteQuery();
// Loop through all the terms
DataTable dt = new DataTable();
dt.Columns.Add("TermName");
DataRow row = null;
foreach (Term term in termColl)
{
row = dt.NewRow();
row["TermName"] = term.Name;
dt.Rows.Add(row);
}
ddl.DataSource = dt;
ddl.DataTextField = "TermName";
ddl.DataValueField = "TermName";
ddl.DataBind();
}
}
}
}

Output:

Output

Thank you! If you have any query, then please mention it in the comment section.