OWC 11 Spreadsheet Control

[sumtara]

I have managed to place a spreadsheet control on a webpage and fill i
from a database. How do I get changes back to the database withou
creating a connection and cycling through each row and sending it t
the database with an SQL update

 

[Alvin Bruney [MVP]]

There's a solution in the black book that goes something like this. When you
make changes, save the changes into a server side text box. On the server,
split the text box string by a \n delimiter. That will give you all the
rows. Iterate thru the rows and build your query. I think I need to offer
the black book as a download, it will save the hassle.