Click here to Skip to main content
Click here to Skip to main content

AutoCompelete Control Extender with With DB

, 30 Mar 2008
Rate this:
Please Sign up or sign in to vote.
AutoCompelete Control Extender with With DB

Introduction

autoComplete Control Extender of AjaxToolKit with Database Interecation

Background

Background of this Article is using webservice for calling Database Hit

Using the code

A brief description of how to use the article or code. The class names, the methods and properties, any tricks or tips.

Blocks of code should be set as style "Formatted" like this:

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

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>
<html>
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server" />
        <table border="0" cellpadding="0" cellspacing="0" style="width: 80%" align="center">
            <tr>
                <td style="width: 100px">
                     
                </td>
                <td style="width: 100px">
                     
                </td>
                <td style="width: 100px">
                     
                </td>
            </tr>
            <tr>
                <td style="width: 100px">
                     
                </td>
                <td style="width: 100px">
                    <asp:TextBox runat="server" ID="myTextBox" Width="300" autocomplete="off" />
                    <ajaxToolkit:AutoCompleteExtender runat="server" ID="autoComplete1" TargetControlID="myTextBox"
                        ServicePath="AutoComplete.asmx" ServiceMethod="GetCompletionList" MinimumPrefixLength="1"
                        CompletionInterval="200" EnableCaching="true" CompletionSetCount="12" />
                </td>
                <td style="width: 100px">
                     
                </td>
            </tr>
            <tr>
                <td style="width: 100px">
                     
                </td>
                <td style="width: 100px">
                     
                </td>
                <td style="width: 100px">
                     
                </td>
            </tr>
        </table>
    </form>
</body>
</html>

<script type="text/javascript">
// Work around browser behavior of "auto-submitting" simple forms
var frm = document.getElementById("aspnetForm");
if (frm) {
           frm.onsubmit = function() { return false; };
      }
</script>

 
using System;
using System.Web;
using System.Collections;
using System.Collections.Generic;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Data.SqlClient;
using System.Configuration; 

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class AutoComplete : WebService
{
    string connectionString = string.Empty;
    DataTable dt = null;
    SqlCommand objCommnad = null;
    SqlDataAdapter da = null;
    SqlConnection con = null;
    public AutoComplete()
    {
    }

    [WebMethod]
    public string[] GetCompletionList(string prefixText, int count)
    {
        if (count == 0)
        {
            count = 10;
        }

        if (prefixText.Equals("xyz"))
        {
            return new string[0];
        }

        Random random = new Random();
        List<string> items = new List<string>(count);
        for (int i = 0; i < count; i++)
        {
            char c1 = (char)random.Next(65, 90);
            char c2 = (char)random.Next(97, 122);
            char c3 = (char)random.Next(97, 122);

            items.Add(prefixText + c1 + c2 + c3);
        }

        //return items.ToArray();

        return getCompany(prefixText); 

        /////////////////Rizwan Code Here \\\\\\\\\\\\\\\\\\\\\\\

    }
    private string[] getCompany(string CompanyNameLike)
    {
        connectionString = ConfigurationManager.AppSettings["ConStr1"].ToString();
        con = new SqlConnection(connectionString);
        try
        {
            con.Open();
            objCommnad = new SqlCommand();
            objCommnad.Connection = con;
            objCommnad.CommandType = CommandType.StoredProcedure;
            objCommnad.CommandText = "LU_Select_ProPerty";
            objCommnad.Parameters.Add("@CompanyName", SqlDbType.VarChar).Value = CompanyNameLike;
            da = new SqlDataAdapter(objCommnad);
            dt = new DataTable();
            da.Fill(dt);
            //return dt;
        }
        catch (Exception ex)
        {
            con.Close();
            throw ex;
        }
        finally
        {
            con.Close();
        }
        List<string> items = new List<string>(dt.Rows.Count);
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            items.Add(dt.Rows[i]["pro_name"].ToString());     
        }
        return items.ToArray() ;
    }
}


        

Remember to set the Language of your code snippet using the Language dropdown.

Use the "var" button to to wrap Variable or class names in &lt;code&gt; tags like this.

Points of Interest

Did you learn anything interesting/fun/annoying while writing the code? Did you do anything particularly clever or wild or zany?

History

Keep a running update of any changes or improvements you've made here.

License

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

About the Author

Mohammad Rizwan
Software Developer (Senior) Axact Pvt Ltd
Pakistan Pakistan
Sr Software Engineer
Axact Pvt Ltd
Karachi Pakistan

Comments and Discussions

 
GeneralThis control having prob with IE6 PinmemberSuresh gudiseva17-Oct-08 23:49 
If I have any list boxes right below of the autocomplete extender, this autocomplete extender going back to the list boxes can anyone help me on this

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web01 | 2.8.140721.1 | Last Updated 30 Mar 2008
Article Copyright 2008 by Mohammad Rizwan
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid