how to populate textbox on autocomplete jquery

Question

0.00/5 (No votes)

See more:

Hi guys,

i have asp.net website,
where i have a textbox with autocomplete jquery function,
now
i want to populate other textboxes based on the selection of autocomplete textbox.

jquery code:

<script type="text/javascript">
    $(document).ready(function () {
        $("#<%=txtSearch.ClientID %>").autocomplete({
            source: function (request, response) {
                $.ajax({
                    url: '<%=ResolveUrl("~/Service.asmx/GetCustomers") %>',
                    data: "{ 'prefix': '" + request.term + "'}",
                    dataType: "json",
                    type: "POST",
                    contentType: "application/json; charset=utf-8",
                    success: function (data) {
                        response($.map(data.d, function (item) {
                            return {
                                label: item.split('-')[0],
                                val: item.split('-')[1]
                            }
                        }))
                    },
                    error: function (response) {
                        alert(response.responseText);
                    },
                    failure: function (response) {
                        alert(response.responseText);
                    }
                });
            },
            select: function (e, i) {
                $("#<%=hfCustomerId.ClientID %>").val(i.item.val);
            },
            minLength: 1
        });

    }); 
</script>

can anyone plz help me, how to populate other textboxes based on autocomplete textbox.

Thanks

Posted 12-Oct-14 5:24am

abdul subhan mohammed

Add a Solution

Comments

[no name] 12-Oct-14 12:10pm

if your text box for autocomplete is getting populated with the selected value, then based on that value, you can populate the other textboxes.

abdul subhan mohammed 13-Oct-14 3:30am

i have a autocomplete textbox, once d user select any value, i want to populate remaining description textboxes based on autocomplete textbox, so i have tried n make the autocomplete textbox as autopoast="true", but its not calling that event to populate other textboxes. Can i populate other textboxes in jquery where i wrote for autocomplete textbox.

[no name] 13-Oct-14 3:36am

In the select method of autocomplete does not the function for populating the other textboxes works??

abdul subhan mohammed 13-Oct-14 3:57am

no, do u have code like that..?

[no name] 13-Oct-14 4:01am

Please check my solution. I have given u a fiddle and a small change to your peice of code. Please check and respond back if that works.
Thanks

abdul subhan mohammed 13-Oct-14 4:08am

that is awesome fiddle, 5*. But i'm fetching data from database as an array.
so, how to call data in the select function. plzzz

[no name] 13-Oct-14 4:09am

Will respond back soon after lunch. Thanks

[no name] 13-Oct-14 4:07am

Did you try??

abdul subhan mohammed 13-Oct-14 4:10am

i want to get database value in the select function.

abdul subhan mohammed 13-Oct-14 4:14am

My WebService From where i'm fetching d data:
[WebMethod]
// [System.Web.Script.Services.ScriptService]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public string[] GetCustomers(string prefix)
{
List<string> customers = new List<string>();
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager
.ConnectionStrings["CnnStr"].ConnectionString;
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "select New_Ref, RecID from [DB_9B08BD_automobile].[dbo].[tbl_References] where " +
"New_Ref like '%' + @SearchText + '%'";
cmd.Parameters.AddWithValue("@SearchText", prefix);
cmd.Connection = conn;
conn.Open();

using (SqlDataReader sdr = cmd.ExecuteReader())
{
//DataTable dt = new DataTable();
//dt.Load(sdr);
while (sdr.Read())
{
customers.Add(string.Format("{0}-{1}", sdr["New_Ref"], sdr["RecID"]));
}
}
conn.Close();
}
return customers.ToArray();
}
}

[no name] 13-Oct-14 5:09am

you can do one thing here. In your scripts declare a global variable as an array and assign all your values passed from your view. Then you can use this variable in the select function also.

abdul subhan mohammed 13-Oct-14 10:14am

can u show me some eg code, plzzz

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 12-Oct-14 12:32pm

Repost of - http://www.codeproject.com/Answers/828250/how-to-find-control-id-from-a-repeater-in-JQuery?cmt=685455#answer1

Hey Abdul, please don't repost. As I asked you in that question, please reply there. You have to use developer tool and debug.

abdul subhan mohammed 13-Oct-14 3:26am

Hi Tadit, its not my repost, both questions are different,
here i'm requesting to know, how to populate multiple textboxes based on autocomplete textbox. U can verify both.
plz help me, if u have any suggestions.
Thanks

2 solutions

Solution 2

BAsed on your comment Abdul, I found this solution. Please check if you get any help else respond back..:)
Query on code snippet to assign values from server side to array in javascript[^]
Thanks
:)

Posted 13-Oct-14 5:56am

Suraj Sahoo | Coding Passion

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suraj Sahoo | Coding Passion · Accepted Answer · 2014-10-12T21:58:00

Please use

C#

select: function (e, i) {
                $("#<%=hfCustomerId.ClientID %>").val(i.item.value);
            },

This should work, else take a look at the fiddle below.
Fiddle for your Question[^]
Please check the above fiddle, in which I have populated two textboxes on select of autocomplete value.
One text box with the selected value
and other static string.
Hope this helps
:)