MSWord doc into Web App and store them in a SQL database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DQ dont quit - 02 Dec 2005 17:31 GMT

I'm currently working on a ASP.Net / C# / SQL 2000 project that involves the
input of keywords and MSWord documents into a web app and storing them in a
SQL database.. This information will then be used to perform weighted
searches on the keywords and text of the MSWord documents. How might this
best be accomplished?

Signature

DQdontquit

Reply to this Message

Rainier [MCT] - 12 Dec 2005 07:57 GMT

Well I programmed something like that a couple of years ago.
I stored the word documents on a harddrive searched throught them using
indexing service. You can use this service from within Sql Server.
Sql Server had a table with the names of the files to keep history
information.

Kind Regards.

Signature

Rainier van Slingerlandt
(Freelance trainer/consultant/developer)
www.slingerlandt.com

> I'm currently working on a ASP.Net / C# / SQL 2000 project that involves the
> input of keywords and MSWord documents into a web app and storing them in a
> SQL database.. This information will then be used to perform weighted
> searches on the keywords and text of the MSWord documents. How might this
> best be accomplished?

Reply to this Message

DQ dont quit - 12 Dec 2005 21:15 GMT

Do you think today it would be best to take advatage of SQL's Full Text File
searches on the Word docs since I can't see how I could store the text for
the doc file in the database if it contains more than 255 characters.

Signature

DQdontquit

> Well I programmed something like that a couple of years ago.
> I stored the word documents on a harddrive searched throught them using
[quoted text clipped - 9 lines]
> > searches on the keywords and text of the MSWord documents. How might this
> > best be accomplished?

Reply to this Message

Rainier [MCT] - 13 Dec 2005 08:10 GMT

eYes, if I had to develop a search thrue Wrod documents keeping a reference
in a SQL Server I would do the same thing again.
I wouldn't store the documents in de database evendo it is possible (blobs
of binairy data)

The search engine of the operating system takes the biggest load of your
shoulder developing a search engine. So I would use it.

Kind Regards.

Signature

Rainier van Slingerlandt
(Freelance trainer/consultant/developer)
www.slingerlandt.com

> Do you think today it would be best to take advatage of SQL's Full Text File
> searches on the Word docs since I can't see how I could store the text for
[quoted text clipped - 13 lines]
> > > searches on the keywords and text of the MSWord documents. How might this
> > > best be accomplished?

Reply to this Message

MSWord doc into Web App and store them in a SQL database

Free Magazines