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 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'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 RepliesI have an input box for searching employee info (attached to a jquery autocomplete), and a box for employee number. The employee info queries multiple values (Lastname Firstname, Title, Clocknum) and returns them all as a string via the autocomplete. This is only if they dont know the clock number. The additional box is so they can search via clocknum as well.
Is there a way, to fire a method which populates a data control after clicking on or tabbing on the selected jquery autocomplete value?
in my webapplication, I'm using asp.net dropdownlists, that are filled with data (text & id) through ObjectDatasources.
I'd like to use the jquery autocomplete on the dropdownlists, but I fail to find any good example for it, unless examples that are using http handlers or webservices, which I'd like to avoid.
Just wondering if this auto complete for text box to be modify for dropdown list.
Sometime I need value in drop down not shown in text box.
Base on: [URL] .....
I want use auto complete TextBox and multi select drop down list. If multi select drop down list worked auto complete TextBox show result in top. If auto complete TextBox worked multi select drop down list not worked. It’s my result but not my requirement. I shared code below but not my requirement.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="dolgeForm.aspx.cs" Inherits="RProject.dolgeForm" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<link href="Scripts/jquery-ui.css" rel="stylesheet" type="text/css" />
[code]...
The problem is simple, it doesn't fire (show the dropdownlist)
Here's all my code related to it.
Inside my masterpage:
[Code]....
I've compared it to many exemples and all is fine
If I test the service directly, it work
I am looking at the book MVC in Action for how to do autocomplete on a textbox.The one variation is that I have to return a JSON object.
So my partial view looks like;
<%@ Control Language="C#" Inherits="System.Web.Mvc.ViewUserControl<SHP.WebUI.Models.HolidayRequestViewModel>" %>
i've learnt that you can create an auto-complete application using XML file, and XMLhttpRequest (JS, JS DOM).I was wondering if you can achieve the same thing using an .net application and some database info.Thinking about it, you might have to use AJAX to perform real-time auto-complete... But still, i dont know if it's possible that way.Aside of that, assuming that there is a .net solution, how professional site builders usually do that?
View 2 RepliesI'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 RepliesJQUERY autocomplete and asp.NET
View 2 RepliesI'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.
i sample code for how to use wcf with ajax autocomplete
View 3 RepliesHow do i set my asp text box to have an autocomplete function?
View 3 RepliesI need to implement an auto complete feature and found posting on the Web that text box will do the job using ajax extender. Do I need to create a new website ASP.NET Ajax-Enabled or can I use my current ASP application? Or is there a better way to approach this using some other methods? [URL]
View 7 Repliesam using Autocomplete Jquery from the following URL:[URL]I am making my project in MVC 3.0 (Razor)
In this I am displaying list of names from the database and its running fine.Now I want to show this whole list in the div according to my project requirement.
I have a dropdown in my CreateDocumentTemplate ciew <%=Html.DropDownList("Part", (SelectList)ViewData["Part"])%> which is populated from database. I want to this dropdown to be autocomplete. How can I acoomplish this?
View 1 RepliesI'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.
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]....
I am using ASP.NET AJAX Autocomplete to load the data. I am fetching data from a Dataset, which is store in Session. The table length is approx 1000 rows.I use DataView to and Table.Select ("Data Like '"+ inputvalue +"'") to filter data on each keystroke.I am wondering, what's the best and fastest way to store and fetch data for Autocomplete?
View 5 Replieshow to use autocomplete extender in asp.net
View 1 Replieswanted to know exactly where on the server are the textbox autocomplete entries stored . Also where does Visual Studio store them
View 3 RepliesI'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.
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.