Search.
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: ASP.NET Discussion
Forum Description: Discussion and chat on ASP.NET related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16936
Printed Date: 29 March 2026 at 7:01pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Search.
Posted By: davidshq
Subject: Search.
Date Posted: 17 October 2005 at 11:05pm
I'm working on an ASP.NET 2.0 program. All my data is contained in a
SQL database. It nicely displays the results in a GridView, but now I
want to work on not only filtering those results but also sorting them.
Is anyone aware of any 2.0 code that exemplifies how best to do this.
It should be pretty easy to create code that searches, just add something to my stored procedures select statement like:
select * from Game where Title LIKE varSearchTerm or Description LIKE varSearchTerm
But what about doing AND/OR searching, e.g.:
User enters: "Tag Dodgeball" (quotation marks indicating both terms together are required"
User enters: Tag AND Dodgeball (AND indicates both terms are required somewhere)
User enters: Tag OR Dodgeball (OR indicates only one term is required).
David.
-------------
- http://www.davemackey.net/" rel="nofollow - Dave Mackey - Virtual Home.
|
Replies:
Posted By: Mart
Date Posted: 18 October 2005 at 2:37am
|
Boolean searches are a bit hard to write youself, you might want to look into http://openlucene.net/ - http://openlucene.net/
|
Posted By: davidshq
Date Posted: 18 October 2005 at 11:33pm
Thanks Mart. The one difficulty with OpenLucene is it appears to be
focused on indexing documents rather than database contents. I'll
investigate it further when I have a chance though.
David.
-------------
- http://www.davemackey.net/" rel="nofollow - Dave Mackey - Virtual Home.
|
|