jQuery AutoComplete: Get maximum 8 records in AutoComplete List in ASP.Net

Ref:jQuery UI AutoComplete TextBox with Database in ASP.Net

Change your query like this

C#

select Top 8 ContactName from Customers where " +
                "ContactName like @SearchText + '%'"

VB.Net

select Top 8 ContactName from Customers where " & _
                           "ContactName like @SearchText + '%'"