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 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 have a text box and ajax autocomplete control extender in my Master Page that it is not working at all. When I type some characters on the text box it doesn't trigger the autocomplete. I have a web service that contains the function code. I est my code on a single Web Page (No Master Page) and it works perfectly. Also, it works fine if I include the text box and the extender on the Content Page instead of on the Master Page. It is important to keep the text box in the Master Page for me. I am using Visual Studio 2008 and ASP 3.5. MASTER PAGE.
[Code]....
WEB SERVICE:
[Code]....
I want to display Textbox and its Id in AutoComplete.Lets say If i select Po in textbox i have to get 1!postbox in the auto complete.Here 1 is id of postbox text.
View 2 RepliesWhich is best one to autocomplete textbox whether ajax autocomplete or jquery autocomplete ....
View 1 RepliesApologies for posting the ten billionth jQuery autocomplete question...I'm having trouble with a jQuery UI autocomplete textbox.I'm unsure if I'm doing the right thing client-side to re-populate the autocomplete data source following keystrokes.The javascript in my aspx page is as follows:
$(function() {
$("#<%=txtAuthorityName.ClientID%>").autocomplete({
minLength: 2,
[code]...
My datasource returns up to 3 different values for each item: a contact name, a company name, and an email address
The problem is, this ends up returning the same company names multiple times in the returned list of suggestions
Is there a way to weed these duplicate items out using JQuery or is there another method I should use?
Here is my implementation
[Code]....
I am using jquery autocomplete textbox with generic handler,my problem is i have four master page,in that master page i just take
query like this....
<link href="../css/jquery.autocomplete.css" rel="stylesheet" type="text/css" />
<script src="../Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
<script src="../Scripts/jquery.autocomplete.js" type="text/javascript"></script>
<script type="text/javascript"> $(document).ready(function () {
$("#<%=this.txtAuthorName.ClientID%>").autocomplete('Search_CS.ashx');
}); </script>
Suppose at the time of page add when i select master page ex(Default.aspx page with master page )then jquery autocomlplete texxbox is working fine ,but not working in dynamic created .aspx page..one example
I display product in my default page when i select that product ,it will go to details page means (53-arts-photography-and-design.aspx productid , prodname and desc ) if u want code then i will send code.
How to find url when I am selected name in autocomplete textbox
show url--------- http://www.addhr.aspx?id=6
i am using JQuery UI Autocomplete with asp.net textbox.AutoComplete works right.but how can i assign selected ID of returned Data to an hiddenField?My server Side Function returned list of objects that contains (this is an example) :
public List<Employee> GetEmployeeList()
{
List<Employee> empList = new List<Employee>();
empList.Add(new Employee() { ID = 1, Email = "Mary@somemail.com" });
empList.Add(new Employee() { ID = 2, Email = "John@somemail.com" });
empList.Add(new Employee() { ID = 3, Email = "Amber@somemail.com" });
empList.Add(new Employee() { ID = 4, Email = "Kathy@somemail.com" });
empList.Add(new Employee() { ID = 5, Email = "Lena@somemail.com" });
empList.Add(new Employee() { ID = 6, Email = "Susanne@somemail.com" });
empList.Add(new Employee() { ID = 7, Email = "Johnjim@somemail.com" });
empList.Add(new Employee() { ID = 8, Email = "Jonay@somemail.com" });
empList.Add(new Employee() { ID = 9, Email = "Robert@somemail.com" });
empList.Add(new Employee() { ID = 10, Email = "Krishna@somemail.com" });
return empList;
}
and this is ASPX Code :
<form id="form1" runat="server">
<div class="demo">
<div class="ui-widget">
<label for="tbAuto">
Enter Email:
</label>
<asp:TextBox ID="tbAuto" class="tb" runat="server">
</asp:TextBox>
</div>
</div>
<asp:TextBox ID="TextBox1" runat="server">
</asp:TextBox>
<asp:Label runat="server" ID="lbl" Text=""></asp:Label>
<asp:HiddenField runat="server" ID="hidid" />
<asp:Button ID="Button1" runat="server" Text="Button" />
</form>
here is my jquery Code :
<script type="text/javascript">
$(function () {
$(".tb").autocomplete({
select: function( event, ui ) {
// now assign the id of the selected element into your hidden field
$("#<%= hidid.ClientID %>").val( ui.item.ID );
},
source: function (request, response) {
$.ajax({
url: "Default.aspx/FetchEmailList",
data: "{ 'mail': '" + request.term + "' }",
dataType: "json",
type: "POST",
contentType: "application/json; charset=utf-8",
dataFilter: function (data) { return data; },
success: function (data) {
response($.map(data.d, function (item) {
return {
value: item.Email
}
}
)
)
}
,
error: function (XMLHttpRequest, textStatus, errorThrown) {
alert(textStatus);
alert(errorThrown);
}
});
},
minLength: 1
});
});
</script>
And this is My WEb Method Side Code :
<WebMethod()> _
Public Shared Function FetchEmailList(ByVal mail As String) As List(Of Employee)
Dim emp = New Employee()
Dim fetchEmail = emp.GetEmployeeList()
Return fetchEmail
End Function
I am using autocomplete jquery textbox in gridview , for first time when grid view is binded autocomplete jquery textbox works , when new row is dynamically added with textbox, the code is not working
<script type="text/javascript">
$(document).ready(function() {
$("*[id$=Gridview1] input[id$=txtHead]").autocomplete('Search_CS.ashx');
});
</script>
[Code] .....
I am trying to use j-query autocomplete but i am getting this error: "The name 'txt_UID' does not exist in the current context" ..
I am using the code but the example I was following uses a text-box that was outside of the gridview. But my textbox is inside the gridview.
How can I make the autocomplete to work a text-box that is inside gridview?
-- Here is my javascript
<script type="text/javascript">
$(document).ready(function () {
$("#<%=txt_UID.ClientID %>").autocomplete({
source: function (request, response) {
[Code] .....
-- and here is my gridview:
<asp:GridView ID="GridView1" runat="server" Width="870px"
AutoGenerateColumns="False" Font-Names="Arial" Font-Size="11pt" AlternatingRowStyle-BackColor="#C2D69B"
HeaderStyle-BackColor="green" ShowFooter="True"
CellPadding="4" BackColor="White" BorderColor="#336666"
[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'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 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 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.
On my page I have four controls:
How to pass control's value to jQuery autocomplete
I built a modal dialog using the ModalPopupExtender from the AjaxControlToolkit. In that dialog, I'm trying to use the jQuery Autocomplete feature on a textbox. The values for the autocompletion are fetched from a webservice.I can see that the webservice is returning a result set, and I can see that being picked up in the Autocomplete code. However, the list is not displayed to the user to pick from.I thought this might be a z-Index issue, so I specified 'z-index: 9999 !important;' in my stylesheet. But that doesn't make a difference.
[Code]...
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();.....................
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]....
I am using AutoComplete ASP.NET AJAX Control toolkit AutoCompleteExtender control When I am using my web service as Service Path, its not working.my web services code below
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data.SqlClient;
using System.Data;
using System.Web.Script.Services;
namespace OnlineSalesGrid
{
/// <summary>
/// Summary description for sample
/// </summary>
[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 sample : System.Web.Services.WebService
{
[WebMethod]
public static string[] GetCompletionList(string prefixText, int count)
{
List<string> returnData = new List<string>();
SqlConnection con = new SqlConnection("Data Source=CARPATHIA\SQLEXPRESS;Initial Catalog=OnlinesaleGrid;Persist Security Info=True;User ID=sa;Password=c0rpusdata");
string sql = "select Customer_Name from Customer_Master where Customer_Name like '%" + prefixText + "%'";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read()) { returnData.Add(reader["Customer_Name"].ToString()); }
return returnData.ToArray();
}
[WebMethod]
public static string[] GetCompletionList1(string prefixText, int count)
{
List<string> returnData = new List<string>();
SqlConnection con = new SqlConnection("Data Source=CARPATHIA\SQLEXPRESS;Initial Catalog=OnlinesaleGrid;Persist Security Info=True;User ID=sa;Password=c0rpusdata");
string sql = "select Customer_Code,Customer_Name from Customer_Master where Customer_Code like '%" + prefixText + "%'";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
returnData.Add(reader["Customer_Code"].ToString());
}
return returnData.ToArray();
}
}
}
Html Code is
<asp:ScriptManager ID="toolscpt1" runat="server" >
<Services>
<asp:ServiceReference Path="~/sample.asmx" />
</Services>
</asp:ScriptManager>
<asp:TextBox
ID="txtcname" runat="server" CssClass="textbox" onBlur='funblurcolor(this.id)' onFocus='funfocuscolor(this.id)'
ontextchanged="txtcname_TextChanged1" onkeypress="javascript:if(window.event.keyCode == 13) document.getElementById('txtphno').focus" ></asp:TextBox>
<asp:AutoCompleteExtender ID="txtname_AutoCompleteExtender"
runat="server" Enabled="True" ServiceMethod ="GetCompletionList" ServicePath="~/sample.asmx"
MinimumPrefixLength="1" CompletionSetCount ="12" EnableCaching ="true" CompletionInterval ="500"
TargetControlID="txtcname" ></asp:AutoCompleteExtender>
I have a web control with a text box configured like this:
[Code]....
I am unable to get it to hit the method in my service with a signature like:
public
string[] GetOrganizationNames(string searchText,
int count)
but it does get to the method if I change the signature to:
public
string[] GetOrganizationNames()
For obvious reasons the second one will not do me any good. I have verified the data coming back from the method is good.
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>" %>
