Results 1 to 13 of 13

Thread: [RESOLVED] autocomplete not working

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2006
    Location
    India
    Posts
    310

    autocomplete not working

    Hi,

    I don't know what mistake i am doing... script manager in master page...

    ---------------------
    Code:
    //aspx Page--------------
    <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
    <%@ MasterType TypeName="DOM_MasterPage" %>
    
    <asp:TextBox ID="txtservicecode" runat="server"></asp:TextBox>
                        <cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server"                                                                                 
                                            ServicePath="~/App_Code/bills.cs"
                                            ServiceMethod="GetServiceCode" 
                                            TargetControlID="txtservicecode" 
                                            MinimumPrefixLength="1" >
                                         </cc1:AutoCompleteExtender>
    //webservice CS-------------------------
    [WebMethod]
        [System.Web.Script.Services.ScriptMethod]
        public List<string> GetServiceCode(string prefixText, int count)
        {
            SqlConnection connection = null;
            try
            {
                connection = GetConnection();
            }
            catch (Exception e)
            {
                throw new Exception(e.InnerException.Message, e.InnerException);
            }
            try
            {
    
                DataSet objds = new DataSet();
                string sql = "select name from claims_service_code where active_yn = 'Y' and name like '%" + prefixText+"'";
                objds = DataFactory.ExecuteDataset(connection, CommandType.Text, sql);
                List<string> cntcount = new List<string>(objds.Tables[0].Rows.Count);
                if (count == 0)
                {
                    count = 10;
                }
                foreach (DataRow objdr in objds.Tables[0].Rows)
                {
                    string servicecode = objdr[0].ToString();
                    cntcount.Add(servicecode);
                }
                return cntcount;
            }
            catch (Exception ex)
            {
                throw ex;
            }
    
        }
    -------------------------------------------------
    Last edited by sagarpassion; Jan 22nd, 2013 at 08:37 AM.
    Sagar
    VB6, VB.net,C#,ASP, ASP.net MSSQL, MYSQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width