473,320 Members | 1,817 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

File and Database Search

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
Nov 27 '06 #1
5 2673
"Mark" <Mr***@asdfgh.comwrote 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.
Nov 28 '06 #2

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.comwrote:
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
Nov 28 '06 #3
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

"Spam Catcher" <sp**********@rogers.comwrote in message
news:Xn**********************************@127.0.0. 1...
"Mark" <Mr***@asdfgh.comwrote 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.

Nov 28 '06 #4
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

"Kodali Ranganadh" <ko*************@gmail.comwrote in message
news:11**********************@l39g2000cwd.googlegr oups.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.comwrote:
>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

Nov 28 '06 #5
"Mark" <Mr***@asdfgh.comwrote in
news:XR*******************@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 : )
Nov 29 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: Yang Li Ke | last post by:
Hi guys! I have some datas that I must check everytime a visitor comes to my site What is better to do: 1- Read data from a file or 2- Read data from a mysql db Thank you
4
by: jason | last post by:
I would appreciate some help on how to convert a database table into an html file via FSO and whether more seasoned asp programmers recommned this route. The main reason I am attempting to do this...
8
by: Rob Meade | last post by:
Lo all, Ok - I'm adding site search functionality to a database driven website. I have a list of 390 stop/ignore words, having looked at ASPFAQ already I see that the example uses an array,...
60
by: Julie | last post by:
What is the *fastest* way in .NET to search large on-disk text files (100+ MB) for a given string. The files are unindexed and unsorted, and for the purposes of my immediate requirements, can't...
7
by: ianenis.tiryaki | last post by:
well i got this assignment which i dont even have a clue what i am supposed to do. it is about reading me data from the file and load them into a parallel array here is the question: Step (1) ...
1
by: Bigrabid | last post by:
Howdy, I have an access database that I use to keep track of projects that my group is working on. There are a number of files associated with any one project, so I have as a parent to , which...
3
by: Ahmad Jalil Qarshi | last post by:
Hi, I have a text file having size about 2 GB. The text file format is like: Numeric valueAlphaNumeric values Numeric valueAlphaNumeric values Numeric valueAlphaNumeric values For example...
15
by: lxyone | last post by:
Using a flat file containing table names, fields, values whats the best way of creating html pages? I want control over the html pages ie 1. layout 2. what data to show 3. what controls to...
4
by: vitaminz | last post by:
Hi it's me again, I've pretty much finished a program I'm making, which does the following: The program is for a garage, and it does the following functions: Adds a new car Display cars Amend...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.