hello..
i have a webservice that retrieve username. i manage to call it to a autocomplete textbox using json but it doesn't accept certain letter, e.g : a,d,n,i. why is that?.. how to fix it?.. below are my codes :
webservice.asmx
[WebMethod]
public List GetStaffName(string name)
{
using (AseConnection persisConn = ClassConn.GetPersisConnection())
{
AseDataAdapter da = new AseDataAdapter();
persisConn.Open();
da.SelectCommand = new AseCommand("select name = ltrim(f786desc+' '+ f630nama) from t630staf, t786gelaran where f786kdgelar =* f630kdgelar and f630status != '9' AND f630nama like (LOWER('%@SearchName%')) union SELECT name = f620nama FROM t620sambilan where f620kdstatus <> '9' AND f620nama like (LOWER('%@SearchName%')) order by name", persisConn);
DataTable dt = new DataTable();
da.Fill(dt);
List staffs = new List();
for (int i = 0; i < dt.Rows.Count; i++)
{
staffs.Add(dt.Rows[i]["name"].ToString());
}
return staffs;
}
}
public List
{
using (AseConnection persisConn = ClassConn.GetPersisConnection())
{
AseDataAdapter da = new AseDataAdapter();
persisConn.Open();
da.SelectCommand = new AseCommand("select name = ltrim(f786desc+' '+ f630nama) from t630staf, t786gelaran where f786kdgelar =* f630kdgelar and f630status != '9' AND f630nama like (LOWER('%@SearchName%')) union SELECT name = f620nama FROM t620sambilan where f620kdstatus <> '9' AND f620nama like (LOWER('%@SearchName%')) order by name", persisConn);
DataTable dt = new DataTable();
da.Fill(dt);
List
for (int i = 0; i < dt.Rows.Count; i++)
{
staffs.Add(dt.Rows[i]["name"].ToString());
}
return staffs;
}
}
aspx code :