Question How to understand the DB Concepts in VB.Net? (VSTO)

[PrabhakaranKaruppaih]

Hi Guys,
I have more than 13 years of experience in VBA and also using Ms Access Databases as backends. Recently decided to utilize the VSTO Word Document features to create rich reports (Ms Access Reporting Tools are very limited when comes to formatting). What's the Challenge then?

With Ms Access everything is simple:
Just declare a recordset.
Load it
and Use it.

But so far in my exploration with VB.Net:
There are 4 things are being created and involved:
Dataset
TableAdapter
TableAdpater Manager
and Binding Source.

My Exact Current requirements:
There should be a Macro-Enabled VSTO word document (*.docm)
which on opening has to print the last record of a Bill (Query Name is Bills)

Other features:
Feature No.1:
I have a sales form inside an Ms Access Database. Upon the clicking on a button the VSTO word Document has to open and print the last bill and quit.
Feature No.2:
The above feature has to be done invisibly but if I open the word Document, it has to have action pane having a Navigator in it settling on the last bill number by default but I want the navigator control to also have the general navigation features like: "|<< < > >>| >*" with a print Button to print the navigated bill using that control.

I know its a bit long post but I wanted to explain in details as much as I can. Thanks. Please reply and Provide Support.

With Hope,
Prabhakaran

 

[Ralston18]

VSTO (Visual Studio Tools for Office).

What VSTO add-ins are available?

What has been tried? What worked and what failed?

Take some screenshots of your work (macros ?) thus far and post here via imgur (www.imgur.com).

Be sure not to reveal any personally identifying information in the sales forms and/or bills. Redact as necessary.

 

[PrabhakaranKaruppaih]

Initially I was trying the mail merge feature only. But the problem is you cannot suppress the query dialog box before the document gets merged.

Why VSTO?
Evolution!

Let me explain, How VSTO makes things easier here. No:1 Lot of code saving thus less code and faster result.

Next, I want to understand the Database concepts (especially read-only Binding) in VB.Net i.e. from Fetching the data from a table to display it on a control. I want to understand both the sides Design time and Runtime to achieve the same result. I strongly believe that atleast single person must have mastered it here. Either this post has to reach him/her or the Person has to read this post. I have strong hope. Lets wait and see...

 

[USAFRet]

I want to understand both the sides Design time and Runtime to achieve the same result. I strongly believe that atleast single person must have mastered it here. Either this post has to reach him/her or the Person has to read this post. I have strong hope. Lets wait and see...

The issue is, that a Forum like this is not really a teaching platform.

Provide what code you've already tried, and maybe/probably someone out here can find the problem.
But that would also require a LOT of db design info, from your environment.

(and MS Access is my go to tool)

 

[Ralston18]

And - as a matter of curiosity regarding:

"Initially I was trying the mail merge feature only. But the problem is you cannot suppress the query dialog box before the document gets merged."

What query box?

What is its' purpose?

Details? What process is being used?

Screenshots? Post via imgur (www.imgur.com).

Provide some examples of what results are expected and what results are presented.

My thought is that there is some error in the logic being used and/or the coding.

[Note: I would also use MS Access.]