Auto Suggestion box like google search box ........

mr coder

Hello guys .... I am developing an inventory system for a book store ..... here i wana make a search box for book searching which should be auto suggested like google..... How can i make it ,,,, Help me

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

vikash9y ago
[WebMethod]
//public static List GetAutoCompleteData(string Title,string Ticket,string Raised_By)
public static List GetAutoCompleteData(string Title)
{
List result = new List();
string conn = "";
conn = ConfigurationManager.ConnectionStrings["Conn"].ToString();
SqlConnection objconn = new SqlConnection(conn);
String commandString = "SELECT top (10) Title FROM [Master] WHERE [Title] LIKE '%" + Title + "%'";
// String commandString = "SELECT DISTINCT Title FROM [Master] WHERE [Title] LIKE '%" + Title + "%'";
//String commandString1 = "SELECT DISTINCT Ticket FROM [Master] WHERE [Ticket] LIKE '%" + Ticket + "%'";
// String commandString = "SELECT top (10) Title ,Ticket , Raised_By FROM [Master] WHERE [Title] LIKE '%" + Title + "%' OR [Ticket] LIKE '%" + Ticket + "%' OR [Raised_By] LIKE '%" + Raised_By + "%'";
SqlCommand cmd = new SqlCommand(commandString, objconn);
objconn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
result.Add(dr["Title"].ToString());
// result.Add(dr["Ticket"].ToString());
// result.Add(dr["Raised_By"].ToString());
}
//}
return result;

Try it
0
Ahmar Husain13y ago
Are you guys serious ? Jquery has nothing to do with java or .NET at all . Jquery is a client side scripting language that runs on browser you need to download the latest Jquery library, include it into your project drag drop it in the header of Aspx page that's it.write your Jquery code ,plugin etc then.if you are talking about WINDOWS FORM APPLICATION then it is much easier to implement AutoComple into it just use a simple textbox hit your database on every textchange event put autocomplete mode on for the textbox ,use AutocompleteString Collection like this:-
```
AutoCompleteStringCollection AutoItem = new AutoCompleteStringCollection();
AutoItem.add("C#");
AutoItem.add("ASP.NET");
```
```
texbox.AutoCompleteMode = AutoCompleteMode.Suggest; texbox.AutoCompleteSource = AutoCompleteSource.CustomSource; texbox.AutoCompleteCustomSource = AutoItem;
```
0
mr coder13y ago
I am doing this project in c#.NET.. by using SQL data base...... So, JQuery is Java Script library ... What to do now??
0
mr coder13y ago
Dear How can i use Jquery in c#.NET. I think JQuery is some thing related to java ???
0
mr coder13y ago
How to use jquery for c#.NET??
0
Sahil Maheshwary13y ago
Hi,

I already did the same thing.
What we do is:
We wrote one ajax call in which we send the entered letter in json format.
We wrote one service which hit that service and send us data in json format.
we map that data in combo box.

Please let me know if you want anything else
0
Ahmar Husain13y ago
you must have a database that stores the information of books like its title , author name etc. see the suggestion box is nothing but an Auto Complete UI component. i suggest you to use Jquery UI libraray to implement autocomplete or better say your suggestion box, AJAX call your database bind the values to the autocomplete control and you are done.

Good Luck
0
praveen kumar13y ago
hi use the below link
http://loopj.com/jquery-tokeninput/
0