I would like to learn if AsposeWord.NET allows me to accomplish below things…
Can I save and retrive aspose word from SQL Server 2000?
I have a database that contains customer details, orders etc. Does Asposeword allows me to manupulate the word template with SQL Server data.
Example: I have to sell insurance and once the customer accept my insurance policy I enter data using VB.NET 2005 forms into SQL Server and in that form I can print a word document that contains Insurance policy that some part of the policy such as insurance number + customer detail comes from my newly entered data and I can print that word file as well as I can resave back to my SQL Server.
I did use dsoframer.ocx to achive this with VB.NET 2003 and it was quite okay but problem comes from the server gets too busy if more than 5 user try to enter different insurance policy into SQL Server. I heard that Aspose Word can achive this moire efficent way. But I fortunetly to I couldn’t find any real example to try it before I consider to buy the this component.
So, can anyone help me to find soulution before I buy the product.
Thanks for your interest in Aspose.Words. Aspose.Words primary mission is to ensure highly efficient server-side document generation and data fill.
Concerning your questions. It is a bit unclear what do you mean by “save and retrieve aspose word from SQL Server 2000”. I assume you want to retrieve and save MS Word documents to SQL Server database. Yes, that is possible with Aspose.Words. The code examples for this can be found on this forum.
Filling the document template with data taken from database is one of the primary functions of Aspose.Words API. This process is called mail merge in MS Word. The document template should have merge fields placed where the data should be inserted. Then the merge can be executed with data source such as DataTable, DataView, DataSet, etc., retrieved from the database using ADO.NET data providers.
I suggest you download our evaluation package, which will install a fully functional Aspose.Words component with only few limitations, such as evaluation watermark and file size limit. The evaluation package also contains well developed documentation and source code examples, some of which are exactly related to your task.
Hope this helps. Please let me know if you have further questions.