AJAX :: Get The ID With AutoComplete?
Mar 28, 2011
I'm trying to create an autocomplete textfield using a database as source.
The user needs to enter a few letters and his/her name (record by the combination of 2 columns 'firstname' and 'lastname') pops up as a suggestion. The problem is that I would like to get the id of that record, since I need to get a hold of the rest of the user details.
I currently have this code:
[Code]....
In the ASPX page, I've tried this:
[Code]....
[Code]....
So generally, I think that my code is working as it should be. However, there seems to be a problem with returning both of the values so that the javascript is able to seperate them.
View 3 Replies
Similar Messages:
Sep 29, 2010
I'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
View 1 Replies
Aug 10, 2010
I am tring to use Jquery autocomplete into my asp.net 2.0 application, I have all necessary file in place, I tried to worked on , but it seems like this is not working,can some one tell me that is asp.net 2.0 application without using AJAX toolkit works with Jquery autocomplete or it does not work?Note: this is plain asp.net 2.0 web application, it is not using AJAX.
View 6 Replies
Jan 27, 2010
I'm using C# and having problems with nested usercontrol within a usercontrol having AutoComplete textbox. I successfully implemented AutoComplete textbox in a usercontrol but doesnt work with nested one. The webservice does get called and i get the dropdown, but on selecting the text from the dropdown doesnt set the value in the hidden field. Tried to debug using Firebug, but it doesnt break at this function
View 2 Replies
Jan 25, 2011
i sample code for how to use wcf with ajax autocomplete
View 3 Replies
Feb 17, 2011
I'm using jQuery AutoComplete Plugin in ASP.Net as outlined in the article below, so that as a user types in a .Net textbox they get a list of options to choose them. This works fine, but what I need to do now is call a server side function when the user has finished typing or has choosen a value, rather than the user having to submit the value by pressing a button.
View 2 Replies
Aug 10, 2010
I am using Ajaxtoolkit 3.5.I am using an autocomplete textbox extender.My problem is I have populated Country in the autocomplete textbox.I have to populate city in another dr
View 1 Replies
Nov 1, 2010
I've looked at this link and I've tried all the suggestions there, but my Asp.Net AJAX Autocomplete still isn't working.
I have a test project with only a label, text box an the auto-completer:
<asp:ToolkitScriptManager ID="ScriptManager" runat="server">
</asp:ToolkitScriptManager>
<asp:Label ID="FieldLabel" Text="Label:" runat="server"></asp:Label>
[code]....
In theory, my textbox should have an autocomplete dropdown containing 3 instances of the word "test". In practice, I can type anything I want into the textbox and nothing happens.
View 2 Replies
Jul 13, 2010
as you can see on this page: http://immobilzero.com/Prov2.aspx i have an autocomplete associated to textbox
the problem is not animation because i tried to delete but is that in the first time it appears, it goes too highter!!!
this is the code i use;
[Code]....
View 8 Replies
Jan 14, 2011
how to use autocomplete extender in asp.net
View 1 Replies
Apr 7, 2010
I've been racking my brains out trying to get this to work. I've followed multiple tutorials to the letter and I have had no luck.
Here is my Default.aspx page:
[Code]....
Here is my WebService.asmx.cs file:
[Code]....
I don't know what else there is to do. I have a zip of my solution here: [URL]
Edit: I forgot to add that I am able to run the WebService by itself. It returns the values from the function. The function is never invoked from the aspx though.
View 11 Replies
Apr 21, 2010
I want to implement the AutoComplete extender in my application. What I really want to capture is the EmployeeID. Obviously I want to display employee's name. Is there a way to do this?
I can return the employee name and do another look up but that's two hits on the database.
View 2 Replies
Jun 7, 2010
I am using AJAX Control toolkit V-1.0.
I am coming across one problem with auto complete extender in my application, problem seems to simple but i can't find any satisfactory solution. In one form, i have set auto complete extender on one text box, i have set one web service, in which one function is there, which fetches existing records from db, on first load, if i write releavent words with that of db, i can't see the extender, but if once either i minimize the page or give tab despite AutoPostBack property of text box is false, then after writing something in text box shows me the extender.
Here are the properties of both text box and extender
<asp:TextBox
ID="txtCompanyName"
runat="server"
CssClass="txt"
MaxLength="100"
TabIndex="4"
Width="443px"
></asp:TextBox>.........
View 1 Replies
Feb 18, 2010
I added an autocomplete extension to a textbox, set up the web service and everything else I needed to get back autocomplete data, traced through debugger to make sure I was getting back the results I needed - - but still no autocomplete results. I thought maybe it was because my textbox was within a formview, within a wizard control, within a master page that was preventing me from seeing the results, so I set up a standalone ajax webpage, put in a textbox, set my service method and service path properties, and let it rip. Still no results.
Finally, after tearing out clumps of hair, I browsed my website using Firefox instead of IE 8. And there it was - - the results I was expecting.
So what is it in IE that is preventing me from seeing the popup results? I disabled the pop-up blocker in IE and that didn't work. I added my website to the allowed website in the pop-up blocker settings and that didn't work either. My guess is it's something under Internet Options => Security => Custom Level but I don't know what (yes, I have Active Scripting enabled).
View 2 Replies
Jul 8, 2010
My AJAX autocomplete control is not working. I have tried everything I can think of.
[Code]....
View 11 Replies
Jul 8, 2010
I 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.
View 10 Replies
Apr 26, 2010
I'm going on my 3rd day trying to get my Ajax AutoComplete textbox to call my web method. Based on my google searches, I'm not alone. I suspect the problem has something to do with the ServicePath property on the extender, although I'm not sure. My web service is at the same level, on the same server as my test web page. I'm not sure exactly what should go into the ServicePath property, although I think I've tried every possibility. Below is my web service followed by my script.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Configuration;
using System.Web;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using AjaxControlToolkit;
using System.Text;
using System.Xml;
using System.Xml.XPath;
using System.IO;
using System.Collections.Specialized;
using System.Web.Services.Protocols;
[WebService(Namespace = [URL])]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
[System.Web.Script.Services.ScriptService]
public class Service : System.Web.Services.WebService
{
public Service()
{
}
[System.Web.Services.WebMethod]
[System.Web.Script.Services.ScriptMethod]
public string[] AutoCompleteNames(string prefixText, int count)
{
System.Data.SqlClient.SqlConnection cxn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["HumanResourcesConnectionString"].ConnectionString);
cxn.Open();.....................
View 11 Replies
Jul 2, 2010
I'm having an error here : Please go through this and tell me what's the error.
Server Error in '/WebSite1' Application.
Could not load type 'System.Web.UI.ScriptReferenceBase' from assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.TypeLoadException: Could not load type 'System.Web.UI.ScriptReferenceBase' from assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.
Source Error:An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace: [TypeLoadException: Could not load type 'System.Web.UI.ScriptReferenceBase' from assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.]
AjaxControlToolkit.ToolkitScriptManager.OnResolveScriptReference(ScriptReferenceEventArgs e) in d:hgactServerAjaxControlToolkitToolkitScriptManagerToolkitScriptManager.cs:276
System.Web.UI.ScriptManager.RegisterScripts() +261
System.Web.UI.ScriptManager.OnPagePreRenderComplete(Object sender, EventArgs e) +117
System.Web.UI.Page.OnPreRenderComplete(EventArgs e) +2063008
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2247
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.14
33
View 1 Replies
Nov 25, 2010
I've set up a textbox with autocomplete, it works fine when i run is in visual studio, but when I deploy it to iis, the list items just do not appear.I think it has something to do with the fact that I'm using clean routes (with asp.net 4 routing).
The code:
[Code]....
View 1 Replies
May 6, 2010
Why my autocomplete ajax script does not work:
This is my WebService.cs
[Code]....
<cc1:AutoCompleteExtender ID="AutoCompleteExtender1" MinimumPrefixLength="1" ServiceMethod="GetCountryInfo" TargetControlID="TextBox2" ServicePath="WebService.asmx" runat="server"></cc1:AutoCompleteExtender>
Categories row in database is text type...
I use ModalPopup, too(my textbox2 is in Modalpopup), does it makes problem?
<cc1:AutoCompleteExtender ID="AutoCompleteExtender1" MinimumPrefixLength="1" ServiceMethod="GetCountryInfo" TargetControlID="TextBox2" ServicePath="WebService.asmx" runat="server"></cc1:AutoCompleteExtender>
View 7 Replies
Mar 26, 2010
I used the AjaxToolkit AutoComplete today. It works fine. But what I hate is that I have to use the "CompletionSetCount" at 5 or 6 only so it doesn't reach the following textbox on my form.
The problem is that the dropdownlist of the AutoComplexeExtender gets under my textboxes, so it hides some items of the list.
When I try to play with the z-order of the "CompletionListCssClass" or "CompletionListItemCssClass", then the list appearance is all messed up
View 1 Replies
May 20, 2010
I have the following situation in my page: I've created a textbox and then set an AutoCompleteExtender to this textbox and, later I wanted to set the focus to this field with the code behind i set textbox.focus(), when i'm trying to add focus the AutoCompleteExtender simply not working, but when i click outside the text box and click back in , it's working.
Can anybody give me a simple explanation how to solve this situation.
View 1 Replies
Dec 11, 2010
have a problem with my autocomplete control over a textbox here is the code in .aspx file
[Code]....
and the webservice1.asmx code
[Code]....
when i run the project in browser ant start typing nothing happens
View 6 Replies
Jun 16, 2010
I am using AutoComplete from ajaxtoolkit. where i am wrong even my page is running without errors
this is my Default.aspx code
[Code]....
and this is AutoComplete.cs files code in App_Code folder
[Code]....
and the webconfig is
[Code]....
page is running fine but wen i type any letter in this text box it is not showing other data related to this letter
View 4 Replies
Jan 11, 2011
I have one page with 3 FormViews + 3 Modal PopUp for them (AJAX toolkit). Works great but I have dependancy. If add a new record in one modal pop up it should be available in another one. I use autocomplete which does the work the problem and I have a hidden combo box where I get the ID for the insert.
Problem? The problem is that when I insert new record it doesn't update the asp combox box (not AJAX) so I cannot get the new id.
What would the easiest way to get ID without doing post backs. I want to avoid post back because the entry in text box might not be valid (partially typed) so I want to make sure it is typed in full so it I can get unique row = ID.
View 2 Replies
