近期用Jquery插件写的一个自动完成页面

    <link href="../../Scripts/jquery_plugins/jquery.autocomplete.css" mce_href="Scripts/jquery_plugins/jquery.autocomplete.css" rel="stylesheet"
        type="text/css" />  
    <mce:script src="../../Scripts/jquery-1.2.6.min.js" mce_src="Scripts/jquery-1.2.6.min.js" type="text/javascript"></mce:script>
    <mce:script src="../../Scripts/jquery_plugins/jquery.autocomplete.js" mce_src="Scripts/jquery_plugins/jquery.autocomplete.js" type="text/javascript"></mce:script>
    <mce:script type="text/javascript"><!--
        $(function() {
            $("#txtCode").autocomplete("PdProduceBlending.aspx", {
                selectFirst: true,
                scroll: true,
                scrollHeight: 100,
                extraParams: {
                    extra: function() { return '1' }
                },
                dataType: 'json',
                parse: function(data) {
                    var rows = new Array();
                    for (var i = 0; i < data.TABLE_NAME.length; i++) {
                        rows[i] = { data: data.TABLE_NAME[i], value: data.TABLE_NAME[i].MATERIALCODE, result: data.TABLE_NAME[i].MATERIALCODE };
                    }
                    return rows;
                },
                formatItem: function(row, i, n) {
                    return row.MATERIALCODE + ' - ' + row.MATERIALNAME;
                }
            });
            $("#txtCode").result(function(event, data, formatted) {
                $("#txtName").val(data.MATERIALNAME);
            });
            $("#txtName").autocomplete("PdProduceBlending.aspx", {
                selectFirst: true,
                scroll: true,
                scrollHeight: 100,
                extraParams: {
                    extra: function() { return '2' }
                },
                dataType: 'json',
                parse: function(data) {
                    var rows = new Array();
                    for (var i = 0; i < data.TABLE_NAME.length; i++) {
                        rows[i] = { data: data.TABLE_NAME[i], value: data.TABLE_NAME[i].MATERIALNAME, result: data.TABLE_NAME[i].MATERIALNAME };
                    }
                    return rows;
                },
                formatItem: function(row, i, n) {
                    return row.MATERIALCODE + ' - ' + row.MATERIALNAME;
                },
                formatResult: function(row) {
                    return row.MATERIALNAME;
                }
            });
            $("#txtName").result(function(event, data, formatted) {
                $("#txtCode").val(data.MATERIALCODE);
            });
        });
    
// --></mce:script>

服务器端

        protected void Page_Load(object sender, EventArgs e)
        {
            AutoComplete();
            if (!IsPostBack)
            {
                ResourceCode = "PB/PD/PdProduceBlending";
                CheckPermission(ResourceCode);
            }
        }
        /// <summary>
        /// Ajax文本框自动完成功能
        /// </summary>
        private void AutoComplete()
        {
            string key = Request.QueryString["q"];
            string extra = Request.QueryString["extra"];
            if (String.IsNullOrEmpty(extra))
                return;
            if (String.IsNullOrEmpty(key))
                return;
            
            var items = new StringBuilder();
            var pdp = BusinessFactory.CreatePdProduceBlending();
            var dt = pdp.QueryCodeName(key, extra);
            var json = DataTable2Json(dt);
            Response.Write(json);
            Response.Flush();
            Response.End();
        }
        private string DataTable2Json(DataTable dt)
        {
            StringBuilder jsonBuilder = new StringBuilder();
            jsonBuilder.Append("{");
            jsonBuilder.Append(dt.TableName);
            jsonBuilder.Append(":[");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                jsonBuilder.Append("{");
                for (int j = 0; j < dt.Columns.Count; j++)
                {
                    jsonBuilder.Append(dt.Columns[j].ColumnName);
                    jsonBuilder.Append(":'");
                    jsonBuilder.Append(dt.Rows[i][j].ToString());
                    jsonBuilder.Append("',");
                }
                jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
                jsonBuilder.Append("},");
            }
            jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
            jsonBuilder.Append("]");
            jsonBuilder.Append("}");
            return jsonBuilder.ToString();
        }