Hi Bhavesh23,
Check this example. Now please take its reference and correct your code.
Database
For this example I have used of Northwind database that you can download using the link given below.
Download Northwind Database
HTML
<form id="form1" runat="server">
<asp:TextBox ID="txtCountry" runat="server"></asp:TextBox>
<hr />
<asp:ListBox ID="lstCustomers" runat="server" Style="display: none;" Height="100px"></asp:ListBox>
</form>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript">
$(function () {
$('[id*=txtCountry]').on('keyup', function () {
$("[id*=lstCustomers]").hide();
if ($(this).val() != '') {
var country = $(this).val();
$.ajax({
type: "POST",
url: "Default.aspx/GetCustomers",
data: "{'country':'" + country + "'}",
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (r) {
var lstCustomers = $("[id*=lstCustomers]");
lstCustomers.empty();
$.each(r.d, function () {
lstCustomers.append($("<option></option>").val(this['Value']).html(this['Text']));
});
$("[id*=lstCustomers]").show();
}
});
}
});
});
</script>
Namespaces
C#
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web.Services;
VB.Net
Imports System.Configuration
Imports System.Data
Imports System.Data.SqlClient
Imports System.Web.Services
Code
C#
[WebMethod]
public static List<ListItem> GetCustomers(string country)
{
string query = "SELECT TOP 5 CustomerID,ContactName FROM Customers WHERE Country LIKE @SearchText + '%'";
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(query))
{
List<ListItem> items = new List<ListItem>();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@SearchText", country);
con.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
items.Add(new ListItem
{
Value = sdr["CustomerID"].ToString(),
Text = sdr["ContactName"].ToString()
});
}
}
con.Close();
return items;
}
}
}
VB.Net
<WebMethod>
Public Shared Function GetCustomers(ByVal country As String) As List(Of ListItem)
Dim query As String = "SELECT TOP 5 CustomerID,ContactName FROM Customers WHERE Country LIKE @SearchText + '%'"
Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Using con As SqlConnection = New SqlConnection(constr)
Using cmd As SqlCommand = New SqlCommand(query)
Dim items As List(Of ListItem) = New List(Of ListItem)()
cmd.CommandType = CommandType.Text
cmd.Connection = con
cmd.Parameters.AddWithValue("@SearchText", country)
con.Open()
Using sdr As SqlDataReader = cmd.ExecuteReader()
While sdr.Read()
items.Add(New ListItem With {
.Value = sdr("CustomerID").ToString(),
.Text = sdr("ContactName").ToString()
})
End While
End Using
con.Close()
Return items
End Using
End Using
End Function
Screenshot
