|
-
Feb 17th, 2011, 02:41 AM
#1
Thread Starter
Hyperactive Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|