Hi Greg,
I understand. But what is your reason that you not recommend saving Word
Document in SQL Server 2000.
The document for each customer is one page and for each insurance it will be
4 to 6 page.
My reason is to save and retrive Word Document from SQL server comes from
security issues that the company is having now. Plus I want to retrive word
document in VB.NET form and edit it and when user clicks tho save it will
going to save it in SQL Server plus the form also contains the print
functionality.
Sorry to say that I am first time going to use Word document in VB.NET
application and I am bit confused after reading many post in www. So here is
more question to you if you don't mind.
- How can I save Word Document in SQL Server 2000 SP4 as binary data without
losing the formating and
- How can I receive the Word Documemnt from SQL Server 2000 into VB.NET form
for editing, re-saving into
SQL Server as well as print functionlity.
If as you say, the way saving Word Document into SQL Server is not
advasiable and your reason if you explain to me is clear, I might consider to
goto your way and accomplish my task. But I will be need further your
assitant for:
- How can I save and retrive the Word Document using VB.NET in Shared folder
on Network or local Harddisk using
VB.NET
- How can I use the link to open word document into VB.NET form
- How can I use save and print functionlity to edit and save back into
original destination the Word Document or use the
print button to prin the Word Document.
I thank you for your kind understanding.
Rgds,
GC
"Greg Young [MVP]" wrote:
this example even!
http://www.c-sharpcorner.com/UploadF...f-5addf5b77ca4
Cheers,
Greg
"Greg Young [MVP]" <Dr*************@hotmail.com> wrote in message
news:Oi**************@TK2MSFTNGP02.phx.gbl...I am not quite sure I am following the first question.
For saving the data into the SqlServer you could store it into a binary
field .. I will however not recommend this method if you can avoid it.
Instead store the documents on a network shared and stored a string path
to the document. This example reads/writes images to a SqlServer ... the
methodology is the same.
"Niyazi" <Ni****@discussions.microsoft.com> wrote in message
news:E3**********************************@microsof t.com... Hi,
I am developing small insurance application using VB.NET and SQL server
2000.
My tables in SQL server are:
tbl_Customer (stores the custmer information)
tbl_CustImage (stores the customer picture and
signature)
tbl_InsuranceCompanies (stores the Insurance companies information)
tbl_InsuranceType (stores the insurance type)
tbl_LifeInsurance (stores the LifeInsurance information)
tbl_FireQuakeInsurance (stores the FireQuakeInsuranceinformation)
tbl_CarInsurance (stores the LifeInsurance information)
tbl_BLOBCustomer (store with CustomerID for Document)
tbl_BLOBLIFEInsurance (store with LIFEInsuranceID for Document)
tbl_BLOBFIREQUAKEInsurance (store with FQInsuranceID for Document)
tbl_BLOBCARInsurance (store with CARInsuranceID for Document)
--------------------------------------------------------------------------------
If the Insurance is going to renewed move old data into below table
tbl_OLDLIFEInsurance (store with new ID)
tbl_OLDFIREInsurance (store with new ID)
tbl_OLDCARInsurance (store with new ID)
----------------------------------------------------------------------------------
My question is that when the Insurance going to be renew I need to move
old
data in old.... tables and replace the data for the Insurance that going
to
be renewed using InsurancePolicyID as ID.
Doing things like in above are correct or not?
And secondly how do I store Word Document or Excel file into SQL server
2000
and later retrive for editinig and restore the documents or excel files?
Thank you very much for your kind understanding for reading my post.
Rgds
Niyazi
