I'm trying to use autocomplete with LDAP and return 2 values.
I'm typing in textbox Can and returns result as it should, but I would like to get one more value so it looks something like this
Typing in textbox Can and result
Cann (210)
Cannot (211)
I have an autocomplete extender working great returning one column and I can also retrieve multiple columns just fine from my stored procedure, but here's what I really need to do:
1. Format the data in the autocomplete extender in the following format:
Location Number
Address
City, State, Zip
2. When the user makes a selection I want only the Location Number to populate the textbox.
I've looked quite a bit on this site and others on how to do #2 and I can't seem to find exactly how this should be done. Is there some javascript that needs to be involved in order accomplish this?
the process to get multiple word suggesions for a text box in asp.net using Ajax? Actually I got a solution for that, [URL] But it used Atlas. When I am running with this code in my application, it is conflicting with Script Manager that is already there in Masterpage. How can I overcome that problem. Is there any built-in solution in latest versions of Ajax?
View 1 RepliesI have a form containing fields for a user to enter an address. The town/city field in the form uses an autocomplete extender to return a list of suggested towns/citys which are taken from an sql query in my webservice. The table in the sql db that contains the addresses also has a column containing partial postcodes for those places.
What I would like to be able to do is have it so that when the user selects a town/city from the autocomplete list or types a town/city in the textbox, it triggers another query to get the postcode from the db and updates the postcode textbox without a full postback.Is there an easy way to achieve this? I know there's the OnTextChanged event for a textbox but this is server side isn't it so would only trigger on postback? Could you have two auto complete extenders and two webmethods where the value from method one updates textbox one and method two gets the value from method one and updates textbox two?
I'm using the Autocomplete extender, it works great however I need to be able to display multiple columns from my stored procedure as have in the example below. The user enters a location #, I need it to display the location number and the address formatted, but when the user selects the correct location, I ONLY want the location number to populate my textbox:
1234
Address
City, State Zip
I've had a real hard time trying to figure out how to do this,. Here's my stored procedure and CS code.
[Code]....
Here's my CS:
[Code]....
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
Can't seem to understand whats wrong, this is the code on the view page:
[Code]....
and this is the code in the controller:
[Code]....
I'm working with MVC 3, the database is SQL. I printed out the result.Take(10).ToList(), and it's not empty or anything like that.anyone has an idea why I get the "Error" alert when I type in text to the input?
How do I handle selection of multiple items with autocomplete? The objects I return from my JSON web service contain an ID and a Label - the ID is the ID of the entity in the database, and the Label is some text to display for the user.
At the moment, when I select an item in the autocomplete dropdown, the value of the item's ID is stored in a hidden field, and the label is displayed. When I remove the label, I clear the ID of the hidden field - this is done by adding an anchor element to the DOM that handles this.
Now, I want to have multiple selections. I want to be able to enter some text, get an autocomplete dropdown, select an item and some other options, then be able to click an 'Add New' button or the likes to be able to select another instance.
For example, I'd type in a person's name and get an autocomplete selection. I'd select a person, and then enter their age, and click 'Add'. The person's id, name, and age will be stored somewhere so that I can retrieve it on the server side when I post back.
I'm not quite sure how to do it? I'm thinking of a hidden field - I assume that many hidden fields of the same name/id turn up on the server side as an array, which I can then use. But I haven't tried this yet in ASP.NET.
I'm trying to use the AutoComplete feature of JQuery to update multiple fields on an ASP.NET web page. The individual textbox is functioning perfectly, but I cannot figure out how to update multiple textboxes on the page once the user selects.
I've read many suggestions here that state I need to implement a result handler, but my intellisense is not showing that as an option, and IE I get a JS error saying that the object doesn't support this method.
I am linking to jquery-1.4.2.min.js and jquery-ui-1.8.5.custom.min.js .Here's my code:
$(function () {
$("#Street1").autocomplete({
source: function (request, response) {[code].....
I am working with a .net 2.0 asmx webservice (code below)I need to return 4 "items", which will be based on the success of failure of the webservice, and the actual XML imput itself.The Webservice needs to be asyncronous.I have included the code below, but am happy for someone to re-do it as it's been built up on tutorials and examples.At present, I don't believe the async is working, and the returns don't seem to be getting done.I have also built a test harness, and testing, which allows me to send some custom XML and then receive the response.
[Code]....
Harness:
[Code]....
I'm using asp.NET MVC, and am looking at the JQuery autocomplete plugin for what I want to do. I need some extra functionality that I don't think it provides.
I have a page with two text fields, First and Last name. Ideally, when someone begins typing into either, I would like autocomplete to display both the first and last name of all matches. If one of these matches were selected, I would like only the appropriate (first/last) name to go into the current field, while the other field is also filled in with the appropriate name.
So the problems here are that A) I would like the suggestion text to be different from the value that would be filled into the current field, and B) I would like to update multiple fields from a single autocomplete. Does this make sense? It seems to be difficult to find information on this situation on the net.
I have a table line (ID, LineNo, LineName) having values as :
1, 1, <blank>
2, 2, <blank>
3, 3, <blank>
ID is PK with Auto-Increment and LinNo(I am manually incrementing through ASP.Net Page while record insertion) Now i have to write a query such that it updates LineName column from line table which is blank(as shown above) with values from table linet(linenamet) having values as :
a
b
c
My trial query is :
update line set LineName = (select linenamet from linet);
It gives ERROR as : Subquery returns more than 1 row
Expected Result : After Updation it should show line table as :
1, 1, a
2, 2, b
3, 3, c
I would like to fill the textbox autocomplete stringcollection "on the fly" while typing. using with the Particular symbols Like @,#
Same as twitter "Compose new tweet" textbox
And the Data from the backend...
I have a store procedure that loops through items and returns multiple 1 row returns.The gridview will only show the first return, and no more because each return from the SP is labeled as row 1. Is there a way to change my SP or have gridview assign a new row number to the returns?My SP:
[Code]....
and my return:
[Code]....
I want to call .asmx service from jquery
.asmx service will return multiple data from database.
I need to get those data to jquery on client side
and then i need to put each data into their respective textfield on the client side
I found this usefull code in this website but i was wondering a way to select a multiple names in textbox inside GridView. I have seen one exampe on this website but the example is not in GridView. Here is my code that works fine now but it does not let me select multiple names:
<script type="text/javascript">
$(document).ready(function () {
Sys.WebForms.PageRequestManager.getInstance().add_endRequest(EndRequestHandler);
Sys.WebForms.PageRequestManager.getInstance().beginAsyncPostBack();
function EndRequestHandler(sender, args) {
$("[id*=txt_UID]").autocomplete({
[code]....
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 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 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 RepliesI'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 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'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]....
how to use autocomplete extender in asp.net
View 1 Replies