Write back to Database

[PhiberOptic]

Hello,

I'm using OWC in my ASP web application to display data from cubes or MS SQL
Tables. So far everything is working fine.

What I would like to know, is whether there is any way to change the
displayed data in the Web Components and write this changes back in the
database (or in the cubes) ??

What would be the best way to implement such a function if its possible ??

Thanks,

PhiberOptic

 

[Heather]

I don't know about cubes (you have to have writeback enabled), but I've had
great success with writing data back to the transactional database by
recompiling the OWC to handle events, then updating the underlying dataset
when a cell changes or recalculates. You just have to have a reference to
the cell address in your dataset so that you know which row to update when a
cell is modified.

This article describes how to handle events in OWC:

http://support.microsoft.com/default.aspx?scid=kb;en-us;328275

 

[PhiberOptic]

Hi Heather,

thanks for your reply. I followed the steps discribed in the article you
posted a link to. After I added the newly compiled DLL to my Visual Studio
Toolbox i was not able to drag them into the html part of my ASP solution ??

Best Regards,

PhiberOptic

 

[PhiberOptic]

Hi Heather,

thanks for your response ! I compiled my own DLL following the article you
posted a link to. Problem is, after adding the new OWCs to my Toolbar in
Visual Studio they are not selectable and I can't drag them to the html form
of my ASP.Net Solution !?

Can you help me with this issue or do you have some sample code how I can
use my recompiled DLL ?
Another question is, do the clients also need this Dll, or only I myself on
the developement system ?

Best Regards,

PhiberOptic