File and Database Search

[Mark]

Hi

I have an application (in vb.NET 2005) which holds data in SQL Server and
some of the SQL records are simply paths to related files.

I would like to be able to do a text search on both the SQL data and the
contents of any referenced files. The returned list being a listing which
includes both records containing the text and files containing the text.

Does anyone have a simple example of programatically searching for files
containing text?

Thanks very much

Mark

 

[Guest]

Does anyone have a simple example of programatically searching for files
containing text?

Lucene.NET is a opensource search engine for .NET

or you could use a commericial one too.

Or there is Microsoft Index Server.

 

[Kodali Ranganadh]

Hi mark,

For the Case Of DataBase Search, U have a "Full Text Search" Engine,
supported by allmost all the database. Create a Serach index using the
FullText Search in u r database fields and then simple isue the sql
command like ..

Select * from Emp where contains(FieldName,"SearchWord") ....
Like that ..

Even sql server also support the XML data type.. So Y not put the all u
r physical file into the database and the search on this files are also
u can done very easly..

By u r performence u need to implement the search on the file system
itself ,, Use Google Desktop Search, Google also provide a Desktop
search api for the application support ..

All the Best ..

 

[Mark]

Thanks for that... I'll take a look but I think it may be an overkill. I'm
only looking to search documents that have been referenced in the database
(not necessarilly scan directories etc. I'm wondering if it might be more
practical to read the documents in and search for the text like that.
Problem is that the documents can be anything from Word docs to Autocad
drawings and PDFs.

Thanks again

Mark

 

[Mark]

Thanks Kodali

I thought about storing the documents in the database but unfortunately the
document formats could be anything (Office docs, PDF, Autocad etc.) Also,
this is not really a document management system, it has to sit alongside
whatever systems and procedures are in place on the clients network. I'm
comfortable with SQL etc. I'm wondering if I should try reading the
documents text and scanning for search criteria like that. I could then just
append the results to the actual database search results. Will have to have
a bit mor of a think. Ultimately I don't want to hinder performance too
much.

Thanks again

Mark

 

[Guest]

Thanks for that... I'll take a look but I think it may be an overkill.

Problem is that the documents can be anything from
Word docs to Autocad drawings and PDFs.

Exactly - hence you might as well use a search engine : )