Hi EddieP,
Refer the below sample that full-fill your requirement.
HTML
<script src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.10.0.min.js" type="text/javascript"></script>
<script src="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.9.2/jquery-ui.min.js" type="text/javascript"></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 () {
$("[id$=txtSearch]").autocomplete({
source: function (request, response) {
$.ajax({
url: '<%=ResolveUrl("~/CS.aspx/GetCustomers") %>',
data: "{ 'prefix': '" + request.term + "'}",
dataType: "json",
type: "POST",
contentType: "application/json; charset=utf-8",
success: function (data) {
response($.map(data.d, function (item) {
return {
label: item.split('-')[0],
val: item.split('-')[1]
}
}))
},
error: function (response) {
alert(response.responseText);
},
failure: function (response) {
alert(response.responseText);
}
});
},
select: function (e, i) {
var selectedValue = i.item.label.trim();
$.ajax({
url: '<%=ResolveUrl("~/CS.aspx/GetLink") %>',
data: "{ 'selected': '" + selectedValue + "'}",
dataType: "json",
type: "POST",
contentType: "application/json; charset=utf-8",
success: function (data) {
document.location.href = data.d;
},
error: function (response) {
alert(response.responseText);
},
failure: function (response) {
alert(response.responseText);
}
});
},
minLength: 1
});
});
</script>
Enter search term:
<asp:TextBox ID="txtSearch" runat="server" />
Code
C#
[WebMethod]
public static string[] GetCustomers(string prefix)
{
List<string> customers = new List<string>();
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "select ContactName, CustomerId from Customers where ContactName like @SearchText + '%'";
cmd.Parameters.AddWithValue("@SearchText", prefix);
cmd.Connection = conn;
conn.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
customers.Add(string.Format("{0}-{1}", sdr["ContactName"], sdr["CustomerId"]));
}
}
conn.Close();
}
}
return customers.ToArray();
}
[WebMethod]
public static string GetLink(string selected)
{
// Get DataTable from database that contains url for respective name.
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id", typeof(int)), new DataColumn("Name"), new DataColumn("Url") });
dt.Rows.Add(1, "Maria", "http://www.aspsnippets.com/");
dt.Rows.Add(2, "Mudassar Khan", "http://www.aspforums.net/Threads");
dt.Rows.Add(3, "Maria Larsson", "http://www.jqueryfaqs.com/");
dt.Rows.Add(4, "Mario Pontes", "http://stackoverflow.com/");
DataRow[] dr = dt.Select("Name='" + selected + "'");
string url = "";
foreach (DataRow row in dr)
{
url = row["Url"].ToString();
}
return url;
}
VB.Net
<WebMethod> _
Public Shared Function GetCustomers(prefix As String) As String()
Dim customers As New List(Of String)()
Using conn As New SqlConnection()
conn.ConnectionString = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Using cmd As New SqlCommand()
cmd.CommandText = "select ContactName, CustomerId from Customers where ContactName like @SearchText + '%'"
cmd.Parameters.AddWithValue("@SearchText", prefix)
cmd.Connection = conn
conn.Open()
Using sdr As SqlDataReader = cmd.ExecuteReader()
While sdr.Read()
customers.Add(String.Format("{0}-{1}", sdr("ContactName"), sdr("CustomerId")))
End While
End Using
conn.Close()
End Using
End Using
Return customers.ToArray()
End Function
<WebMethod> _
Public Shared Function GetLink(selected As String) As String
' Get DataTable from database that contains url for respective name.
Dim dt As New DataTable()
dt.Columns.AddRange(New DataColumn(2) {New DataColumn("Id", GetType(Integer)), New DataColumn("Name"), New DataColumn("Url")})
dt.Rows.Add(1, "Maria", "http://www.aspsnippets.com/")
dt.Rows.Add(2, "Mudassar Khan", "http://www.aspforums.net/Threads")
dt.Rows.Add(3, "Maria Larsson", "http://www.jqueryfaqs.com/")
dt.Rows.Add(4, "Mario Pontes", "http://stackoverflow.com/")
Dim dr As DataRow() = dt.[Select]((Convert.ToString("Name='") & selected) + "'")
Dim url As String = ""
For Each row As DataRow In dr
url = row("Url").ToString()
Next
Return url
End Function
Screenshot
