如何在asp上删除重复项目:dropdownlist，Sharepoint Designer 2013

Question

我在dataviewwebpart上使用了asp:drowdownlist，并绑定了源spdatasource1。它有多个重复项。我如何删除那些重复的项目

asp:DropDownList runat="server" id="DropDownList1" DataValueField="ID" DataTextField="ProgramMaster" DataSourceID="spdatasource1" AutoPostBack="False" AppendDataBoundItems="True" ToolTip="Select a Program from the list"/>

此外，它还在以下形式的ID;#ProgramName中显示项目。如何才能仅获取programName。

Answer 1

我使用JQuery从asp:dropdownlist中删除重复的项，这是代码，以防有人需要它。代码分为四个部分，从Dropdown中获取值，剥离重复项并以可用形式获取值，从Dropdown中删除现有值，最后设置或将值追加到下拉列表中。

<script type="text/javascript">
$(document).ready(function(){
var handles= [];               
$('#DropDownList1 option').each(function() { 
var Prog1 = $(this).attr('text');
if(Prog1 != 'All'){
var Prog2 = Prog1.split(';#');
handles.push('All');
handles.push(Prog2[1]);
 }
//Remove The existed Dropdownlist value
$("select#DropDownList1 option[value='" + $(this).val() + "']").remove();
//$(this).val().remove();
});
//Removing the Duplicates
var individual = [];
for (var i = 0; i<handles.length; i++) {
if((jQuery.inArray(handles[i], individual )) == -1)
{
individual .push(handles[i]);
} 
 }
//Inserting or setting the value from array individual to the dropdownlist.  
var sel =   document.getElementById('DropDownList1');
for(var i = 0; i < individual.length; i++) {
var opt = document.createElement('option');
opt.innerHTML = individual[i];
opt.value = individual[i];
sel.appendChild(opt);
    }
 });
</script>

备注:如果给定的ID不适用于下拉菜单，请从IE调试工具中获取ID，该工具的格式为ctl00_PlaceHolderMain_g_a0a2fb36_2203_4d2e_bcd4_6f42243b880f_DropDownList1

Answer 2

您可以使用jquery完成此操作

var usedNames = {};
$("select[name='company'] > option").each(function () {
if(usedNames[this.text]) {
    $(this).remove();
} else {
    usedNames[this.text] = this.value;
}
});

或者使用服务器端代码尝试以下代码

void RemoveDuplicateItems(DropDownList ddl)
{

for (int i = 0; i < ddl.Items.Count; i++)
{

ddl.SelectedIndex = i;
string str = ddl.SelectedItem.ToString();
for (int counter = i + 1; counter < ddl.Items.Count; counter++)
{
ddl.SelectedIndex = counter;
string compareStr = ddl.SelectedItem.ToString();
if (str == compareStr)
 {
  ddl.Items.RemoveAt(counter);
  counter = counter - 1;
 }  


}    }     }