display list in combo box as per user inputs.

Question

3.40/5 (2 votes)

See more:

I am using combo box to show supplier name. In search facility when user type “S” in combo box the entire supplier’s list should be display whose name start form “S”, like country, state search facility in any web based application. Same way as per user inputs list should be change.
Can any one know logic behind this

Posted 1-Jan-13 19:59pm

Yogi ,Pune

Updated 10-Jul-13 4:05am

Mahesh_Bhosale

v4

Add a Solution

3 solutions

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)

**Zoltán Zörgő** · Answer 1 · 2013-01-01T20:05:00

Solution 1

You need to use autocomplete ajax extender. Look at this article for description and sample: http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/AutoComplete/AutoComplete.aspx[^]

Posted 1-Jan-13 20:05pm

Zoltán Zörgő

prashant patil 4987 · Answer 2 · 2013-01-01T20:06:00

Solution 2

hey try to use autocomplete extender instead of Conbobox..
Refer Below Link.
AutoComplete extender[^]
ASP.Net Ajax AutoCompleteExtender Without Using Web Service[^]

Posted 1-Jan-13 20:06pm

prashant patil 4987

Qadri Jillani · Answer 3 · 2013-07-10T11:24:00

This funcionality is called auto-complete
first of all you will need this js file:

XML

jquery-ui-1.8.20.custom.min.js

and css file:

XML

jquery-ui-1.8.20.custom.css

1.place link of these files on page where you want to use auto-complete just like this:

HTML

<script src="Scripts/jquery-ui-1.8.20.custom.min.js" type="text/javascript"></script>
   <link href="Styles/jquery-ui-1.8.20.custom.css" rel="stylesheet" type="text/css" />

2.then use this script:

JavaScript

    <script type="text/javascript">
        $(document).ready(function () {
            $('input[id$=textboxid]').autocomplete({
                source: function (request, response) {
                    $.ajax({
                        type: "POST",
                        contentType: "application/json; charset=utf-8",
                        url: "pagename.aspx/getReason",
                        data: "{'keywords':'" + request.term + "'}",
                        dataType: "json",
                        async: true,
                        success: function (data) {
                            response(data.d);
                        },
                        error: function (result) {
                            //alert("Error");
                        }
                    });
                },
                minLength: 2
            });

        });
</script>

3.then add this method in code behind (.cs) file:

C#

[WebMethod]
   public static IList<string> getReason(string keywords)
   {
       int count = 0;
       IList<string> result = new List<string>();
       string constr = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString;
       SqlConnection con1 = new SqlConnection(constr);
       SqlCommand cmd1 = con1.CreateCommand();
       cmd1.CommandText = "select distinct column_name from tablename where column_name like '%" + keywords + "%'";
       try
       {
           con1.Open();
           SqlDataReader dr = cmd1.ExecuteReader();
           while (dr.Read())
           {
               count++;
               result.Add(dr["column_name"].ToString());
               if (count == 100)
                   break;
           }
           con1.Close();
           return result;
       }
       catch
       {
           return null;
       }
   }