Jquery UI Autocomplete问题(高分求救)

Question

我用  jquery-ui-1.8.9 做AutoComplete. 但怎么从数据库取资料. 代码如下:
JS部份: $(function(){ 
            $("#InputMemberCard").autocomplete({
                  minLength:1,
                  source: "../Common/GCMSHandler.ashx?MemberNo=3"
              })
         });
后台处理程序代码: public void ProcessRequest (HttpContext context) {        
        if( context.Request.QueryString["MemberNo"] != null)
        {
            context.Response.Clear();
            context.Response.Buffer = true;
            context.Response.ContentType = "text/plain";
            context.Response.Write("['123','456','789','456','123']");            
            context.Response.Flush();
            context.Response.Close();
            context.Response.End();            
        }
    }
 
可以Debug到ProcessRequest函数.但就是无法看到效果. 请高手帮忙.如有Demo更佳.谢谢

Answer 1

C#读取数据库很简单啊 网上到处都是SqlConnection connection = new SqlConnection(connectionString)
SqlCommand command = new SqlCommand(queryString, connection);
command.Connection.Open();
SqlDataReader dr = command.ExecuteReader();

Answer 2

context.Response.Write("[\"123\",\"456\"]");
这样试试 。  

Answer 3

现在不是读取资料的问题.现在的问题是:处理ProcessRequest 函数后. 在页面上取不到如下数据.
context.Response.Write("['123','456','789','456','123']");     

Answer 4

数据格式请看jquery-ui的文档，要求是什么

Answer 5

兄弟,就是因为不太懂.所以才请教. 有没有现存的Demo

Answer 6

 $("#txtbox").autocomplete({
    source: function (request, response) {
      $.ajax({
        type: "POST",
        url: "WebService.asmx/GetData",
        data: NUll,
        dataType: "json",
        contentType: "application/json; charset=utf-8",
        success: function (data) {
          response($.map(data.d, function (item) {
            return {
              label: item.abc,
              value: item.abc
   
            }
          }))
        },
        error: function (XMLHttpRequest, textStatus, errorThrown) {
          alert(textStatus);
        }
      });
    },
    minLength: 3,
    select: function (event, ui) {
     //select event
    }
  });