AJAX :: AutoComplete TextBox Without Using AutoCompleteExtender
Jan 24, 2016I want to have textbox auto complete with sql database but i do not want to use ajax extender ...
View 1 RepliesI want to have textbox auto complete with sql database but i do not want to use ajax extender ...
View 1 RepliesWhich is best one to autocomplete textbox whether ajax autocomplete or jquery autocomplete ....
View 1 RepliesI'm creating just simple autocomplete sample.
taking one textbox adding autocomplete extender as
<asp:ScriptManager ID="ScriptManager2" runat="server">
<Services>
<asp:ServiceReference Path="WebService.asmx" />
</Services>
</asp:ScriptManager>
<asp:TextBox ID="TextBox1" runat="server" EnableTheming="True" ></asp:TextBox>
<cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" MinimumPrefixLength="1" ServiceMethod="GetCountryInfo" ServicePath="WebService.asmx" TargetControlID="TextBox1">
</cc1:AutoCompleteExtender>
<asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
Also creating web services as "WebService.asmx" & code inside this file is that
<%@ WebService Language="C#" CodeBehind="~/App_Code/WebService.cs" %>
------
then in Webservice.cs file i write code as
public class WebService : System.Web.Services.WebService {
MySql.Data.MySqlClient.MySqlCommand cmd = new MySqlCommand();
MySql.Data.MySqlClient.MySqlConnection con = new MySqlConnection();
//MySqlDataAdapter da = new MySqlDataAdapter();
MySqlDataReader dr;
public WebService () {
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public string[] GetCountryInfo(string prefixText)
{
int count = 10;
string sql = "Select * from tbl_patientmaster Where P_NAME like '" + @prefixText + "%'";
con.ConnectionString = System.Configuration.ConfigurationManager.AppSettings["HMSDBConnectionString"].ToString();
con.Open();
MySql.Data.MySqlClient.MySqlDataAdapter da = new MySql.Data.MySqlClient.MySqlDataAdapter(sql, con);
da.SelectCommand.Parameters.Add("@prefixText", MySql.Data.MySqlClient.MySqlDbType.VarChar, 50).Value = prefixText + "%";
System.Data.DataTable dt = new System.Data.DataTable();
da.Fill(dt);
string[] items = new string[dt.Rows.Count];
int i = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
items.SetValue(dr["P_NAME"].ToString(), i);
i++;
}
return items;
}
this code is not working
I have implemented autocompleteextender on textbox, everything works fine, however please help me with this minor thing.In textbox whenever I enter a value it get stored in memory
e.g I have typed 'hello' & press enter. The next time I press 'h', 'hello' appears below it, & hides the autocompleteextender. Is there a way to switch this function of text box
can I have an auto extender to my textbox which is in datagridview. I am using it in footer template for inserting a new row to the gridview.
View 1 RepliesHow can I combine the TextBox and the AutoCompleteExtender, such that they become a single control the way the ComboBox is?
View 3 RepliesI am retrieving list of projects and project IDs using autocompleteextender.I want a kind of functionality that doesn't allow user to input any characters (or)will change the text box color if the input doesn't retrieve any value from database.Though, I have found a solution by calling function through OnClientPopulated. But this function calls back the webservice "GetCompletionList" method.I don't want to recall one method two times..
View 5 Replies>I am trying to add a Ajax AutoCompleteExtender to a Textbox (template) in a Gridview.
>In a different projects I have used a A.C.E with a Texbox on a form and it works In a different project I have used the gridview >RowDatabound event to locate and added attributes that monitor keys stroke and the like (via java)
>BUT :(
>I am having a problem getting my head around how I connect the Ajax A.C.E to the Textbox in the gridview.
>My guess is, it is probably by adding an attribute to the textbox of the gridview but how do I reference / link the Ajax A.C.E.
>My aim is to add a combobox to a gridview ie a dropdownlist that the user can also type into.
>PS I am using VS 2005 - .Net 2. - c#
How to Clear ASP.Net AJAX AutoCompleteExtender TextBox after select using javascript...
View 1 RepliesI'm using the AutoCompleteExtender control with a textbox. The control functions the way I want it to but I have one issue with it. When the page first loads I type something in the textbox and I get a list of suggestions from my database. When the list is quite big the vertical scroll bar appears on the right side of the browser window and the textbox is repositioned to the center of the page (I want the textbox to be centrally positioned and I'm using <center> tags). Unfortunately the AutoCompleteExtender list doesn't reposition and is misaligned. The same thing happens when the browser window is resized.
I've played around with CSS and OnClientShown and haven't managed to fix this. I'm currently using IE8.
I am using the autocompleteextender control in a project I am working on for a client, but I would like to be able to match words in the middle of the data I am searching. Controls such as the search textbox on sites like Netflix do this. For example, if I go to Netflix and search for 'wolfman' I get results like:
The Wolfman
The Real Wolfman
House of the Wolfman
With the extender I would only get results beginning with 'wolfman'. If my stored procedure in my webservice is written to do search the text as I want, nothing shows in the extender (I'm guessing because so many top results don't begin with the entered text). Is there a way to get the autocompleteextender to behave more like this?
Is it possible to user the Ajax AutocompleteExtender referencing a TextBox in a Cell in the GridView Footer?
Code:
[code]....
I am trying to add a Ajax AutoCompleteExtender to a Textbox (template) in a Gridview.In a different projects I have used a A.C.E with a Texbox on a form and it worksIn a different project I have used the gridview RowDatabound event to locate and added attributes that monitor keys stroke and the like (via java)BUT :(I am having a problem getting my head around how I connect the Ajax A.C.E to the Textbox in the gridview.My guess is, it is probably by adding an attribute to the textbox of the gridview but how do I reference / link the Ajax A.C.E.ORHave I just got in complete wrong?My aim is to add a combobox to a gridview ie a dropdownlist that the user can also type into.
View 1 RepliesI have an auto complete extender applied to my textbox as follows:
[Code]....
In the web pages code behind I have the following method:
[Code]....
there is no errors, I've tested and debugged the code inside GetCustomers() and it returns the data - just doesn't display it.
I've been stymied for a few days on and interface issue with Autocompleteextender and a simple textbox. Is the user types in the textbox while the scroll position of the page is near the top, the autocomplete pops under the textbox, just like it should.However, when I scroll down a little, the autocomplete pops over top of the textbox, making it impossible to see what you are typing. How do I force the autocomplete to pop under the textbox no matter the scroll position of the page? My code is below:
[Code]....
I need to have the contextKey determined by a TextBox. I am trying the approach by kirtid in
http://forums.asp.net/t/1119865.aspx
[Code]....
Both autoComplete and autoComplete2 are null.
What am I doing wrong?
How to do autocomplete textbox Images in asp.net like IMDB or APPLE SITE OR jules.co.uk with database connections..
Note:i have to do similar autocomplete like above mentioned sites..
I am using an autocomplete in textbox and the values are from database.It is working fine.What i need is to do this autocomplete thing in listview when i enter any value in textbox. Here is my code
<asp:TextBox ID="txtContactsSearch" runat="server"></asp:TextBox>
<cc1:AutoCompleteExtender ServiceMethod="ListView1_SelectedIndexChanged"
MinimumPrefixLength="2" CompletionInterval="100" EnableCaching="false"
CompletionSetCount="10" TargetControlID="txtContactsSearch"
ID="AutoCompleteExtender1" runat="server" FirstRowSelected = "false"> </cc1:AutoCompleteExtender>
[Code]......
So I got a textbox with an autocomplete source pulled from a database. I am using the follow code to fill the Autocomplete.
txtResource.AutoCompleteCustomSource.AddRange((From row In myComputers.Resources Where row.Active = True And row.ResourceTypeID = CBOResourceType.SelectedValue Select row.Resource).ToArray)
What I would like to do is autocomplete for items in the middle of the search term.For example I have, "Cat","Dog","Dog Horse", "Cat Fish", "Horse Fly"
When I type in Cat my results are: Cat and Cat Fish
When I type in Horse my results are: Horse Fly
I want the results for Horse to be: Dog Horse and Horse Fly. How can I do this?
use below styles.
/*AutoComplete flyout */
.autocomplete_completionListElement { margin : 0px!important;
background-color : inherit; color : windowtext;
border : buttonshadow; border-width : 1px; border-style : solid;
cursor : 'default'; overflow : auto; height : 200px; text-align : left; list-style-type : none;}
/* AutoComplete highlighted item */
.autocomplete_highlightedListItem{ background-color: #ffff99;
color: black; padding: 1px;}
/* AutoComplete item */
.autocomplete_listItem { background-color : window; color : windowtext;
padding : 1px;}
the respective markup :
<asp:TextBox runat="server" ID="myTextBox" Width="300" autocomplete="off" /> <ajaxToolkit:AutoCompleteExtender runat="server" BehaviorID="AutoCompleteEx" ID="autoComplete1" TargetControlID="myTextBox"
[code]...
I'm having some difficulty adding an autocomplete extender to a textbox and getting it working.
I've read through the samples and did a quick search on here, but cannot work out why it isn't working.
In a nutshell...
I've added a textbox onto a page, and added the autocomplete extender along with the AutoComplete page method.
Page
[Code]....
Code Behind
[System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
public string[] GetCompletionList(string prefixText, int count, string contextKey)
{
StaffADBLL staff = new StaffADBLL();
DataTable dtStaff = staff.FindStaff(prefixText);
string[] items = new string[dtStaff.Rows.Count];
int i = 0;
foreach (DataRow row in dtStaff.Rows)
{
items.SetValue(row["displayName"].ToString(), i);
i++;
}
return items;
}
I've even tried adding an asmx file, and that doesn't work either.
I get no errors and when I start typing nothing happens, it doesn't even produce a list after 3 characters.
I tried to debug and it doesn't debug through the code, skips it completely.
the name of my aspx page is display.aspxin header of this page i have called a javascript jscript.jsinside jscript.js there is a call to acomp.aspx which fetches autocomplete results which are displayed on textbox dropdown on display.aspxafter selecting an item from the textbox dropdown, i have to press search btn to response.redirect to other page.but i want to response.redirect as soon as autocomplete item is clicked.this is my textbox with auto-complete feature:
<asp:Textbox ID="search_input" runat="server" Text="Search by Name or Zip Code" AutoPostBack="true" ToolTip="Search by Name or Zip Code" />
this is my aspx.vb code:
Protected Sub search_input_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles search_input.TextChanged
Response.Redirect("~/star/billing/search.aspx? "value=" & search_input.Text)
End Sub
now, onchange of search_input text, my old text is passed inthe response.redirect url.!!! but i want to pass changed text! old text means that text wich is input to start autocomplete
I have 4 xml files.When user select any one xml file and and enter data into textbox
it populates data from xml file.
My xml file is
[Code]....
When User typed as '13' in textbox....how retrive all 13 related data into textbox using autocomplete control. i want populate data
[Code]....
I've writed the follow web service:
[Code]....
And i'm using the AutoComplete like this:
[Code]....
But it's not working (it doesn't suggest any value at all).Am i doing something wrong?
I have a textbox which takes data from autocomplete.
I want to check the textbox text and if the text wasn't taken from autocomplete extender, I want to clear the text.