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 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 am using the autocomplete plugin but for some reason it is not getting to the controller when I start typing in the text box.
Has anyone used this? or worked with this? or got a working example? I've tried changing the url to /Referral/Get but still does not work
[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
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 RepliesJQUERY autocomplete and asp.NET
View 2 RepliesOn my page I have textbox in which user enters value. When 3 values are entered the autocomplete panel shows.In the panel the names and surnames of all available people are shown bassed on the value user enters. Bellow each name and surname is picture of each "candidate". However images are stored on another server (using https "protection") and some people don't have picture.
onerror="this.onerror=null;this.src='../Pics/Errors/NoPic.jpg'"
into <img> tags in Web Handler.
i have using jquery for autocompelete option and iam using ashx file, i have 2textbox, i need to show diffrent search record in the text box, iam using 2 ashx file to show the value using jquery, i want to user single ashx file instead of iam using 2 ashx handle filer can use switch case to handle this , i want to use 7textbox all textbox i need to do autosearch, how to handle this senario using jquery and ashx handler file
clsquery.updatetablestring = "select top 2 Cont_number from ASPrearrival_list where Cont_number";
clsquery.updatetablestring = "select top 2 custid,custname from ASCustomer where custname";
// this is my auto search iam using 2 handler file , i wants only one handler instead of 2handler
<script type="text/javascript" src="jquery.autocomplete.js"></script>
<script type="text/javascript">
$(document).ready(function()
{
$("#<%=txtcontno.ClientID%>").autocomplete("Handler1.ashx");
$("#<%=txtcname.ClientID%>").autocomplete("Handler.ashx");
}
);
handler ashx file
<%@ WebHandler Language="C#" %>
using System;
using System.Web;
using System.Data.SqlClient;
using ASbusinesslogic;
public class Handler : IHttpHandler {
public void ProcessRequest(HttpContext context)
{
string firstname = context.Request.QueryString["q"];
string sql = clsquery.updatetablestring;
sql = clsquery.updatetablestring+" "+"Like"+" '"+ firstname +"%'";
//string sql = "select top 2 mlid,mloname from ASlinermaster where mloname like '" + firstname + "%'";
using (SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].ToString()))
using (SqlCommand command = new SqlCommand(sql, connection)) { connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
context.Response.Write(reader.GetString(1)+ "-"+ reader.GetValue(0) + Environment.NewLine);
}
}
}
}
public bool IsReusable {
get {
return false;
}
}
}
handler1
<%@ WebHandler Language="C#" %>
using System;
using System.Web;
using System.Data.SqlClient;
using ASbusinesslogic;
public class Handler1 : IHttpHandler {
public void ProcessRequest(HttpContext context)
{
string firstname = context.Request.QueryString["q"];
string sql = clsquery.updatetablestring + " " + "like '" + firstname + "%' ";
using (SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].ToString()))
using (SqlCommand command = new SqlCommand(sql, connection))
{
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
context.Response.Write(reader.GetString(0) + Environment.NewLine);
}
}
}
}
public bool IsReusable {
get {
return false;
}
}
}
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 Repliesin 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.
I have a dropdownlist, filled with countries (from xml file).When you choose a country, you can use the autocomplete for a textbox.This autocomplete has postal codes from the choosen country.Now I want to set the autocomplete off right after the dropdownlist.change eventfor preventing that the autocomplete (filled with postal codes) for 1 country also work for another country. But how do you turn it off?Code:
//when changing country, other postcodes will load
$('[id$=landenDropDown]').change(function () {
//autocompletes removal
[code]...
I have this menu which has z-index of 600.I also use autocomplete, and I set the zIndex option to 700, I also tried setting the z-index in the css file, but no matter what i do, the ul list the autocomplete script generats always has z-index of 1.
this is what i see when i "inspect element" using chrome(the results ul):
[Code]....
no css alteration will help there, since its written into the style attribute of the ul element, and the zIndex option of autocomplete seems to do nothing also.for now, i can handle it by simply setting the z-index of the menu to 0, but thats a realy dirty workaround since i do want to control the z index of the autocomplete results ul.
How can I use jquery with wcf service. The following is the method for my wcf service.
[Code]....
I want similar functionality of asp.net ajaxAutocompleteExtender using the jquery. How can I achieve this using jquery?
I have this version of the autocomplete control working when returning XML from a .ashx handler. The xml looks like this:
<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<States>
<State>
<Code>CA</Code>
<Name>California</Name>
</State>
<State>
<Code>NC</Code>
<Name>North Carolina</Name>
</State>
<State>
<Code>SC</Code>
<Name>South Carolina</Name>
</State>
The autocomplete code looks like this:
$('.autocompleteTest').autocomplete(
{
source: function(request, response) {
var list = [];
$.ajax({
url: [URL]
dataType: "xml",
async: false,
data: request,
success: function(xmlResponse) {
list = $("State", xmlResponse).map(function() {
return {
value: $("Code", this).text(),
label: $("Name", this).text()
};
}).get();
}
});
response(list);
},
focus: function(event, ui) {
$('.autocompleteTest').val(ui.item.label);
return false;
},
select: function(event, ui) {
$('.autocompleteTest').val(ui.item.label);
$('.autocompleteValue').val(ui.item.value);
return false;
}
});
For various reasons, I'd rather be calling an ASP.NET web service, but I can't get it to work. To change over to the service (I'm doing a local service to keep it simple), the start of the autocomplete code is:
$('.autocompleteTest').autocomplete(
{
source: function(request, response) {
var list = [];
$.ajax({
url: "/Services/GeneralLookup.asmx/StateList",
dataType: "xml",
This code is on a page at the root of the site and the GeneralLookup.asmx is in a subfolder named Services. But a breakpoint in the web service never gets hit, and no autocomplete list is generated. In case it makes a difference, the XML that comes from the asmx is:
<?xml version="1.0" encoding="utf-8" ?>
<string xmlns=[URL]><State> <Code>CA</Code> <Name>California</Name> </State> <State> <Code>NC</Code> <Name>North Carolina</Name> </State> <State> <Code>SC</Code> <Name>South Carolina</Name> </State></string>
Functionally equivalent since I never use the name of the root node in the mapping code. I haven't seen anything in the jQuery docs about calling a .asmx service from this control, but a .ajax call is a .ajax call, right? I've tried various different paths to the .asmx (~/Services/), and I've even moved the service to be in the same path to eliminate these issues. No luck with either.
I have this code:
$('#' + textboxID).autocomplete({ delay: delay, source: ["cats", "dogs"] });
which works fine.
I want to use a webservice:
$('#' + textboxID).autocomplete({ delay: delay, source: webserviceURL});
This doesn't work. My webservice URL is /blah/blah.asmx/myMethod
The webservice definition is:
[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public List<string> myMethod(string term)
{
// Logic here, return list of strings
}
The method never gets called. Can anyone point me in the right direction? I have other webservices in the same .asmx which work fine with other controls (other controls are using $.ajax to call them).
Edit: Getting closer, I now get a 500 error saying Request format is unrecognized for URL unexpectedly ending in '/myMethod'. I think it's not treating my url quite right..
I have dropdown and textbox, I want to pass dropdown value as condition in generic handler through jquery autocomplete I am using generic handler for getting values from database.
View 2 RepliesIs there any JQuery autocomplete for Unicode character(Thai). I already with this and that my code for asp.net
protected void Page_Load(object sender, EventArgs e)
{
var q = Server.UrlEncode(Request.QueryString["q"]);
Response.Write(q);
}
The URL is [URL] like that. I got q="%e0%b8%93"; actually the correct value is ณ . So I don't know client side encoding is wrong or server side encoding is wrong?
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 am trying to implement autocomplete to a textbox using jquery. I am using MVC. I am trying to pass extra parameters but they are always null or jquery never add it to the query string.
View:
[Code]....
@Html.TextBox("tbxFilter")
Controller:
[Code]....
Does anybody used Telerik Controls and JQuery Autocomplete together. I'm facing a typical problem Uncaught TypeError: Object #<an Object> has no method 'autocomplete'
when I try to use it on pages. Telerik Script and Style are registered in master pages.
I´ve been trying to add jquery autocomplete in my website, i´m using asp.net 4 and linq to entities ....
I´ve searched a lot but couldn´t find an answer for this especific case.
I am trying to use the below code to call a wcf service method for Autocomplete functionality in a TextBox. I have written the following query:
$(document).ready(function () {
$("#<%= txtCompany.ClientID %>").autocomplete [URL], {
dataType: 'json',
parse: function (data) {
var items = data.d;
var parsed = [];
for (var i = 0; i < items.length; i++)
parsed[i] = {
data: [items[i]],
value: items[i],
result: [items[i]]
};
return parsed;
}
});
});
The same query works if I pass a Java Script array variable instead of the wcf service method. The wcf service method contract is:
[OperationContract]
[WebInvoke(Method = "GET", BodyStyle = WebMessageBodyStyle.WrappedRequest, ResponseFormat = WebMessageFormat.Json)]
string[] GetTestCompanyList(string prefixText, int count);
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].....
selecting a few items from a list of thousands. I have an autocomplete field that searches the db, and returns a name/id pair. This is working fine.
The next step is to preserve the selected IDs, and allow the user to remove some if needed. For this, I've been looking at using a select, and was hoping a UI something like that provided by this, but it doesn't work: it allows you to select items that already exist in the select, but doesn't work with a dynamically created select.
The final step is a traditional postback (using a submit button, this is in asp.net webforms) where I'll need to have access to the final list of IDs.
I am trying to populate an autocomplete with a LINQ query. The method I am calling returns data, but for some reason the autocomplete that appears on screen is empty. Here is my code.
[Code]....