Spreadsheet loaded from DB and store to DB

[Marcela]

HI,

I'm new to the OWC! I'm trying to put a spreadsheet
component in a web page, load it with data from a SQL db
and then get the changes from the component (after a copy
paste) and store them into the database.
I'm trying to do this from the code behind, this does not
seem to work! Also I have not found any examples or
documentation that can help me with that (specially for
teh code behind part).
DOes someone has an example or some experience on how to
achieve this?
Thanks so much for yout time,
Marcela

 

[Alvin Bruney]

You cannot target the spreadsheet with codebehind. For the most part. You
must use script to automate it assuming that you are using the client-side
component and not the in-memory object. Microsoft has provided an office
component toolpack that contains a lot of samples and code. Download and
install to get you started.

watch for line wrap
http://www.microsoft.com/downloads/...77-2100-4586-A13C-50E56F101720&displaylang=en

 

[MikeHolloway]

Are you saying there is an example of loading a OWC10
spreadsheet from a sqlserver database in there?

 

[Alvin Bruney]

yes. you really need to download and install the tool pack. there is the
object model in there to help you understand how the object interface is
layed out. there are snippets of code to help you to manage the object
events. there are code samples and walk thrus to help you to load and read
data as well as write data. the is context sensitive help and key word
search help to guide you to solutions efficiently. all the questions you ask
can be answered from the tool pack. please take a look. it will be worth
your while.

 

[Megha]

Hi Marcela,
This is exactly what I need to do for my application.. I have been
trying to get it work for two days without success.. you may pls let
me know if you got it working ..

Alvin, I will download the pack and go through the doc.. Thanks a
lot,

Megha