Autocomplete Textbox that Searches from a DataBase

Hi Guys,

I cant understand why my textbox is doing nothing. I want a TextBox that would search a database and give suggestions based on what the user types on every keystroke. After doing some research, i realized that you had to use webservice and so that is what i did.
Here is the simple form with a textbox,scriptmanager and an Autocomplete extender

Expand|Select|Wrap|Line Numbers

 
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
 
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>Untitled Page</title>

</head>

<body>

    <form id="form1" runat="server">

        <asp:ScriptManager ID="ScriptManager1" runat="server">

        <Services>

        <asp:ServiceReference Path="AutoCompleteTest.asmx" />

        </Services>

        </asp:ScriptManager>

        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><div>

            <cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" MinimumPrefixLength="1" ServiceMethod="GetCentreNumbers" ServicePath="~\AutoCompleteTest.asmx" TargetControlID="TextBox1">

            </cc1:AutoCompleteExtender>

        </div>

    </form>

</body>

</html>

And here is the webservice

Expand|Select|Wrap|Line Numbers

 
<%@ WebService Language="C#" Class="AutoCompleteTest" %>
 
using System;

using System.Web;

using System.Web.Services;

using System.Web.Services.Protocols;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;
 
[System.Web.Script.Services.ScriptService()]

[WebService(Namespace = "http://tempuri.org/")]

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

public class AutoCompleteTest  : System.Web.Services.WebService {

    [System.Web.Script.Services.ScriptMethod]

    [WebMethod]

    public string[] GetCentreNumbers(string PrefixText)

    {

         string sql = "Select * from Centre Where centreNo like @PrefixText";

         SqlDataAdapter da = new SqlDataAdapter(sql,ConfigurationManager.ConnectionStrings["DBConnect"].ToString());

         da.SelectCommand.Parameters.Add("@PrefixText", SqlDbType.VarChar, 50).Value = PrefixText+ "%";

         DataTable dt = new DataTable();

         da.Fill(dt);

         string[] items = new string[dt.Rows.Count];

         int i = 0;

         foreach (DataRow dr in dt.Rows)

         {

              items.SetValue(dr["centreNo"].ToString(),i);

              i++;

         }

         return items;

    }
 
}

I know the webservice by itself is working becuse i set that as the start page and run the program and invoked the webservice and it gave me the correct answers

Somehow I dont know how the form is calling the webservice because nothing seems to be happening

Can someone please help me?

Apr 5 '08 #1

Subscribe Post Reply

5801

dip_developer

648

Expert 512MB

Hi Guys,

I cant understand why my textbox is doing nothing. I want a TextBox that would search a database and give suggestions based on what the user types on every keystroke. After doing some research, i realized that you had to use webservice and so that is what i did.
Here is the simple form with a textbox,scriptmanager and an Autocomplete extender

Expand|Select|Wrap|Line Numbers

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title>Untitled Page</title>

</head>

<body>

<form id="form1" runat="server">

<asp:ScriptManager ID="ScriptManager1" runat="server">

<Services>

<asp:ServiceReference Path="AutoCompleteTest.asmx" />

</Services>

</asp:ScriptManager>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><div>

<cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" MinimumPrefixLength="1" ServiceMethod="GetCentreNumbers" ServicePath="~\AutoCompleteTest.asmx" TargetControlID="TextBox1">

</cc1:AutoCompleteExtender>

</div>

</form>

</body>

</html>

And here is the webservice

Expand|Select|Wrap|Line Numbers

<%@ WebService Language="C#" Class="AutoCompleteTest" %>

using System;

using System.Web;

using System.Web.Services;

using System.Web.Services.Protocols;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

[System.Web.Script.Services.ScriptService()]

[WebService(Namespace = "http://tempuri.org/")]

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

public class AutoCompleteTest : System.Web.Services.WebService {

[System.Web.Script.Services.ScriptMethod]

[WebMethod]

public string[] GetCentreNumbers(string PrefixText)

{

string sql = "Select * from Centre Where centreNo like @PrefixText";

SqlDataAdapter da = new SqlDataAdapter(sql,ConfigurationManager.ConnectionStrings["DBConnect"].ToString());

da.SelectCommand.Parameters.Add("@PrefixText", SqlDbType.VarChar, 50).Value = PrefixText+ "%";

DataTable dt = new DataTable();

da.Fill(dt);

string[] items = new string[dt.Rows.Count];

int i = 0;

foreach (DataRow dr in dt.Rows)

{

items.SetValue(dr["centreNo"].ToString(),i);

i++;

}

return items;

}

}

I know the webservice by itself is working becuse i set that as the start page and run the program and invoked the webservice and it gave me the correct answers

Somehow I dont know how the form is calling the webservice because nothing seems to be happening

Can someone please help me?

I dont know about AutoCompleteExtender.......

In TextBox1_TextChanged event call the webservice method like
GetCentreNumbers(TextBox1.Text.Trim());.....what happens??

Apr 7 '08 #2

Similar topics

autocomplete textbox like google

by: nil | last post by:

Hello all, It's urgent... i want to add autocomplete textbox facility in my application like google. as you type it suggests option to the user..i want the same kind of facility...i know i...

ASP.NET

how to get the integer values from textbox to database

by: shek124 | last post by:

i have a text box on my form. i want to insert the value from the textbox to database.. im the beginner of vb.net .. plz help me .. thanks in advance..

.NET Framework

autocomplete textbox hangs after first char has been typed in

by: farahnaz | last post by:

Hi, I really don't know where else to look. I am working on an ajax application and got it working up to a point by referring to numerous websites and learning javascript as I went along. I use a...

Javascript

problem with updating text from textbox in database

by: Eric | last post by:

Hi, There is a textbox which contains some text. The purpose is to update the text manually into the textbox and send (update) the updated text to the database. My problem is that when i...

ASP.NET

Enter Problem in Autocomplete Textbox

by: jagwinderwalia | last post by:

Hi all i have build a autocomplete textbox control that works on keyup event in javascript. everytime a keyup is called , a request is send back to server and the suggestion are displayed in div...

Javascript

fetching data into a textbox from database

by: apoorva varma | last post by:

I want to fetch data into a textbox from database.plz tell me the coding in c#

C# / C Sharp

Autocomplete Textbox

by: Sirajuddin | last post by:

Hi, With great hope im writing this email. I wish and hope someone can help me. Im trying to get code for Autocomplete Textbox. I mean im looking for textbox which will autocomplete textbox...

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General