How can i implement live Search in asp.net project using C# ?
-
Please help me...... as soon as possible
-
Please help me...... as soon as possible
By term "Live Search", are you referring search in google/bing/yahoo i.e. out side of your project OR do you mean it by within a system ?
Regards
-
By term "Live Search", are you referring search in google/bing/yahoo i.e. out side of your project OR do you mean it by within a system ?
Regards
live search in my own project... thanks for Quick reply
-
live search in my own project... thanks for Quick reply
ok, let me assume that your project is related the shopping cart and you want to search on following criteria. 1. Product Name 2. Product Feature 3. Product SKU 4. Product Description 5. Product Price Range 6. On any other field specific to your project. You can do something like below 1. Create a page which accept the input from customer in appropriate control 2. Collect all that input and pass it to the database(I assume SQL) 3. Create a stored procedure(SP) in the SQL which accept all the above collected input and pass it to the SP 4. In SP, you can SELECT the necessary fields from the table(s) and in the WHERE condition apply the filtering based on the passed parameter collected from the customer 5. Below is the example with one parameter.
SELECT ProductId, ProductName, ProductDescription, ProductSKU, ProductPrice FROM Product WHERE ProductName LIKE '%@ProductName%'Here @ProductName is the search term collected from the customer. Hope it helps.Regards
-
ok, let me assume that your project is related the shopping cart and you want to search on following criteria. 1. Product Name 2. Product Feature 3. Product SKU 4. Product Description 5. Product Price Range 6. On any other field specific to your project. You can do something like below 1. Create a page which accept the input from customer in appropriate control 2. Collect all that input and pass it to the database(I assume SQL) 3. Create a stored procedure(SP) in the SQL which accept all the above collected input and pass it to the SP 4. In SP, you can SELECT the necessary fields from the table(s) and in the WHERE condition apply the filtering based on the passed parameter collected from the customer 5. Below is the example with one parameter.
SELECT ProductId, ProductName, ProductDescription, ProductSKU, ProductPrice FROM Product WHERE ProductName LIKE '%@ProductName%'Here @ProductName is the search term collected from the customer. Hope it helps.Regards
well ! you dont understand my question.First i clarify it... my project is online library, i want to give suggestions when user type text for search in textbox... As in google or yahoo website , suggestions have been given when we type text for search, this is called live search...
-
well ! you dont understand my question.First i clarify it... my project is online library, i want to give suggestions when user type text for search in textbox... As in google or yahoo website , suggestions have been given when we type text for search, this is called live search...
-
well ! you dont understand my question.First i clarify it... my project is online library, i want to give suggestions when user type text for search in textbox... As in google or yahoo website , suggestions have been given when we type text for search, this is called live search...
Why didn't you give this information in the first place, or when you were asked for clarification? That way, you wouldn't have wasted anyones time, and it's called autocomplete not live search.
Forgive your enemies - it messes with their heads
My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility
-
Why didn't you give this information in the first place, or when you were asked for clarification? That way, you wouldn't have wasted anyones time, and it's called autocomplete not live search.
Forgive your enemies - it messes with their heads
My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility
what i want to implement is called live search.... ok... but i have to search a lot for it... thanks to all for positive response...
-
what i want to implement is called live search.... ok... but i have to search a lot for it... thanks to all for positive response...
Shama Shahzadi wrote:
what i want to implement is called live search....
No, it isn't, as you have been told. If you want argue rather than listen that's up to you but it won't endear you to the people who are trying to help you and will limited the help you get in the future.
I know the language. I've read a book. - _Madmatt
-
Shama Shahzadi wrote:
what i want to implement is called live search....
No, it isn't, as you have been told. If you want argue rather than listen that's up to you but it won't endear you to the people who are trying to help you and will limited the help you get in the future.
I know the language. I've read a book. - _Madmatt
well thanks fo your kind information and comment... i will b carefull next time to argue... and thanks to all who help me and give precious time, i appreciate them... That's Aragon answer also helps to learn a new thing... My fault is that i dont know the exact question what i want to ask...