URGENT HELP! SQL+VB.NET for New Application

[Guest]

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

 

[Greg Young [MVP]]

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.

 

[Greg Young [MVP]]

this example even!
http://www.c-sharpcorner.com/Upload...rticleID=505613ea-3493-420b-96ef-5addf5b77ca4

Cheers,

Greg

 

[Guest]

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]]

From what I am told ... SqlServer does not like it performance wise when you
store lots of large binary fields in it. I would be the wrong person to ask
for the details on that though, the SqlServer newsgroup could probably give
you a very complete answer as to why that happens ... I have always based
upon the recommendation of people who know alot more about SQL server than I
kept my files outside of the database with path links.

If you were to store it in the database though, the access would work
exactly like the image example I gave you earlier (you could in fact use the
..doc file and save it, thus when you reconstitute it it is the same exact
doc file). The only difference between the article is that its binary data
is images, yours would be word docs

As for the word automation that you mention you can do this relatively
easily; if you google on "VB.NET WORD AUTOMATION" there are many examples
out there. Another option would be to use a control that supports the same
formats http://www.textcontrol.com/ has a control that does this (commercial
product) which would also allow tighter integration with your software.

Cheers,

Greg

 

[Guest]

Hi Greg
I will goto SqlServer newsgroup.

Thank you.

Rgds,
Niyazi

 

[Greg Young]

This report gives a full analysis on storing files in your DB.

Cheers,

Greg

 

[Greg Young]

forgot the link it seems
http://research.microsoft.com/research/pubs/view.aspx?type=technical+report&id=1089