Showing posts with label word. Show all posts
Showing posts with label word. Show all posts

Wednesday, March 28, 2012

how to use word and pdf filter in full text search (SQLServer2k5)

where to find and how to use full text search service to index word and pdf documents. please point me to a tutorial or give a step by step instruction. thanks for reading.http://www.codeproject.com/csharp/fulltextsearchingifinters.asp

Friday, March 23, 2012

How to use the image datatype!

Can someone tell me how to store word file or other format files in sqlserver 2000?See below link could helps you

http://authors.aspalliance.com/das/insertimage.aspx|||Now I can store images in my database ,and retrieve them to display via the image web controls ,but there new problems,I want MS word files stored in database and retrieve them back as a whole.Users can get MS word files they uploaded before.In the database MS word files are stored as stream(that is binary seriaries),and I know MS word files are stored using UTF8 Encoding,including the usercontent which is typed by users and application format informations which is used MS Word to determin which format should the user content be displayed.When I retrieve the both contents back MS word treat them as both user contents.
And there is Encoding problems.I am a Chinese student ,I may not descript my problem clearly,I hope my friends can read it patiently,Thanks!|||Now I can store images in my database ,but how to retriee and displar them via the image web controls ,can anyone show me how to do this ? And there are new problems,I want MS word files (or other format such as pdf )stored in database to be retrieved back as a whole.Users can get MS word files they uploaded before.In the database ,MS word files are stored as stream(that is binary seriaries),and I know MS word files are stored using UTF8 Encoding,including the usercontent which is typed by users and application format informations which is used by MS Word to determin how the user content to be displayed.When I retrieve the both contents back from and store them in the disk via FileStream ,when I open the word MS word treat them as both user contents,and there is Encoding problems.I am a Chinese student ,I may not describe my problem clearly,I hope my friends can read it patiently,Thanks!

Wednesday, March 21, 2012

How to use SQL stored proc as datasource for MS Word mail merge?

Is it possible to use a SQL Server stored procedure as a datasource for MS
Word mail merge? If yes then how?
Yes but I believe it depends on what version of Word. You
can use MS Query, select whatever for the tables and then
edit the SQL text in MS Query. You can use something like:
{call YourStoredProcedure}
There is also an OpenDatasource method of the MailMerge
object.
-Sue
On Fri, 6 Aug 2004 14:40:15 -0500, "Fred Zolar"
<fzolar@.yahoo.com> wrote:

>Is it possible to use a SQL Server stored procedure as a datasource for MS
>Word mail merge? If yes then how?
>

How to use SQL stored proc as datasource for MS Word mail merge?

Is it possible to use a SQL Server stored procedure as a datasource for MS
Word mail merge? If yes then how?
Fred Zolar wrote:
> *Is it possible to use a SQL Server stored procedure as a datasource
> for MS
> Word mail merge? If yes then how? *
Have you figured this out? If so, I would be interested as I am
trying to do the same thing.
carolyn01
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message340375.html
|||Fred Zolar wrote:
> *Is it possible to use a SQL Server stored procedure as a datasource
> for MS
> Word mail merge? If yes then how? *
I found a way to get this to work. I created a view in SQL Server
placing the SQL in the view instead of the stored procedure. Then I
pointed the Word Merge document to the view. It works. Hope that
helps!
carolyn01
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message340375.html

How to use SQL stored proc as datasource for MS Word mail merge?

Is it possible to use a SQL Server stored procedure as a datasource for MS
Word mail merge? If yes then how?
quote:
Originally posted by Fred Zolar
Is it possible to use a SQL Server stored procedure as a datasource for MS
Word mail merge? If yes then how?


Have you figured this out? If so, I would be interested as I am trying to
do the same thing.|||
quote:
Originally posted by Fred Zolar
Is it possible to use a SQL Server stored procedure as a datasource for MS
Word mail merge? If yes then how?


I found a way to get this to work. I created a view in SQL Server placing
the SQL in the view instead of the stored procedure. Then I pointed the Wor
d Merge document to the view. It works. Hope that helps!