how to make a search from database based on values returned by Autocomplete extender

Question

0.00/5 (No votes)

See more:

I' using ASP.net2.0 and SQL server2005.I have installed AJAX toolkit.

i want to make a search similar to google search ie retrieve from a database a list based on user typing characters and clicking search.

i have used a text box and AJAX autocomplete extender .i have made a connection to DB and able to make a list from a field. But when i select one list elment and click search button it doesn't go into the Search button on click event.Without using autocomplete i'm able retrieve records and display it on data grid view.Do i need to convert the list returned to an array.Plz help me

My aspx page is

XML

<%@ 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"  EnablePageMethods="true" runat="server" />
        <div>
            <cc1:AutoCompleteExtender ServiceMethod="SearchCD" MinimumPrefixLength="2"
    CompletionInterval="100" EnableCaching="false" CompletionSetCount="10"
    TargetControlID="txtSearch" ID="AutoCompleteExtender1" runat="server" FirstRowSelected="true">
            </cc1:AutoCompleteExtender>
            &nbsp;
            <asp:TextBox ID="txtSearch" runat="server" AutoPostBack="True"></asp:TextBox>
            <asp:GridView ID="dgv1" runat="server">
            </asp:GridView>
            <asp:Button ID="btnSearch" runat="server" Text="Search" /></div>
    </form>
</body>
</html
>

My .aspx.cs is

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Collections.Generic;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    [System.Web.Script.Services.ScriptMethod()]
    [System.Web.Services.WebMethod]
    public static List<string> SearchCD(string prefixText, int count)
    {
        

        
        string constring = ConfigurationManager.AppSettings.Get("con").ToString();
        SqlConnection conn = new SqlConnection(constring);


        SqlCommand cmd = new SqlCommand("select CD_NAME from CD_DETAILS where " + "CD_NAME like @SearchText + '%'", conn);


        cmd.Parameters.AddWithValue("@SearchText", prefixText);
        cmd.Connection = conn;
        conn.Open();
        List<string> cds = new List<string>();
        using (SqlDataReader sdr = cmd.ExecuteReader())
        {
            while (sdr.Read())
            {
                cds.Add(sdr["CD_NAME"].ToString());
            }
        }
        conn.Close();
        
        return cds;
    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {

        string constring = ConfigurationManager.AppSettings.Get("con").ToString();
        SqlConnection conn = new SqlConnection(constring);
        conn.Open();
        SqlCommand check = new SqlCommand("spSearch", conn);
        check.CommandType = CommandType.StoredProcedure;
        check.Parameters.Add(new SqlParameter("@searchKey", SqlDbType.NVarChar, 50));

        check.Parameters["@searchKey"].Value = txtSearch.Text;

        SqlDataAdapter da = new SqlDataAdapter(check);
        DataSet ds = new DataSet();
        da.Fill(ds);
        this.dgv1.DataSource = ds.Tables[0].DefaultView;

        dgv1.DataBind();

        conn.Close();

    }
   
}

Posted 5-Sep-10 9:02am

shanboy

Updated 5-Sep-10 9:55am

Not Active

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Not Active · Accepted Answer · 2010-09-05T10:00:00

Solution 1

The click event is not hooked up

C#

<asp:button id="btnSearch" runat="server" text="Search" xmlns:asp="#unknown" />

should be

C#

<asp:button id="btnSearch" runat="server" text="Search" onclick="btnSearch_Click" xmlns:asp="#unknown" />

Posted 5-Sep-10 10:00am

Not Active

Updated 5-Sep-10 10:05am

v2

Comments

shanboy 6-Sep-10 12:52pm

hi mark
Thanx for ur help
Sorry to make u go through full code for a silly problem
Thanx a lot
bye..

shanboy 6-Sep-10 12:53pm

sorry..silly mistake