473,585 Members | 2,549 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

URGENT HELP! SQL+VB.NET for New Application

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
Apr 26 '06 #1
7 1798
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

Apr 26 '06 #2
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


Apr 26 '06 #3
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



Apr 26 '06 #4
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
>>
>>
>
>


Apr 26 '06 #5
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
>>
>>
>
>


Apr 27 '06 #6
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
>>
>>
>
>


May 1 '06 #7
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
>>
>>
>
>



May 2 '06 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3611
by: serge calderara | last post by:
Dear all, I have build a setup project for my VB.NET application, I need to know the installation path of an application in order to add file in it. How can do that inside my setup project ? Any sample would help regards serge
2
3120
by: Nick | last post by:
Hey, I'm facing a very strange problem. We have a windows application being maintained in CVS (not VSS!!!! and i hate it! but nevertheless....) Within this application, we are connecting to an MS Access database, using the connection string: PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & ";Password=" & strDBPassword where...
3
1629
by: Freebeerboy | last post by:
Hi, it would be fantastic if anyone could suggest a solution to this problem. I've written an ASP.Net (VB) application which uses stored procedures in Oracle. All seems fine, except occasionally I get the error below: System.Data.OracleClient.OciHandle.op_Implicit(OciHandle x) +23...
8
4138
by: ChrisK | last post by:
Hi, I'm beginner with VB.net and i have a trouble... At work, they decided to program with tabcontrol...and i'mm in charge of this ! There is my problem. I've a form with one tabcontrol (TBC1 ). This TBC1 contents n TabPages ( TBP1,2,3,..,n) For each TBPn i 've got an specific usercontrol which have controls and code ( data access, ......
5
2864
by: Andrew | last post by:
Hey all, Requesting help from the VB.Net gurus in here. I was given a task to write a Windows Service (VB.Net) that would run an external program, and if that program closed for any reason (other than the service being stopped) it would restart it. I have written the service to do just this, and for testing purposes I am running the...
0
1058
by: Amjath | last post by:
I put all my application updater block dll to GAC, to avoid keeping this dll's in my bin folder. After doing this all i build my project, it works fine, now i run my project it give me an error like this, "Unable to load configuration from the XML configuration file: 'My Application Path'. This can be caused by a number of problems, but...
0
866
by: BrianDH | last post by:
Hi I have a VB.Net windows application that’s running on 30 PCs. All in the same network. All PCs run XP Pro. All PCs have Framework 1.1 2 of the PC throw an error when they try to send mail via the application. “Could not Access CDO messenger object” The “To” email address is always the same. The “From” address is based on...
1
1383
by: r_tirumalasetty | last post by:
Hi All, I need to develop an application that accepts users of a company and i want to develop a code for sending messages to all the users of that company provided that all the names of users are populated in the listbox.Upon selecting the username i need to send a message to that particular user.If i select all i need to send that message to...
5
7864
by: Elena | last post by:
I need the VB.NET code to change the header/footer of an Excel spread sheet, ASAP. I am doing it through a VB application. I can change the ranges/cell values using code, but I do not know how to change things outside of the cell ranges. I will try and post in an Excel group, but i do not need to change it in a worksheet, I need to change...
0
1053
by: DavideR | last post by:
I have developed in vs2005 an application shipped from vb6 in a machine with w2000 professional then i make with the setup wizard a setup project for my exe (all reference are added) and then after insatlling .net framework 2. 0 i try to install on a windows xp machine but when i run the exe i recieve an error the type initializer for...
0
7904
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main...
0
8334
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7947
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8209
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6596
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5707
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5386
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3856
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1444
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.