AutoCompelete Control Extender with With DB

Download Test_Project - 475.31 KB

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() ;
    }
}