OWC11 Spreadsheet Control - Update Capability

[TimS]

Hello, I would appreciate any advice on if what I am proposing to do can be
done, and a good source of reference material to understand how to do it if
it can.

I have an OWC11 spreadsheet control in a VB.NET 2003 Windows Application. I
have no problem populating the spreadsheet with data from SQL Server using a
Stored Procedure, but need to allow the end-user to make modifications to the
data in the spreadsheet and then update the appropriate rows in SQL Server.

Thanks in advance!

Tim

 

[Alvin Bruney - ASP.NET MVP]

the black book is a good source. essentially, you just grab the results of
the changed range and write sequel queries. pretty straight forward - maybe
10 perhpas 20 lines of code...

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006

 

[TimS]

Thanks Alvin. Guess I will be buying your book!

Tim

the black book is a good source. essentially, you just grab the results of
the changed range and write sequel queries. pretty straight forward - maybe
10 perhpas 20 lines of code...

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Hello, I would appreciate any advice on if what I am proposing to do can be
done, and a good source of reference material to understand how to do it if
it can.

I have an OWC11 spreadsheet control in a VB.NET 2003 Windows Application. I
have no problem populating the spreadsheet with data from SQL Server using a
Stored Procedure, but need to allow the end-user to make modifications to the
data in the spreadsheet and then update the appropriate rows in SQL Server.

Thanks in advance!

Tim

 

[TimS]

Hi Alvin, thanks again for your reply. But, I do have one more question if
you don't mind. I had done some poking around looking for documentation and
discovered the .CHM files for OWC. After reading the file pertaining to the
Excel Spreadsheet component, it appeard to me that in order to accomplish
what I want to do, I would have to use Sharepoint or some other Web Service.
Could you tell me if your reply to my original question can be done in a
strictly VB.NET 2003 Windows Application and not involving any Web Services?
I would greatly appreciate it. By the way, I just ordered your book from
lulu - your shameless Author plug worked!

Take Care,

Tim

the black book is a good source. essentially, you just grab the results of
the changed range and write sequel queries. pretty straight forward - maybe
10 perhpas 20 lines of code...

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Hello, I would appreciate any advice on if what I am proposing to do can be
done, and a good source of reference material to understand how to do it if
it can.

I have an OWC11 spreadsheet control in a VB.NET 2003 Windows Application. I
have no problem populating the spreadsheet with data from SQL Server using a
Stored Procedure, but need to allow the end-user to make modifications to the
data in the spreadsheet and then update the appropriate rows in SQL Server.

Thanks in advance!

Tim

 

[Alvin Bruney - ASP.NET MVP]

No you don't need webservices. A rough (from the top of my head) example
would be.
if axSpreadsheet1.IsDirty = True then
Dim stringSql as string
stringSQL = "Update row set whatever to '" & axSpreadsheet1.Cells(1)"'"
End if

this would take the value in cell A1 and put it in a sql query. Then you can
fire it at the database.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Hi Alvin, thanks again for your reply. But, I do have one more question if
you don't mind. I had done some poking around looking for documentation and
discovered the .CHM files for OWC. After reading the file pertaining to the
Excel Spreadsheet component, it appeard to me that in order to accomplish
what I want to do, I would have to use Sharepoint or some other Web Service.
Could you tell me if your reply to my original question can be done in a
strictly VB.NET 2003 Windows Application and not involving any Web Services?
I would greatly appreciate it. By the way, I just ordered your book from
lulu - your shameless Author plug worked!

Take Care,

Tim

the black book is a good source. essentially, you just grab the results of
the changed range and write sequel queries. pretty straight forward - maybe
10 perhpas 20 lines of code...

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Hello, I would appreciate any advice on if what I am proposing to do

can
be

done, and a good source of reference material to understand how to do

it
if

it can.

I have an OWC11 spreadsheet control in a VB.NET 2003 Windows

Application.
I

have no problem populating the spreadsheet with data from SQL Server

using
a

Stored Procedure, but need to allow the end-user to make modifications

to
the

data in the spreadsheet and then update the appropriate rows in SQL Server.

Thanks in advance!

Tim

 

[TimS]

Thanks again Alvin. I am looking forward to receiving your book.

Tim

No you don't need webservices. A rough (from the top of my head) example
would be.
if axSpreadsheet1.IsDirty = True then
Dim stringSql as string
stringSQL = "Update row set whatever to '" & axSpreadsheet1.Cells(1)"'"
End if

this would take the value in cell A1 and put it in a sql query. Then you can
fire it at the database.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Hi Alvin, thanks again for your reply. But, I do have one more question if
you don't mind. I had done some poking around looking for documentation and
discovered the .CHM files for OWC. After reading the file pertaining to the
Excel Spreadsheet component, it appeard to me that in order to accomplish
what I want to do, I would have to use Sharepoint or some other Web Service.
Could you tell me if your reply to my original question can be done in a
strictly VB.NET 2003 Windows Application and not involving any Web Services?
I would greatly appreciate it. By the way, I just ordered your book from
lulu - your shameless Author plug worked!

Take Care,

Tim

the black book is a good source. essentially, you just grab the results of
the changed range and write sequel queries. pretty straight forward - maybe
10 perhpas 20 lines of code...

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------



Hello, I would appreciate any advice on if what I am proposing to do can
be
done, and a good source of reference material to understand how to do it
if
it can.

I have an OWC11 spreadsheet control in a VB.NET 2003 Windows Application.
I
have no problem populating the spreadsheet with data from SQL Server using
a
Stored Procedure, but need to allow the end-user to make modifications to
the
data in the spreadsheet and then update the appropriate rows in SQL
Server.

Thanks in advance!

Tim