.Net Windows Service to Initiate Word Merge

Rhonda Fischer

New member
Joined
Sep 1, 2004
Messages
3
Programming Experience
1-3
Hello,

I have been reading on the subject of .Net Windows Services in
order to initiate a word merge based on candidates in my SQL
Server database not contacted in the past year. I wanted this
to occur every day.

I am a little concerned that a merge is not suited for
server development. If you have any suggested reading or
web sites I would really appreciate it.

Thank you kindly
Rhonda
 

Rhonda Fischer

New member
Joined
Sep 1, 2004
Messages
3
Programming Experience
1-3
.Net Windows Services Revisited - Help

Hello,

OBJECTIVE:
I would like to use a Windows Service to initiate a mail merge.
Is this an appropriate use of a Windows Service?

TECHNOLOGIES:
Microsoft .NET Framework 1.1 version 1.1.4322
SQL Server 2000

ACHIEVED:
VB.NET code to perform a merge from a form. The variables passed
being the word template and the date range into the .Net
Data Adapter where the people records are merged

NEED TO NOW:
Create a service that may use some of this code to run in the
background so that big merges do not tie valuable resources
leaving users not able to user their machines.

PROBLEMS:
Not sure how to use the records collected in the Data Adapter
to merge with my word template. Maybe somehow feed the records
into an array? And then to merge. If it's possible to use
an array.

If you have any suggestions or reading material that you might
be able to direct me to that would be very much appreciated.

Thank you kindly
Rhonda
 

mdolan

New member
Joined
Sep 9, 2004
Messages
2
Programming Experience
10+
I think you would be better off using a separate thread instead of a service. Have the executing thread report any progress to the Windows Form.

You may also want to put some type of an adjustable processing value on the Windows Form so that the user has the ability to ratchet the processing needs up and down; High priority, Medium, low... The executing thread would look at that and sleep between processing to let the system have some control.
 
Top Bottom