復制代碼 代碼如下:

[OperationContract]
public string getSortList()
{
List<string> sorts = new List<string>();
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["zhui.pc"].ConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand("select [LastName] from [dbo].[Employees]", cn);
DataTable dt = new DataTable();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}

foreach (DataRow row in dt.Rows)
{
sorts.Add(row[0].ToString());
}

cn.Close();
}
return string.Join(",", sorts.ToArray());
}

復制代碼 代碼如下:

<script src="Scripts/jquery-1.7.1.min.js" type="text/javascript"></script>
<script src="Scripts/jquery.autocomplete.min.js" type="text/javascript"></script>
<link href="Styles/jquery.autocomplete.css" type="text/css" />

復制代碼 代碼如下:

<script type="text/javascript">
$().ready(function () {

NewsSort.getSortList(OnComplete, OnFailed, null);

function OnComplete(args, context) {
$('#MainContent_searchBox').AutoComplete({
'data': args.split(","),
'itemHeight': 20,
'listDirection': 'down',
'width': 280
}).AutoComplete('show');
}

function OnFailed(args) {
alert("出錯了！");
}
});
</script>