TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Paschal Obilor
1.6k
104
2.8k
AutoComplete Extender Doesn't Work...
Jun 14 2011 4:27 PM
I need help regarding a AutoComplete Extender that I am using. I Added an AutoComplete Extender on my ASP.NET application, then wrote the code for the webservice. It doesn't seem to work. The webservice works perfectly because I debugged it and got what I needed from it. But it doesn't display the suggested information when I type into the textbox. Can someone come to my aid....
Below is the code:
<%
<%
@
Page
Language
="C#"
AutoEventWireup
="true"
CodeBehind
="Test2.aspx.cs"
Inherits
="EVENTually.Test2"
%>
@
Register
Assembly
="AjaxControlToolkit"
Namespace
="AjaxControlToolkit"
TagPrefix
="asp"
%>
<!
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">
</
<
<
title
></
title
>
head
>
body
>
<
form
id
="form1"
runat
="server">
<
asp
:
ToolkitScriptManager
ID
="ToolkitScriptManager1"
runat
="server">
<
Services
>
<
asp
:
ServiceReference
Path
="~/AutoComplete.asmx"/>
</
Services
>
</
asp
:
ToolkitScriptManager
>
<
asp
:
TextBox
ID
="TextBox1"
runat
="server"></
asp
:
TextBox
>
<
asp
:
AutoCompleteExtender
ID
="AutoCompleteExtender1"
TargetControlID
="TextBox1"
ServicePath
="AutoComplete.asmx"
MinimumPrefixLength
="2"
CompletionInterval
="1000"
CompletionSetCount
="12"
EnableCaching
="true"
ServiceMethod
="GetDisplayName"
runat
="server"
>
</
asp
:
AutoCompleteExtender
>
</
</
</
form
>
body
>
html
>
--------------------------------------------------------------------------------------------------------
using
System;
using
System.Collections.Generic;
using
System.Linq;
using
System.Web;
using
System.Web.Services;
using
System.Web.Services.Protocols;
using
System.Data;
using
System.Data.OleDb;
using
System.Data.OracleClient;
using
System.Configuration;
using
EVENTuallyBL;
namespace
{
EVENTually
///
<summary>
///
Summary description for AutoComplete
///
</summary>
[
[
[System.ComponentModel.
WebService
(Namespace =
"http://tempuri.org/"
)]
WebServiceBinding
(ConformsTo =
WsiProfiles
.BasicProfile1_1)]
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
AutoComplete
: System.Web.Services.
WebService
{
[
{
WebMethod
]
public
string
[] GetDisplayName(
string
prefixdisplayname)
string
constr =
ConfigurationManager
.ConnectionStrings[
"EventuallyConn"
].ToString();
BusinessLayer
businesslayer =
new
BusinessLayer
();
DataSet
ds;
//if (count == 0)
//{
// count = 10;
//}
conn.Open();
cmd.CommandText =
cmd.CommandType =
cmd.Parameters.Add(
cmd.Parameters.Add(
ds =
da.Fill(ds);
ds = businesslayer.DisplayName(prefixdisplayname);
{
items.Add(ds.Tables[0].Rows[i][
}
}
}
}
OracleConnection
conn =
new
OracleConnection
(constr);
OracleCommand
cmd = conn.CreateCommand();
"SP_GetDisplaynames"
;
CommandType
.StoredProcedure;
"s_displayname"
,
OracleType
.VarChar).Value = prefixdisplayname +
"%"
;
"s_getdisplayname"
,
OracleType
.Cursor).Direction =
ParameterDirection
.Output;
OracleDataAdapter
da =
new
OracleDataAdapter
(cmd);
new
DataSet
();
int
cnt = ds.Tables[0].Rows.Count;
List
<
string
> items =
new
List
<
string
>();
for
(
int
i = 0; i < ds.Tables[0].Rows.Count; i++)
"Display_Name"
].ToString());
return
items.ToArray();
public
{
conn.Open();
cmd.CommandText =
cmd.CommandType =
cmd.Parameters.Add(
cmd.Parameters.Add(
ds =
da.Fill(ds);
}
DataSet
DisplayName(
string
displayname)
DataSet
ds;
OracleConnection
conn =
new
OracleConnection
(constr);
OracleCommand
cmd = conn.CreateCommand();
"SP_GetDisplaynames"
;
CommandType
.StoredProcedure;
"s_displayname"
,
OracleType
.VarChar).Value = displayname +
"%"
;
"s_getdisplayname"
,
OracleType
.Cursor).Direction =
ParameterDirection
.Output;
OracleDataAdapter
da =
new
OracleDataAdapter
(cmd);
new
DataSet
();
return
ds;
Reply
Answers (
2
)
Can't populate listbox
How to start the session when user login to web application.