JQuery Searchable DDL inside Datagrid

Riddhi Valecha

7y1.4k.NET

Dear All,

My ASPX Design is -

<table class="tablebg" style="width: 841px;" cellspacing="1" cellpadding="3"
align="center" border="0">
<tr class="tdwhite">
<td colspan="4" style="font-weight: bold">Ultimate Holding Company
<asp:DataGrid ID="dgUltimateHoldingCompany" runat="server" Width="100%" AutoGenerateColumns="False"
PageSize="20">
<HeaderStyle Font-Bold="True">HeaderStyle>
<Columns>
<asp:BoundColumn Visible="False" DataField="srnoUltimateHoldingCompany_" ReadOnly="True" HeaderText="srno_">asp:BoundColumn>
<asp:BoundColumn Visible="False" DataField="rowidUltimateHoldingCompany" ReadOnly="True" HeaderText="ROW_ID">asp:BoundColumn>
<asp:TemplateColumn Visible="False" HeaderText="rowid">
<ItemTemplate>
<asp:TextBox ID="txtdrowidUltimateHoldingCompany" Visible="False" BorderStyle="Groove" ReadOnly="True"
runat="server" Style="width: 100%">asp:TextBox>
ItemTemplate>
asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Ultimate Holding Entities">
<HeaderStyle Font-Bold="True">HeaderStyle>
<ItemTemplate>
<asp:DropDownList ID="ddlEntitiesUltimateHoldingCompany" Width="400px" runat="server">
asp:DropDownList>
ItemTemplate>
asp:TemplateColumn>
Columns>
asp:DataGrid>
td>
tr>
table>

Query - How to make this DropDownList - ddlEntitiesUltimateHoldingCompany - as Auto Searchable DDL using JQuery.

Please guide

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Riddhi Valecha6y ago
Dear Team,
After a long struggle, I am able to implement both - JQuery Date and JQuery Searchable DropDownList
Issue is - Dropdownlists are overlapping.
Attached file is the image of overlapping DDL.
PLease guide in this matter.
All solutions / suggestions are welcomed..
My ASPX Page Design -
------------------

PageSize="20">
Riddhi Valecha6y ago
Dear All,

Please help in implementing the solutions from the below reference links -

https://stackoverflow.com/questions/28295836/asp-net-gridview-edit-item-template-make-searchable-dropdown
https://m.soohba.com/questions/28295836/asp-net-gridview-edit-item-template-make-searchable-dropdown
http://sharepointdotnetarticles.blogspot.com/2012/12/jquery-autocomplete-inside-gridview.html

How do write the addSearch function ??
Riddhi Valecha6y ago
Dear Team,

I found one more reference link - It says -

you can bind onLoad Event for the drop down

then at the code behind you can register your script

protected void ddl_Load(object sender, EventArgs e)
{
ClientScript.RegisterStartupScript(Page.GetType(), "msg",
"addSearch('" + ((DropDownList)sender).ClientID + "');", true);
}

the addSearch is a javascript function which contains the logic af adding the js plugin

Please help me in making this "äddsearch" function.

Link - https://m.soohba.com/questions/28295836/asp-net-gridview-edit-item-template-make-searchable-dropdown
Amit Kumar7y ago
Hi, I have already given the link first understand then implement it because it is very easy.
Riddhi Valecha7y ago
Dear Team,
PLease help me in implementing the solution given in the link -

Reference -

https://stackoverflow.com/questions/28295836/asp-net-gridview-edit-item-template-make-searchable-dropdown

----------

PLease guide on this...
Riddhi Valecha7y ago
How do we make DDL Searchable from code - behind ??

PLease guide..
Riddhi Valecha7y ago
PageSize="20" OnDeleteCommand="DelCmd">

runat="server" Style="width: 100%">

CausesValidation="False">
Text="Edit" CausesValidation="False">
-----------------------
Query -
How do I make this DropDownList ID="ddlFruits" as searchable ?

When a "btnaddtest" button is clicked ,a new row is created in the datagrid.

This way, for all the rows, the DropDownList = "ddlFruits" will be searchable.
Riddhi Valecha7y ago
Dear Team,
There is a "Delete" option in the datagrid.
Please help me in -

When Delete button is clicked , I should get the Srno_ value.
System should ask - Do you want to delete the record.
If user clicks "YES" , it should remove the record.

ASPX Design -

PageSize="20" OnDeleteCommand="DelCmd">

runat="server" Style="width: 100%">

CausesValidation="False">
Text="Edit" CausesValidation="False">
Amit Kumar7y ago
Hi, Go to the below link it will sure help you. https://www.dotnettechpoint.com/2018/02/search-data-from-html-table-using-jquery.html?m=1
Riddhi Valecha7y ago
Dear Team,

I have a datagrid.... How do I make a searchable Dropdownlist inside a datagrid ?

My ASPX Design -

Red
Green
Orange
Yellow

---------
I need to make this ddl (List Of Colours) searchable as there are more than 50 Colours in the list.
Riddhi Valecha7y ago
Dear Gajendra sir,

This reference was given earlier ...
Riddhi Valecha7y ago
Hello sir,

In the link - https://www.aspsnippets.com/Articles/Find-and-validate-TextBox-and-DropDownList-controls-in-GridView-row-using-jQuery-in-ASPNet.aspx

-- the dropdownlist is not searchable.
Riddhi Valecha7y ago
Hello sir ...
This is not my requirement.
The links shows the validations of textbox and DDL inside a gridview.

I need - "Searchable DDL" inside a GridView.

There is no searching option here ....
Gajendra Jangid7y ago
hello dear,

https://www.aspsnippets.com/Articles/Find-and-validate-TextBox-and-DropDownList-controls-in-GridView-row-using-jQuery-in-ASPNet.aspx