Search Engine

Question

Sir/Madam,

How to develop text based search engine project with ASP.NET.This is my first project with search engines.so,please guide me to start this project and send some links to get clear view.

Thanks in advance!!!

With Regards,
Gomathi.P

Gomathi Palaniswamy · Answer

Hi friend, do you have any samples in asp.net. With Regards, Gomathi.P

chaithanya chowdary · Answer

alter table T_FILES add constraint un_t_filedata unique ( file_sysid ) EXEC sp_fulltext_database 'enable' --1 Create the catalog (unless you already have) EXEC sp_fulltext_catalog 'FTCatalog' , 'create' --2 Add a full text index to a table EXEC sp_fulltext_table 'T_FILES' , 'create' , 'FTCatalog' , 'un_t_filedata' --3 Add a column to the full text index EXEC sp_fulltext_column 'T_FILES' , 'FILE_DATA' , 'add' EXEC sp_fulltext_column 'T_FILES' , 'FILE_EXTENSION' , 'add' EXEC sp_fulltext_column 'T_FILES' , 'FILE_DATA' , 'ADD' , 2057 , 'FILE_EXTENSION' EXEC sp_fulltext_table 'T_FILES' , 'activate' --5 Start full population EXEC sp_fulltext_catalog 'FTCatalog' , 'start_full' --select document_type, path from sys.fulltext_document_types exec sp_fulltext_service 'load_os_resources' , 1 ; exec sp_fulltext_service 'verify_signature' , 0 ; after complete the above steps write sql query as select * from T_FILES WHERE FREETEXT ( FILE_DATA , 'Beware of duplicate' ) here T_FILES is table file_data,file_extension are table column names

Gomathi Palaniswamy · Answer

Hi friend, i could not get you.where you have posted? With Regards, Gomathi.P

chaithanya chowdary · Answer

Here I have posted the text based search engine in sql server 2005. The prerequisites are Sql server 2005 or later full edition.