File and Database Search

27 Nov 2006 11:37 PM

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

28 Nov 2006 4:02 AM

Spam Catcher

"Mark" <Mr***@asdfgh.com> wrote in news:CEKah.56725$163.46576@newsfe6-

gui.ntli.net:

> 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.

28 Nov 2006 10:36 PM

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

Show quoteHide quote

"Spam Catcher" <spamhoneypot@rogers.com> wrote in message
news:Xns9888EA53B134Eusenethoneypotrogers@127.0.0.1...
> "Mark" <Mr***@asdfgh.com> wrote in news:CEKah.56725$163.46576@newsfe6-
> gui.ntli.net:
>
>> 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.

29 Nov 2006 1:58 PM

Spam Catcher

"Mark" <Mr***@asdfgh.com> wrote in
news:XR2bh.60416$TH3.47513@newsfe2-gui.ntli.net:

> 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 : )

28 Nov 2006 4:20 AM

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 ..

Show quoteHide quote

On Nov 28, 4:37 am, "Mark" <M***@asdfgh.com> wrote:
> 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

28 Nov 2006 10:44 PM

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

Show quoteHide quote

"Kodali Ranganadh" <kodalirangan***@gmail.com> wrote in message
news:1164687621.099661.159600@l39g2000cwd.googlegroups.com...
>
>
>
> 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 ..
>
> On Nov 28, 4:37 am, "Mark" <M***@asdfgh.com> wrote:
>> 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
>