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:

WCF / ASMX :: AutoComplete Extender Not Calling Web Service

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

AJAX :: Pass Two Parameter In Autocomplete Extender?

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

AJAX :: Pass Session Value As Parameter To AutoComplete Extender Control

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

AJAX :: AutoComplete Extender Using A Page Method?

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

AJAX :: Calling A Web Service From Extender

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

AJAX :: Using Autocomplete Extender To Return 'Value' And 'Text'?

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

AJAX :: Autocomplete / Can't Get It To Hit The Method In My Service With A Signature?

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

AJAX :: AutoComplete Extender / Want To Check Textbox Text?

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

AJAX :: AutoComplete Extender Web Service - Select Client Names From Sql Server Then Store Into Arraylist

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

AJAX :: AutoCompete Extender Calls Web Method (in Webservice) That Have Zero Parameter?

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

AJAX :: Creating Simple Autocomplete / Taking One Textbox Adding Autocomplete Extender?

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

Auto Complete Extender Not Calling The Webservice Method?

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

JQuery :: Autocomplete Call WCF Service Method

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

Web Forms :: How To Pass Parameter To C# Method Calling In Javascript

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

Calling .NET Web Service Function Via GET Method With JQuery

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

Calling Linq To SQL Method In Web Service With JQuery?

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

AJAX :: How To Use Autocomplete Extender In .net

Jan 14, 2011

how to use autocomplete extender in asp.net

View 1 Replies

AJAX :: AutoComplete Extender Seen Only After One Tab?

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

AJAX :: Autocomplete Extender Not Firing?

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

AJAX :: Similar To Autocomplete Extender?

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

AJAX :: Unable To Use AutoComplete Extender?

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

AJAX :: Implement Autocomplete Extender?

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

AJAX :: Autocomplete Extender Position In IE?

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

AJAX :: Autocomplete Extender Not Working Iis 7?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved