How to suggest input to ajax enabled combobox in ASP.NET C#

Question

0.00/5 (No votes)

See more:

Hello,

Here i have ajax enabled combobox in asp.net.I have populated this combobox using sql server database.Now problem is that when i am goind to search or suggest input to combobox then it search only from start index.I want to search any where in string
for eg.
when i type test then combobox must have to show all string those contains test word.

What I have tried:

This is my design page code

  <asp:ScriptManager ID="ScriptManager1" runat="server">
  </asp:ScriptManager>
<cc1:ComboBox ID="cmbLocationList" runat="server" Width="200PX"
      AutoPostBack="true"  AutoCompleteMode="SuggestAppend"
    >
  </cc1:ComboBox>

Posted 26-Oct-17 20:38pm

SujataJK

Updated 27-Oct-17 23:08pm

Add a Solution

Comments

Karthik_Mahalingam 27-Oct-17 5:40am

show the code of the Combobox user control ?
you will have to add like condition in the query.

SujataJK 27-Oct-17 7:59am

In my code combobox is bind in page_load().

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadLocationList();
}

}

private void LoadLocationList()
{
SqlConnection con = null;
SqlCommand cmd = null; ;
SqlDataReader dr;
try
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["CRMConnection"].ConnectionString);

cmd = new SqlCommand("select locationname from dbo.tbl_LocationMaster");
con.Open();
cmd.Connection = con;
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);
//dr = cmd.ExecuteReader();
if (ds.Tables[0].Rows.Count > 0)
{

cmbLocationList.DataSource = ds;
cmbLocationList.DataBind();
cmbLocationList.DataTextField = "locationname";
cmbLocationList.DataValueField = "locationname";
cmbLocationList.DataBind();
cmbLocationList.Items.Insert(0, new ListItem(" ", ""));
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Message", "alert('No Data Found')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Message", "alert('" + ex.Message + "')", true);
}
finally
{
cmd.Dispose();
con.Close();
}

}

Karthik_Mahalingam 27-Oct-17 8:00am

Do you have the code for user control?

SujataJK 27-Oct-17 8:17am

actually i am new to this concept.i have not added any user control.Please guide me how to use this.

Karthik_Mahalingam 27-Oct-17 8:22am

cc1:ComboBox

It's an user control or ajaxtoolkit control?

SujataJK 27-Oct-17 8:47am

Its ajax control

SujataJK 27-Oct-17 8:13am

No

Karthik_Mahalingam 27-Oct-17 8:23am

Then how to customize it

SujataJK 27-Oct-17 8:36am

as per my knowledge ajax combobox allows user autocomplete textbox using AutoCompleteMode="SuggestAppend" property

Karthik_Mahalingam 28-Oct-17 5:08am

check the link posted in solution, it will do the contains search

1 solution

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)

Karthik_Mahalingam · Accepted Answer · 2017-10-27T23:07:00

Solution 1

check this Combobox Search throughout the string | The ASP.NET Forums[^]

Posted 27-Oct-17 23:07pm

Karthik_Mahalingam