By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 1,680 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

URGENT HELP! SQL+VB.NET for New Application

P: n/a
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
Apr 26 '06 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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

Apr 26 '06 #2

P: n/a
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


Apr 26 '06 #3

P: n/a
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



Apr 26 '06 #4

P: n/a
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****@discussions.microsoft.com> wrote in message
news:D0**********************************@microsof t.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**************@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
>>
>>
>
>


Apr 26 '06 #5

P: n/a
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****@discussions.microsoft.com> wrote in message
news:D0**********************************@microsof t.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**************@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
>>
>>
>
>


Apr 27 '06 #6

P: n/a
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****************@TK2MSFTNGP03.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****@discussions.microsoft.com> wrote in message
news:D0**********************************@microsof t.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**************@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
>>
>>
>
>


May 1 '06 #7

P: n/a
forgot the link it seems
http://research.microsoft.com/resear...report&id=1089
"Greg Young" <Dr*************@hotmail.com> wrote in message
news:ep**************@TK2MSFTNGP04.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****************@TK2MSFTNGP03.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****@discussions.microsoft.com> wrote in message
news:D0**********************************@microsof t.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**************@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
>>
>>
>
>



May 2 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.