Filling a .doc template with information retrieved from SQL

Question

0.00/5 (No votes)

See more:

Hi everyone !

I have a simple question ... I think LOL

I have : a C# Windows Form App that inserts, updates and retrieves information from an SQL Database. I've found a lot of useful information on the forums here and so far, the project is going pretty well. I don't plan on selling it or distributing it btw, it's just for my small business. I was even able to program a POS that transfers data to my accounting software.

So.. the project is almost over, but now I'd like to be able to print my contracts and invoices. I have a contract template (that I fill out by hand at the moment), it's in .doc

I'd like to know what the best (invisible and silent) way to insert data in my documents would be. By invisible and silent, I mean I don't want like Word to open and have to click print in there.

I'd just like to push a print button, fetch the data, have C# insert it into the template and print it.

So far, I know I have to build a template doc file (save it in which format?)

I've read posts and a little MSDN about using this:

C#

WordApplication.ActiveDocument.Bookmarks["BookmarkName"] .

but I can't figure out if I'll get the results I want with that.

Once again, thank you very much for the help. I can't say enough about how much I appreciate it.
I'm looking around the new posts and trying to help people if I can, but I'm still a "noob". I'll get there someday and be I"ll be able to help back *promise*

Posted 25-Jul-13 7:17am

Luthecia

Add a Solution

Comments

Boipelo 25-Jul-13 14:29pm

Adding to the below answer; there is word automation and pdf(itextshrp) articles here on codeproject. Search them, I once used both, thy do wonders.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ExcelledProducts CEO · Answer 1 · 2013-07-25T07:25:00

Quote:
I'd like to know what the best (invisible and silent) way to insert data in my documents would be.

Putting all of your code into a separate thread would make it "invisible and silent"

Quote:
I'd just like to push a print button, fetch the data, have C# insert it into the template and print it.

Their is no need to push a button because you can use a print dialogue.

Also

WordApplication.ActiveDocument.Bookmarks["BookmarkName"]

is when you have a word document plug in application.

If I were you I would instead use a hidden richtext box be your template (so nobody see's it) and do what you want with the data.