jq下拉可输入可选模糊查询
查看各种大佬写的,唯有这个最称心满意【https://blog.youkuaiyun.com/weixin_30493321/article/details/96922723】
鉴于微软自带的DropDownList并没有可输入这个功能,所以找到了这个完美的方案,代码又简洁。
html:
<input list="browsers">
<datalist id="browsers">
<%=selectHtml %>
</datalist>
aspx.cs
string sql_new = string.Format(@"SELECT id,activity_name,quan_property FROM dbo.tb_activity_bizhong_10289 where quanCreateType=0");
var dt1 = SQL.GetDataTable(sql_new);
if (dt1 != null)
{
//Bind.AddItem(this.tb_activity_bizhong_id, new string[] { " ", "-1" });
if (dt1.Rows.Count > 0)
{
for (int i = 0; i < dt1.Rows.Count; i++)
{
DataRow dr = dt1.Rows[i];
if (dr["quan_property"].ToString()=="1")
{
selectHtml += "<option value=" + "【金额】" + dr["activity_name"] + ">";
}
if (dr["quan_property"].ToString() == "2")
{
selectHtml += "<option value=" + "【数量】" + dr["activity_name"] + ">";
}
if (dr["quan_property"].ToString() == "5" || dr["quan_property"].ToString() == "6")
{
selectHtml += "<option value=" + "【定量】" + dr["activity_name"] + ">";
}
}
}
}
- 输入的效果
- 不输入的效果