AJAX :: Web Service Method With Parameter Isn't Calling With Autocomplete Text Box Extender
Feb 22, 2011
web service method(getMainHeads) with parameter is not calling with auto complete text box extender(same method with out parameter is calling fine). My Service is
[System.Web.Script.Services.
ScriptService]
public
class
InvService : System.Web.Services.WebService
{
ItemMainHeadMsts objItemMainHeadMsts;
DatabaseHelper objDataHelper;
[WebMethod]
public
string[] GetMainHeads(string value)
{
List<string>
oList = new
List<string
>();
objItemMainHeadMsts =
new
ItemMainHeadMsts
();
objDataHelper =
new
DatabaseHelper
();
objItemMainHeadMsts =
ItemMainHeadMstBase.SelectByFieldAuto("IMHDesc"
, value);
foreach (ItemMainHeadMst
mainHead in
objItemMainHeadMsts)
{
oList.Add(mainHead.IMHDesc);
}
return
oList.ToArray();..........................
View 4 Replies
Similar Messages:
Mar 24, 2011
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>
View 14 Replies
Jun 15, 2010
i need to pass two parameter in a autocomplete extender.below is my code and here i pass one parameter for autocomplete extender in web service.
[Code]....
here i pass a parameter :prefixtext.but in this query i need to pass one more parameter.i.e in that query one more condition i need like finanicial year. like where upper(reg_no) like @prefix and adm_fnyr=@fnyr.
so how can i pass and execute like this.i mean i need those reg_no which not in hreadmission table in same finanical year.
View 3 Replies
May 23, 2013
I followed below article [URL] .....
But I want to pass the value which i stored in my "int ID" Â instead of dropdown selected, I am getting this error "Newline in constant"
function SetContextKey()
{
$find('<%=AutoCompleteExtender1.ClientID>%').set_contextKey($get("<%=ID.ClientID %>").value);
}
View 1 Replies
May 17, 2010
i have developed a AutoComplete Search with the JAX AutoCompleteExtender Now i found a solution to use these control without a webservice (amsx) you only have the function in the codebehind (default.aspx.cs) , to do this you must let theServicePath empty. In the codebehind of your webpage is only the function which gets the data from the database.Important the function must be static !! Here is a good description: http://allwrong.wordpress.com/2007/03/13/ms-ajax-autocomplete-extender-using-a-page-method/
[Code]....
default.aspx.cs
[Code]....
Let´s come to my problem, i wanted to store these functionality in a webcontrol => AutoCompleteSearch.ascx
So i put the code from the default.aspx an .cs in the AutoCompleteSearch.ascx control. After i started the webapplication there was no functionality. So tried to let the
[Code]....
View 1 Replies
Apr 8, 2010
VS2008
Using C#
AJAX Toolkit 20229.20185
I have an AJAX auto complete extender that calls a web service to generate a string[] for a textbox. Works great, The issue I am having is that I set the OnClientItemSelected property of the auto complete extender to call a JavaScript function that will intern call another web service to get the remaining data I need based on the item that was selected. (I need this because the auto complete web service only allows for key/value pairs and I need to return 10 columns of data) I cannot get the JS function to call the web service. I keep getting "(Namespace) is undefined" as a JS error. I tried to impliment Microsoft's example located at: [URL] but even if I copy there code line for line in a new project, I still encounter the same error.
Samples.AspNet.WebService.Add(a, b,SucceededCallback); //'Samples' is undefined - runtime If I remove the namespace so that it reads: Add(a, b,SucceededCallback); //Endless loop until you get stack overflow error
Has anyone got MS C# example to work? I saw a lot of people had this line missing in the web service, but I already had it. [System.Web.Script.Services.ScriptService]
View 2 Replies
Dec 29, 2010
I have been trying AJAX TOOK KIT 3.5
Used the following web service method, to get the users names from ms sql db which is working fine.
But is there a way to get the Value of the selected item, which is the primary key.
[System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
public static string[] GetCompletionList(string prefixText, int count, string contextKey)
{
DataClassesDataContext db = new DataClassesDataContext();
return db.viwUsers.Where(n => n.FullName.Contains(prefixText)).OrderBy(n => n.FullName).Select(n => n.FullName).Take(count).ToArray();
}
View 2 Replies
Apr 9, 2010
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.
View 2 Replies
Oct 4, 2010
I have a textbox which takes data from autocomplete.
I want to check the textbox text and if the text wasn't taken from autocomplete extender, I want to clear the text.
View 2 Replies
Jul 26, 2010
I am not sure about writing the method in the web service. I'm trying to select the client names from sql server, then storing them into an arraylist. Finally, returning the array of names. This is my code:
[Code]....
My method has an error.
View 9 Replies
Jun 11, 2010
I have AutocompeteExtender control in my page.it calls web method (in webservice) that have no parameter I have two web methods in webservice Method 1Geist(string PreText, int Count){....}Method 2GetList(){.......}ethod 2 calls.I want to call method 1.
View 3 Replies
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
Apr 4, 2011
auto complete Extender not calling the webservice method the exact problem is ., Am using AutoComplet Extender in Example project its working fine. but the same code(aspx code as well as webservice code) am using in my live project its not calling the web service method. my live project is dotnet 2.0 version
[Code].....
View 1 Replies
Oct 20, 2010
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);
View 3 Replies
Feb 4, 2010
How to pass parameter to c# method calling in javascript.
My code is like this .
objTotalInclusive.value=TotalAmtInclu.toFixed(2);
objRoundOff.value= Math.round(TotalAmtInclu);
var wordsnum= objRoundOff.value;
var objwordstonum =document.getElementById('<%=lblNumSpelling.ClientID%>');
var objwords = '<%NumberToSpelling(''+ wordsnum+'')%>';
objwordstonum.value= objwords;
View 6 Replies
Apr 26, 2010
I'm trying to call web service function via GET method using jQuery, but having a problem. This is a web service code:
[WebService(Namespace = "http://something.com/samples")]
[ScriptService]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [Code]....
And I get an error because of this (error handler is called).
View 7 Replies
Jan 24, 2010
I have a test web service called: MySimpleService.svc with a method called:GetUserNamesByInitials. below is the Linq to SQL code:
[OperationContract]
public static string GetUserNamesByInitials(string initials)
{
string result = ""; [code]...
what I do is to type the user id in one textbox (TextBox3) and when I press the Tab key the result is shown in another textbox(TextBox4).
The jQuery call works well with other methods that do not call the database, for example using this other web service method it works:
[OperationContract] public string ParameterizedConnectionTest(string word)
{
return string.Format("You entered the word: {0}", word);
}
However with the Linq method it just does not work.
View 1 Replies
Jan 14, 2011
how to use autocomplete extender in asp.net
View 1 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
Aug 22, 2010
I have a ajax autocomplete extender and when I enter something to textbox nothing happened. Why is that?
Here is my codes.
[Code]....
HTML Side:
[Code]....
View 11 Replies
May 12, 2010
Iam getting an array of list from database to client side(javascript array).Now my aim to place those values in a div one by one and that div should attach to the textbox similar to Autocomplete extender.
View 4 Replies
Feb 11, 2011
Textbox is now woking as per the requirment:
HTML:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AutoComplete.aspx.cs" Inherits="AutoComplete" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>
<!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">
[Code]....
When I browse the web service in the browser, it is working fine but not working on aspx
View 1 Replies
Dec 20, 2010
how to implement autocomplete extender? i want to take datas from a particular table and store in autocomplete textbox.
View 5 Replies
Jul 7, 2010
I implemented autocomplete extender,functionality is working great but my issue is with CSS.It works as expected in Firefox(it applys all stylesheets perect) but in IE it is not behaving as expected it is showing the list about 10 pixels left to the text box.
googled couple of things but none of them were working for me.
My stylesheet:
.listItem
{
background-color: white;
padding: 1px;
}
.highlightedListItem
[Code]....
View 1 Replies
Apr 22, 2010
i have installed AjaxControlToolkit for framework 3.5 . my application is in virtual folder on the server which has Autocomplete Extender control, when i browse, control is not returning any list nor any error message. it is working fine in the localhost, is it because of the subfolder or any other reason i dont understand
View 2 Replies