 Print
 Add To Favorites
 Email To Friend
 Rate This Article
|
Creating AJAX Enabled Multi Keyword Database Search Engine
|
Published:
15 Jan 2008
|
Abstract
In this article an effort has been made to facilitate for developers, users, and practitioners an alternative option of developing and using a simple AJAX Enabled database search engine. The following pages provide a general understanding of the AJAX Enabled Multi Keyword database search engine, its usage, and the compatibility of its operation. |
 |
by Habiburahman Khaled
Feedback
|
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days):
5784/
277
|
|
|
|
| Introduction |
This article will show you how to develop a simple
multi-column, multi-keyword, and multi option search engine; it can be used for
any database driven application that requires search engine facility.
Figure 1
It is worth
mentioning that at the time I was writing this article I found Kelly Gafford
single column, multi-word database search sample
code at planetsourcecode written in Classic ASP very useful which gave me the
idea of how to go ahead.
|
|
|
|
|
Article Feedback
User Comments
Title:
Creating AJAX Enabled Multi Keyword Database Search Engine
Name:
Ramesh
Date:
5/9/2008 9:19:43 AM
Comment:
Nice article...but here is a need of AJAX....?
|
Title:
Re:Connect to remote database
Name:
H.Khalid
Date:
5/3/2008 12:23:15 AM
Comment:
Yes it does, but you will need to use OleDb classes inside of System.Data.OleDb namespace for data retrieval, and use Query instead of View.
Check out this link for connecting with Ms Access.
http://www.aspfree.com/c/a/Microsoft-Access/Connecting-to-a-Microsoft-Access-database-with-ASPNET/
thanks
|
Title:
Re:Connect to remote database
Name:
sathish
Date:
5/2/2008 11:43:42 PM
Comment:
does the coding working in ms-access is possible or not....
please tell....
|
Title:
Re:Connect to remote database
Name:
H.Khalid
Date:
4/14/2008 7:25:26 AM
Comment:
Well,Executing remote Stored Procedure, and Query requires some tricks. Check out this link for complete solution:
http://blog.sqlauthority.com/2007/10/06/sql-server-executing-remote-stored-procedure-calling-stored-procedure-on-linked-server/
|
Title:
Re:Connect to remote database
Name:
Mohammed Tajuddin
Date:
4/14/2008 6:27:30 AM
Comment:
Hi Habib,
Thanks for your response. I am actually trying to do it in my database ms sql 2005 in remote computer. Can i do the same in remote database? I use database management tools to access to my database. Data type are text, int, string and char. please give me your tips...
|
Title:
Re:Connect to remote database
Name:
H.Khalid
Date:
4/12/2008 4:46:18 AM
Comment:
Hi Tajuddin,
What Database System do you use?, the query I have provided should work fine.
If you are using SQL server right click on the Northwind Database then "New Query" then paste the code I have provided and click on the "Execute" Button in the toolbar.
thanks
|
Title:
Connect to remote database
Name:
Mohammed Tajuddin
Date:
4/9/2008 7:12:06 AM
Comment:
Hi Habibur, I like your article and was looking for this sort of things. I am really struggling to sort out my problem. How can i create the view in my database? if i run the query to create view getting error 'can not add text and char', how can i fix this problem? is there any other way to create view? your response much appreciated ...
|
Title:
Many thanks,
Name:
Wayne
Date:
4/8/2008 11:57:17 AM
Comment:
Hi again Habiburahman,
Many thanks for the added code - and for helping me no-end.
Kind regards,
W
|
Title:
Gridview is not populated
Name:
mia
Date:
3/30/2008 6:24:55 PM
Comment:
Ok...brian fart...i forgot to change the connection string
|
Title:
Gridview is not populated
Name:
mia
Date:
3/30/2008 6:19:07 PM
Comment:
Nothing happens when I run the code. I get the spinner.gif, but te GridView is not pupulated.
|
Title:
iis
Name:
mia
Date:
3/30/2008 5:49:59 PM
Comment:
do I need iis in orde rto run the app?
|
Title:
Re:AllowPaging
Name:
Habiburahman Khaled
Date:
3/3/2008 4:55:19 AM
Comment:
Thank you Wayne, I am glad that you liked the article.
For paging you will need to use DataSet classes since DataReader doesnt not support paging and filtering.
I have updated the sample in which paging is enabled you can download the new sample from the link bellow:
http://authors.aspalliance.com/KHabiburahman/SearchEngine%20.NET%203.zip
thanks
|
Title:
AllowPaging
Name:
Wayne
Date:
2/20/2008 8:58:42 AM
Comment:
Nice article - helped me get my head around a few things.
Any chance you could add some code to allow paging - tried the simple AllowPaging="True" but obviously this didn't work. Been looking for a way to do this but as a newbie am getting stuck!
|
Title:
SearchTextBox.Text.Length != 0)
Name:
protected void BtnSearch
Date:
2/6/2008 7:19:44 AM
Comment:
Threading.Thread.Sleep(1000);
string strCriteria = SearchCriteriaList.SelectedItem.Value;
doSearch(SearchTextBox.Text
|
Title:
is calling the
Name:
is calling
Date:
2/6/2008 7:18:26 AM
Comment:
calling the doSearch method from a button click event which takes values of a textbox named SearchTextBox
|
Title:
Great but
Name:
Radenko Zec
Date:
1/22/2008 1:50:50 PM
Comment:
This method is useful for small apps i think but for large web portals you must use Sql Server 2005 fulltextsearch .
Maybe it would be interesting to build implementation
fulltextsearch using Linq.
There isnt any article on using linq for fulltextsearch,and you cant use linq for fulltextsearch I think.
Maybe would be great to build some helper classes to do that.
|
|
|
|
|
|
