Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If this is an intranet application and a small number of concurrent users, I will recommend you to consider using Word Automation. Over the years I have implemented Win32 Apps, Winform and Web Apps that automate Ms. Word and although many will critize the use of it, I personally find that it has its niche and can be very useful and work well if managed correctly. For printing to label, some of the key concerns will be layout, formatting and paging. The beauty of using Word MailMerge, you can design and test all that using Ms. Word. You can then create a template file and from the automation perspective, all you need to do is:</p> <ul> <li>Open the specific template file (from your 5 templates)</li> <li>Specify your data source</li> <li>Specify your mail merge option </li> <li>Execute the mail merge</li> <li>Print the resulting document to printer or save it to PDF (directly if you are using 2007 or later, or print to 3rd party pdf driver) </li> <li>Close the document &amp; word app</li> </ul> <p>Another very nice feature of using word automation is your ability to record macro and look into the code. So for example, if you are not sure on how to set the data source/mail merge option above, you can record the macro as you are doing that in the UI. Later, look into the generated VBA code and transpose the same logic in your .NET code to achieve the same processing logic flow.</p> <p>Here is some info to get you started (based on Word 2003, but the object model is very much the same for newer version) <a href="http://www.c-sharpcorner.com/UploadFile/amrish_deep/WordAutomation05102007223934PM/WordAutomation.aspx" rel="nofollow">http://www.c-sharpcorner.com/UploadFile/amrish_deep/WordAutomation05102007223934PM/WordAutomation.aspx</a></p>
    singulars
    1. This table or related slice is empty.
    1. POPrinting Avery labels from ASP.NET MVC
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USFadrian Sudaman
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COGreat information! However this will be a cloud based application, with good sized number of users. What the users have access to on their side is unknown, so everything should be done by our app through the browser. Would Word Automation be able to handle something like this?
      singulars
      1. PO
      1. USJames
    2. COYeah the above response is intended to be implemented on the sever side. Client will not require to have word install
      singulars
      1. PO
      1. USFadrian Sudaman
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload