Hi All,
I created a function in a webservice to use database to give users suggestions as they type... The webservice and everythign used to work before I added the Database lookup code.
Can someone please look at this code and let me know what I am doing wrong? Here is the error message followed by the code:
Microsoft JScript runtime error: Sys.Net.WebServiceFailedException: The server method 'ItemLookupSuggestions' returned invalid data. The 'd' property is missing from the JSON wrapper.
public string[] ItemLookupSuggestions(string prefixText, int count)
{
List<string> responses = new List<string>();
try
{
SQL = "select ItemCode from Items where ItemCode like '" + prefixText.Trim() + "%' order by ItemCode";
HttpContext.Current.Response.Write(SQL);
MyDBConn = MyD ...
Go to the complete details ...