Hi ShihabKhan,
Refer below example.
HTML
<script type="text/javascript" src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.10.0.min.js"></script>
<script type="text/javascript" src="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.9.2/jquery-ui.min.js"></script>
<link rel="Stylesheet" type="text/css" href="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.9.2/themes/blitzer/jquery-ui.css" />
<script type="text/javascript">
$(function () {
$("#txtSearch").autocomplete({
source: function (request, response) {
$.ajax({
url: 'Default.aspx/GetFruits',
data: "{ 'prefix': '" + request.term + "'}",
dataType: "json",
type: "POST",
contentType: "application/json; charset=utf-8",
success: function (data) {
if (data.d.length > 0) {
response($.map(data.d, function (item) {
return { label: item.Text, val: item.Value };
}))
} else {
response([{ label: 'No results found.', val: -1 }]);
}
}
});
},
select: function (e, u) {
if (u.item.val == -1) {
$(this).val("");
return false;
}
}
});
});
</script>
Enter search term:
<input type="text" id="txtSearch" />
C#
using System.Collections.Generic;
using System.Data.OleDb;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
[System.Web.Services.WebMethod]
[System.Web.Script.Services.ScriptMethod()]
public static List<ListItem> GetFruits(string prefix)
{
List<ListItem> fruits = new List<ListItem>();
string str = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\Fruit.accdb;Persist Security Info = False; ";
OleDbConnection con = new OleDbConnection(str);
OleDbCommand cmd = new OleDbCommand("SELECT FruitId,FruitName FROM Fruits WHERE FruitName LIKE '%' + @Fruit + '%'", con);
cmd.Parameters.AddWithValue("@Fruit", prefix);
con.Open();
OleDbDataReader odr = cmd.ExecuteReader();
while (odr.Read())
{
fruits.Add(new ListItem { Text = odr["FruitName"].ToString().Trim(), Value = odr["FruitId"].ToString().Trim() });
}
con.Close();
return fruits;
}
}
VB.Net
Imports System.Collections.Generic
Imports System.Data.OleDb
Partial Class Default
Inherits System.Web.UI.Page
<System.Web.Services.WebMethod()> _
<System.Web.Script.Services.ScriptMethod()> _
Public Shared Function GetFruits(ByVal prefix As String) As List(Of ListItem)
Dim fruits As List(Of ListItem) = New List(Of ListItem)()
Dim str As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Fruit.accdb;Persist Security Info = False; "
Dim con As OleDbConnection = New OleDbConnection(str)
Dim cmd As OleDbCommand = New OleDbCommand("SELECT FruitId,FruitName FROM Fruits WHERE FruitName LIKE '%' + @Fruit + '%'", con)
cmd.Parameters.AddWithValue("@Fruit", prefix)
con.Open()
Dim odr As OleDbDataReader = cmd.ExecuteReader()
While odr.Read()
fruits.Add(New ListItem With {.Text = odr("FruitName").ToString().Trim(), .Value = odr("FruitId").ToString().Trim()})
End While
con.Close()
Return fruits
End Function
End Class
Screenshot
