i'm working on a project vb.net/sql server 2008r2.
i have a document model on .docx or pdf document.This document is formatted , has borders , logo , some grafic elements ...etc , but i want to put some information from my database in some specific position of the document.
( i try first to import this on a crystal report but the document resolution after the import is very low)
is possible from vb.net to get data from database and to populate the .doc or pdf document ?
Sounds like instead of creating a new word document, you want to insert data into your already formatted document.
The easiest method I can think of would be an automated mail merge routine drawing data from a data source such as an excel spreadsheet which could contain the insertion field data you require for the word document.
Getting the data from a database to an excel spreadsheet is also easy using vb.net. Just create your array holding what data you need, then to export to excel call a routine such as "WriteSpreadsheetFromArray(MyArrayName)"
You will find the source code for the above function (WriteSpreadsheetFromArray) at http://www.vbforums.com/showthread.php?t=455162
In your initial post you suggest your word document is already formatted with borders, logo and graphics and you wanted to place certain data in specific positions on the word document.
The easiest way to do this is using a mail merge routine. Almost every business office environment uses this method to product multiple word documents. The excel spreadsheet being also a Microsoft product is the ideal platform to hold the data you wish placed on the word document.
To understand this more fully, I suggest you google microsoft mail merge routines, but basically you get your already formatted word document and creat insertion points where you wish the data to go, then run the rountine which will cycle though the data on the excel spreadsheet and create your identical word documents with the data positioned where you wanted.
i've installed windows phone SDK and i don't understand why it only give me Windows Phone OS 7 and OS 7.1 since there is 7.5, is that SDK OS or WP OS?
and is it possible to write WP application using VB.NET?
which one better for WP, C# or VB.NET?
I have an Access Data table with three fields (date, tippingB, and precip). I am using dataGridView to view this table and make changes. The third field in the table (precip) is dependent on second field (tippingB). I was wondering if there is a way to use a formula in the field so that when I put a number in the second field, third field automatically gets updated. The last step of the code is updating the access table in the access database (that works so far).
So, my question is if one could use a formula for a column in a dataGridView and also bind it to the dataTable so that when update command is used, the database gets updated.
Interesting thought however, the file also contains a [Runtime] section as well as (possible multiple) [Task.1] and [Data.1] sections (which contain different data and tags depending on the job). If the file was just a CSV file then it would be easy to implement your idea however, in light of the extra data in the file; im not sure how this would work.
You could create a plugin to parse a section; load all plugins at startup, read a section, switch to the plugin that knows how to read/parse that section, and move on to the next one (until you run out of sections).
It'll probably take some experimenting to get it right, but it would allow you to create new plugins when sections change or get added. It should also make it easier to maintain the code in the long-run; you could write even test-scripts for each plugin/section.