Autocomplete

Question

i have a users list that i would like to be able to get all logged in users by search on autocomplete how can i do that?

Roei Bar · Answer

well i like Json, and a small library called JayRock. its using Json over RPC you basically need to create a handler file like this using System; using System.Web; using Jayrock.Json; using Jayrock.JsonRpc; using Jayrock.JsonRpc.Web; public class Lookup : JsonRpcHandler { public Collection Lookup(string q) { Collection Users = new Collection(); RequestClass myRequest = new RequestClass(); UserEmployee User = new UserEmployee(); DataRow dr = default(DataRow); DataTable dt = default(DataTable); dt = myRequest.GetUser(q); foreach (var dr in dt.Rows) { User.FullName = dr("FullName"); User.UserID = dr("UserID"); User.Job = dr("Job"); Users.Add(new UserEmployee(User)); } dt.Dispose(); return Users; } } public class UserEmployee { public string FullName; public string UserID; public string Job; public UserEmployee() { } public UserEmployee(UserEmployee User) { this.FullName = User.FullName; this.UserID = User.UserID; this.Job = User.Job; } } and a simple form on the head put the following .suggestionsBox { position: relative; left: 30px; margin: 10px 0px 0px 0px; width: 200px; background-color: #212427; -moz-border-radius: 7px; -webkit-border-radius: 7px; border: 2px solid #000; color: #fff; } .suggestionList { margin: 0px; padding: 0px; } .suggestionList li { margin: 0px 0px 3px 0px; padding: 3px; cursor: pointer; } .suggestionList li:hover { background-color: #659CD8; } function jQueryChannel() { this.rpc = function(call) { if (!call.callback) throw new Error('Synchronous calls not supported.'); $.ajax({ type: "POST", url: call.url, data: JSON.stringify(call.request), beforeSend: function(xhr) { xhr.setRequestHeader("X-JSON-RPC", call.request.method); }, success: function(s) { call.callback(JSON.eval(s)); } }); } } function suggest(inputString) { if(inputString.length > 3) { var lookup = new Lookup(); //Instantiates new Jayrock Proxy from *.ashx?proxy lookup.channel = new jQueryChannel(); // Overrides default Jayrock Proxy Channel lookup.Lookup(inputString, function(data) { //$('#test').html("Length: " + data.result.length + " Test" + dump(data.result)); var results = data.result; if (results.length > 0) { var html = ""; //html += " "; for(var i = 0; i html += " " + results[i].fullName + " (" + results[i].job + ") " + " " + results[i].userID + " "; } //html += " "; $('#autoSuggestionsList').html(html); $('#suggestions').show(); } }); } else { // Hide the suggestion box. $('#suggestions').hide(); } } // lookup function fill(value) { $("#ctl00_ContentPlaceHolder1_txtUserID").val(value); setTimeout("$('#suggestions').hide();", 200); } on the body UserID: and In your code behind (*.aspx.cs) add to the Page_Load function: txtUserID.Attributes.Add("onkeyup", "suggest(this.value);") txtUserID.Attributes.Add("onblur", "fill();") thats it :-)

Kirtan Patel · Answer

In Which Technology you want this Solution Windows Form or ASp.net ?

Autocomplete

Answers (2)