Re: AxOWC11 in OWC11-web-application?!

Tech-Archive recommends: Speed Up your PC by fixing your registry

there is an e-book, but it isn't currently available - possibly toward the
end of the year.


--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"Rouven Hertenstein" <RouvenHertenstein@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:30C6F1AF-6068-4B9F-955E-C999FCE618E4@xxxxxxxxxxxxxxxx
> Is it possible to buy your black book in the form of an e-book? The
> shipment
> would take a long time :-(
>
> Regards,
> Rouven
>
> "Rouven Hertenstein" wrote:
>
>> Hi Alvin,
>>
>> I'm a little irritated. I thought, that the xml-structure from my
>> webservice
>> is owc-conform. Finally, the owc-windows-application (that I've just
>> created
>> for testing) works with this webservice:
>>
>> <WebMethod()> Public Function GetResultsAsAdoXML() As String
>> Dim myAdoRs As ADODB.Recordset
>> Dim myAdoConnection As New ADODB.Connection
>> Dim mypersiststream As New ADODB.Stream
>>
>> Dim myConnectionString As String = "driver={SQL Server};" & _
>> "Server=sql-server;" & _
>> "Database=test-database;" & _
>> "UID=sa;" & _
>> "PW=;"
>>
>> Dim mySelect As String = "SELECT * from xy"
>>
>> myAdoConnection.ConnectionString = myConnectionString
>> myAdoConnection.Open()
>> myAdoRs = myAdoConnection.Execute(mySelect)
>> myAdoRs.Save(mypersiststream,
>> ADODB.PersistFormatEnum.adPersistXML)
>> Return mypersiststream.ReadText
>> End Function
>>
>> So, needs an owc-web-application an other xml-structure than an
>> owc-windows-application? Would be hard to believe.
>>
>> Regards,
>> Rouven
>>
>>
>> "Alvin Bruney [MVP - ASP.NET]" wrote:
>>
>> > first, you need to embed the owc object in the page. Once it is
>> > embedded,
>> > your webservice would need to be modified to retrieve comma delimited
>> > data.
>> > Then you can use the webservice behavior or xml-http to retrieve data
>> > from
>> > the webservice. I have a full example implemented in the black book,
>> > but
>> > basically the process would be roughly equivalent to:
>> >
>> > -create xml-http instance
>> > var obj = server.createinstance("microsoft.xmlhttp")
>> > if obj
>> > spreadsheet1.CSVDATA = obj.getData()
>> >
>> > The assumption here is that getData is the webservice. Ofcourse, you
>> > have a
>> > lot of plumbing work to do to get the xml-http wired up, but this is
>> > the
>> > general approach.
>> >
>> >
>> > --
>> > Regards,
>> > Alvin Bruney - ASP.NET MVP
>> >
>> > [Shameless Author Plug]
>> > The Microsoft Office Web Components Black Book with .NET
>> > Now available @ www.lulu.com/owc, Amazon.com etc
>> > "Rouven Hertenstein" <RouvenHertenstein@xxxxxxxxxxxxxxxxxxxxxxxxx>
>> > wrote in
>> > message news:0762B592-8EDC-47D2-924B-28351DAF1B6C@xxxxxxxxxxxxxxxx
>> > > Sorry for my bad description.
>> > >
>> > > I only want to connect an OWC-web-application with my web service ;-)
>> > > I excuted the sample with the windows-application just for
>> > > comparison.
>> > > just
>> > > for a thread.
>> > >
>> > > Now, I dont't know how to address the AxPivotTable, AxChartSpace,
>> > > AxDataSourceControl etc. because I can't import or reference to
>> > > AxOWC11 in
>> > > a
>> > > web-application. But it's strangely possible to do that in a
>> > > windows-application (for comparison only).
>> > >
>> > > It's obscure for me, because I thought, that I can build an
>> > > owc-web-application in the same way like a owc-windows-application.
>> > > It
>> > > seems
>> > > not to be so.
>> > >
>> > > I hope, I described my problem clearer?!
>> > >
>> > >
>> > > "Alvin Bruney [MVP - ASP.NET]" wrote:
>> > >
>> > >> I'm not really sure i understand what you are saying. Are you
>> > >> wanting to
>> > >> build a windows owc based app that reads a web based owc app?
>> > >>
>> > >> --
>> > >> Regards,
>> > >> Alvin Bruney - ASP.NET MVP
>> > >>
>> > >> [Shameless Author Plug]
>> > >> The Microsoft Office Web Components Black Book with .NET
>> > >> Now available @ www.lulu.com/owc, Amazon.com etc
>> > >> "Rouven Hertenstein" <RouvenHertenstein@xxxxxxxxxxxxxxxxxxxxxxxxx>
>> > >> wrote
>> > >> in
>> > >> message news:1B86BB31-A3A6-4BE9-AD05-48E98BCB060A@xxxxxxxxxxxxxxxx
>> > >> > Hi,
>> > >> >
>> > >> > I've created a webservice and the adapted
>> > >> > OWC11-windows-application
>> > >> > based
>> > >> > on
>> > >> > article
>> > >> > http://support.microsoft.com/default.aspx?scid=kb;en-us;315695
>> > >> >
>> > >> > It works really fine - incredible ;-)
>> > >> >
>> > >> > Now, I want to exercise it in the same way as a vb.net
>> > >> > web-application.
>> > >> > The
>> > >> > problem is to referencing to AxOWC11. So, it's impossible to
>> > >> > access
>> > >> > AxDataSourceControl1, AxPivotTable1 and so on.
>> > >> >
>> > >> > It seems that the web-application isn't able to work with the
>> > >> > windows
>> > >> > forms.
>> > >> > Though I've set a reference to System.Windows.Forms.dll
>> > >> >
>> > >> > Error in reasoning? Bad beginning? Wrong way? Or just a newbie?!
>> > >> >
>> > >> > Thanks for helping me!
>> > >> > Rouven
>> > >>
>> > >>
>> > >>
>> >
>> >
>> >


.

Quantcast