http://www.dotnetcurry.com/ShowArticle.aspx?ID=515
http://stackoverflow.com/questions/2471166/jquery-autocomplete-jquery-ui-1-8rc3-with-asp-net-web-service
<script type="text/javascript"> $(function () { $("#BaoMingName").autocomplete({ source: function (request, response) { $.ajax({ url: "handler/WebService.asmx/GetData", data: "{'StuName':'" + request.term + "'}", dataType: "json", type: "POST", contentType: "application/json; charset=gbk2312", dataFilter: function (data) { return data; }, success: function (data) { response($.map(data.d, function (item) { return { value: item.StuName } })) }, error: function (XMLHttpRequest, textStatus, errorThrown) { alert(textStatus); } }); }, select: function (event, ui) { //alert(ui.item.value); $.ajax({ url: "handler/WebService.asmx/GetSingleStu", data: "{'StuName':'" + ui.item.value + "'}", dataType: "json", type: "POST", contentType: "application/json; charset=gbk2312", dataFilter: function (data) { return data; }, success: function (data) { // alert(data.d); var str = data.d; var json = eval(str); $.each(json, function (i) { alert(json[i].StuID); //$("#Test").html(json[i].StuID); }); ----------------------------------从后台活动的json取值------------------------------------------------- // var list = eval(data.d); // for (var i = 0; i < list.length; i++) { // $("#Test").html(list[i].StuName); // } }, error: function (XMLHttpRequest, textStatus, errorThrown) { alert(textStatus); } }); }, minLength: 1 }); }); </script>
DataTable转换为json
private string CreateJsonParameters(DataTable dt) { StringBuilder JsonString = new StringBuilder(); //Exception Handling if (dt != null && dt.Rows.Count > 0) { JsonString.Append("{ "); JsonString.Append("d:[ "); for (int i = 0; i < dt.Rows.Count; i++) { JsonString.Append("{ "); for (int j = 0; j < dt.Columns.Count; j++) { if (j < dt.Columns.Count - 1) { JsonString.Append(dt.Columns[j].ColumnName + ":" + "\"" + dt.Rows[i][j].ToString() + "\","); } else if (j == dt.Columns.Count - 1) { JsonString.Append(dt.Columns[j].ColumnName + ":" + "\"" + dt.Rows[i][j].ToString() + "\""); } } /**/ /*end Of String*/ if (i == dt.Rows.Count - 1) { JsonString.Append("} "); } else { JsonString.Append("}, "); } } JsonString.Append("]}"); return JsonString.ToString(); } else { return null; } }