Ajax Auto Complete Extender for social networking website using ajax
- Ajax Auto complete extender is a part of ajax tool kit and it is used to show suggestions
so that any user does not have to type the complete sentence or word.
- In our Social
Networking project HeartBeat we have Autocomplete extender to show friend name suggestions
when user types any name.
- To Accomplish this task we have made use of web service
with a function in it which will return the result with real time effect.
WebService.cs C# Code:
- Open WebService.cs User Control Which You have created in AppCode Folder. In the
Source of WebService.cs file you can add the following piece of code given below.
- On Opening the Webservice you will find that there is a hello world function by
defualt it comes with every new webservice that is added.
- We have created a function named as SearchFriends which will receive text in string
format and return an array of string.Through this webservice we have made a database
connection and we are searching the name of the registered user using like operator.
- We are storing the retrived results in a datatable and after processing the datatable
using foreach loop we are returning an array of strings
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Web.Script.Services;
using System.Web.Configuration;
[ScriptService]
[WebService(Namespace = "http://tempuri.org/")]
//[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class WebService : System.Web.Services.WebService
{
public WebService()
{
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public string HelloWorld()
{
return "Hello World";
}
[WebMethod]
public string[] SearchFriends(string prefixText)
{
string connstring = Database.connString.ToString();
string sql = "Select * from Register Where Name like @prefixText";
SqlDataAdapter da = new SqlDataAdapter(sql, connstring);
da.SelectCommand.Parameters.Add("@prefixText", SqlDbType.VarChar, 50).Value = prefixText + "%";
DataTable dt = new DataTable();
da.Fill(dt);
string[] items = new string[dt.Rows.Count];
int i = 0;
foreach (DataRow dr in dt.Rows)
{
items.SetValue(dr["Name"].ToString(), i);
i++;
}
return items;
}
}
Wow..................
ReplyDelete