OWC11 with ASP.NET

[askr]

I need to create a ASP.NET Web Page with a Pivot Table using VB.NET,
which reads data from a Query/View/Stored Procedure from a SQL Server
2000 Database.

Can anyone please give me an example of the above. I have seen some
examples of such an implementation but in all the examples, the
Connection String is exposed when we view the source of the page,
which I do not want to expost. I would like to control the connection
and content through the Code Behind Page. I beleive this can be done
through the Interop Assemblies.

Pl. Help

 

[Dan Ricker]

OWC is not a "Web Control" as defined by VS.NET/ASP.NET.

The OWC control can exist either on the client or on the
server but not on both (like real "Web Controls").

Without creating a "Web Control" that is a wrapper for the
OWC controls you can not use both Code-Behind and client
rendering.

There can be big performance issues using OWC in a "Web
Control". and I'm not convinced that it would hide the
connection string as you want.

 

[Alvin Bruney]

One possible option is to data mine on the server and then stream the data
to the client. Once it is on the client, you load it into the control. It is
tricky but i've got it to work. There aren't any performance issues or
scalability problems using this method.

With this approach, your query strings are safe because it runs in the code
behind on the server