URGENT HELP! SQL+VB.NET for New Application

[Niyazi]

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_InsuranceCo mpanies (stores the Insurance companies information)
tbl_InsuranceTy pe (stores the insurance type)
tbl_LifeInsuran ce (stores the LifeInsurance information)
tbl_FireQuakeIn surance (stores the FireQuakeInsura nceinformation)
tbl_CarInsuranc e (stores the LifeInsurance information)
tbl_BLOBCustome r (store with CustomerID for Document)
tbl_BLOBLIFEIns urance (store with LIFEInsuranceID for Document)
tbl_BLOBFIREQUA KEInsurance (store with FQInsuranceID for Document)
tbl_BLOBCARInsu rance (store with CARInsuranceID for Document)

--------------------------------------------------------------------------------

If the Insurance is going to renewed move old data into below table

tbl_OLDLIFEInsu rance (store with new ID)
tbl_OLDFIREInsu rance (store with new ID)
tbl_OLDCARInsur ance (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 InsurancePolicy ID 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.

"Niyazi" <Ni****@discuss ions.microsoft. com> wrote in message
news:E3******** *************** ***********@mic rosoft.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_InsuranceCo mpanies (stores the Insurance companies information)
tbl_InsuranceTy pe (stores the insurance type)
tbl_LifeInsuran ce (stores the LifeInsurance information)
tbl_FireQuakeIn surance (stores the FireQuakeInsura nceinformation)
tbl_CarInsuranc e (stores the LifeInsurance information)
tbl_BLOBCustome r (store with CustomerID for Document)
tbl_BLOBLIFEIns urance (store with LIFEInsuranceID for Document)
tbl_BLOBFIREQUA KEInsurance (store with FQInsuranceID for Document)
tbl_BLOBCARInsu rance (store with CARInsuranceID for Document)

--------------------------------------------------------------------------------

If the Insurance is going to renewed move old data into below table

tbl_OLDLIFEInsu rance (store with new ID)
tbl_OLDFIREInsu rance (store with new ID)
tbl_OLDCARInsur ance (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 InsurancePolicy ID 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]]

this example even!
http://www.c-sharpcorner.com/UploadF...f-5addf5b77ca4

Cheers,

Greg
"Greg Young [MVP]" <Dr************ *@hotmail.com> wrote in message
news:Oi******** ******@TK2MSFTN GP02.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****@discuss ions.microsoft. com> wrote in message
news:E3******** *************** ***********@mic rosoft.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_InsuranceCo mpanies (stores the Insurance companies information)
tbl_InsuranceTy pe (stores the insurance type)
tbl_LifeInsuran ce (stores the LifeInsurance information)
tbl_FireQuakeIn surance (stores the FireQuakeInsura nceinformation)
tbl_CarInsuranc e (stores the LifeInsurance information)
tbl_BLOBCustome r (store with CustomerID for Document)
tbl_BLOBLIFEIns urance (store with LIFEInsuranceID for Document)
tbl_BLOBFIREQUA KEInsurance (store with FQInsuranceID for Document)
tbl_BLOBCARInsu rance (store with CARInsuranceID for Document)

--------------------------------------------------------------------------------

If the Insurance is going to renewed move old data into below table

tbl_OLDLIFEInsu rance (store with new ID)
tbl_OLDFIREInsu rance (store with new ID)
tbl_OLDCARInsur ance (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 InsurancePolicy ID 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

[Niyazi]

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******** ******@TK2MSFTN GP02.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****@discuss ions.microsoft. com> wrote in message
news:E3******** *************** ***********@mic rosoft.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_InsuranceCo mpanies (stores the Insurance companies information)
tbl_InsuranceTy pe (stores the insurance type)
tbl_LifeInsuran ce (stores the LifeInsurance information)
tbl_FireQuakeIn surance (stores the FireQuakeInsura nceinformation)
tbl_CarInsuranc e (stores the LifeInsurance information)
tbl_BLOBCustome r (store with CustomerID for Document)
tbl_BLOBLIFEIns urance (store with LIFEInsuranceID for Document)
tbl_BLOBFIREQUA KEInsurance (store with FQInsuranceID for Document)
tbl_BLOBCARInsu rance (store with CARInsuranceID for Document)

--------------------------------------------------------------------------------

If the Insurance is going to renewed move old data into below table

tbl_OLDLIFEInsu rance (store with new ID)
tbl_OLDFIREInsu rance (store with new ID)
tbl_OLDCARInsur ance (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 InsurancePolicy ID 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]]

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
"Niyazi" <Ni****@discuss ions.microsoft. com> wrote in message
news:D0******** *************** ***********@mic rosoft.com...

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******** ******@TK2MSFTN GP02.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****@discuss ions.microsoft. com> wrote in message
> news:E3******** *************** ***********@mic rosoft.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_InsuranceCo mpanies (stores the Insurance companies information)
>> tbl_InsuranceTy pe (stores the insurance type)
>>
>>
>> tbl_LifeInsuran ce (stores the LifeInsurance information)
>> tbl_FireQuakeIn surance (stores the FireQuakeInsura nceinformation)
>> tbl_CarInsuranc e (stores the LifeInsurance information)
>>
>>
>> tbl_BLOBCustome r (store with CustomerID for Document)
>> tbl_BLOBLIFEIns urance (store with LIFEInsuranceID for Document)
>> tbl_BLOBFIREQUA KEInsurance (store with FQInsuranceID for Document)
>> tbl_BLOBCARInsu rance (store with CARInsuranceID for Document)
>>
>> --------------------------------------------------------------------------------
>>
>> If the Insurance is going to renewed move old data into below table
>>
>> tbl_OLDLIFEInsu rance (store with new ID)
>> tbl_OLDFIREInsu rance (store with new ID)
>> tbl_OLDCARInsur ance (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 InsurancePolicy ID 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
>>
>>
>
>

[Niyazi]

Hi Greg
I will goto SqlServer newsgroup.

Thank you.

Rgds,
Niyazi

"Greg Young [MVP]" wrote:

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
"Niyazi" <Ni****@discuss ions.microsoft. com> wrote in message
news:D0******** *************** ***********@mic rosoft.com...

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******** ******@TK2MSFTN GP02.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****@discuss ions.microsoft. com> wrote in message
> news:E3******** *************** ***********@mic rosoft.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_InsuranceCo mpanies (stores the Insurance companies information)
>> tbl_InsuranceTy pe (stores the insurance type)
>>
>>
>> tbl_LifeInsuran ce (stores the LifeInsurance information)
>> tbl_FireQuakeIn surance (stores the FireQuakeInsura nceinformation)
>> tbl_CarInsuranc e (stores the LifeInsurance information)
>>
>>
>> tbl_BLOBCustome r (store with CustomerID for Document)
>> tbl_BLOBLIFEIns urance (store with LIFEInsuranceID for Document)
>> tbl_BLOBFIREQUA KEInsurance (store with FQInsuranceID for Document)
>> tbl_BLOBCARInsu rance (store with CARInsuranceID for Document)
>>
>> --------------------------------------------------------------------------------
>>
>> If the Insurance is going to renewed move old data into below table
>>
>> tbl_OLDLIFEInsu rance (store with new ID)
>> tbl_OLDFIREInsu rance (store with new ID)
>> tbl_OLDCARInsur ance (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 InsurancePolicy ID 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]

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

Cheers,

Greg
"Greg Young [MVP]" <Dr************ *@hotmail.com> wrote in message
news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..

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
"Niyazi" <Ni****@discuss ions.microsoft. com> wrote in message
news:D0******** *************** ***********@mic rosoft.com...

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******** ******@TK2MSFTN GP02.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****@discuss ions.microsoft. com> wrote in message
> news:E3******** *************** ***********@mic rosoft.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_InsuranceCo mpanies (stores the Insurance companies information)
>> tbl_InsuranceTy pe (stores the insurance type)
>>
>>
>> tbl_LifeInsuran ce (stores the LifeInsurance information)
>> tbl_FireQuakeIn surance (stores the FireQuakeInsura nceinformation)
>> tbl_CarInsuranc e (stores the LifeInsurance information)
>>
>>
>> tbl_BLOBCustome r (store with CustomerID for Document)
>> tbl_BLOBLIFEIns urance (store with LIFEInsuranceID for Document)
>> tbl_BLOBFIREQUA KEInsurance (store with FQInsuranceID for Document)
>> tbl_BLOBCARInsu rance (store with CARInsuranceID for Document)
>>
>> --------------------------------------------------------------------------------
>>
>> If the Insurance is going to renewed move old data into below table
>>
>> tbl_OLDLIFEInsu rance (store with new ID)
>> tbl_OLDFIREInsu rance (store with new ID)
>> tbl_OLDCARInsur ance (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 InsurancePolicy ID 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]

forgot the link it seems
http://research.microsoft.com/resear...report&id=1089
"Greg Young" <Dr************ *@hotmail.com> wrote in message
news:ep******** ******@TK2MSFTN GP04.phx.gbl...

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

Cheers,

Greg
"Greg Young [MVP]" <Dr************ *@hotmail.com> wrote in message
news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..

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
"Niyazi" <Ni****@discuss ions.microsoft. com> wrote in message
news:D0******** *************** ***********@mic rosoft.com...

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******** ******@TK2MSFTN GP02.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****@discuss ions.microsoft. com> wrote in message
> news:E3******** *************** ***********@mic rosoft.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_InsuranceCo mpanies (stores the Insurance companies
>> information)
>> tbl_InsuranceTy pe (stores the insurance type)
>>
>>
>> tbl_LifeInsuran ce (stores the LifeInsurance information)
>> tbl_FireQuakeIn surance (stores the
>> FireQuakeInsura nceinformation)
>> tbl_CarInsuranc e (stores the LifeInsurance information)
>>
>>
>> tbl_BLOBCustome r (store with CustomerID for Document)
>> tbl_BLOBLIFEIns urance (store with LIFEInsuranceID for Document)
>> tbl_BLOBFIREQUA KEInsurance (store with FQInsuranceID for Document)
>> tbl_BLOBCARInsu rance (store with CARInsuranceID for Document)
>>
>> --------------------------------------------------------------------------------
>>
>> If the Insurance is going to renewed move old data into below table
>>
>> tbl_OLDLIFEInsu rance (store with new ID)
>> tbl_OLDFIREInsu rance (store with new ID)
>> tbl_OLDCARInsur ance (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 InsurancePolicy ID 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
>>
>>
>
>