Using Office XP Web Components in ASP.NET

[mehul]

Hi,

I am trying to use Microsoft Office Web components in my asp.net
applicaion.

Actually i want to use the chart and came accross some sample code
in MSDN (Kb:Use a DataSet with the Office XP Chart Component and
ASP.NET)
[PSS ID Number: 303016].
I am using the 2nd example 'Use Literal Data' which works fine by
itself.
However when i modify

Dim sSQL As String = _
"SELECT LastName, Sum([UnitPrice]*[Quantity]*(1-[Discount])) AS
OrderTotal " & _
"FROM Employees INNER JOIN (Orders INNER JOIN [Order Details] ON " &
_
"Orders.OrderID = [Order Details].OrderID) ON Employees.EmployeeID =
" & _
"Orders.EmployeeID GROUP BY LastName"
to my own query:

Dim sConn As String = "User ID=sa;Password=ketna;Initial
Catalog=HelpdeskCL;Data Source=MS;"

Dim sSQL As String = _
"SELECT COUNT(PaymentMethod) AS Total, PaymentMethod FROM
helpdesk_info " & _
" GROUP BY PaymentMethod"
when i click the 'Chart Data' button on the asp.net form (after running
it) - nothing happens.

After some investigation i came across something called 'dsXML' - and
below is the copied
explation given by the MSDN article:

"Note that an XML data island with the ID "dsXML" exists in the HTML
source; the data island was generated by the code in the Page_Load event
of the Web form"
what do i need to change so that i can display my chart data correctly?

Thks,
Mehul
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Alvin Bruney [MVP]]

You will get more specialized help on
microsoft.public.office.developer.web.components

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"mehul" <me*@computech.co.ke> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

Hi,

I am trying to use Microsoft Office Web components in my asp.net
applicaion.

Actually i want to use the chart and came accross some sample code
in MSDN (Kb:Use a DataSet with the Office XP Chart Component and
ASP.NET)
[PSS ID Number: 303016].
I am using the 2nd example 'Use Literal Data' which works fine by
itself.
However when i modify

Dim sSQL As String = _
"SELECT LastName, Sum([UnitPrice]*[Quantity]*(1-[Discount])) AS
OrderTotal " & _
"FROM Employees INNER JOIN (Orders INNER JOIN [Order Details] ON " &
_
"Orders.OrderID = [Order Details].OrderID) ON Employees.EmployeeID =
" & _
"Orders.EmployeeID GROUP BY LastName"
to my own query:

Dim sConn As String = "User ID=sa;Password=ketna;Initial
Catalog=HelpdeskCL;Data Source=MS;"

Dim sSQL As String = _
"SELECT COUNT(PaymentMethod) AS Total, PaymentMethod FROM
helpdesk_info " & _
" GROUP BY PaymentMethod"
when i click the 'Chart Data' button on the asp.net form (after running
it) - nothing happens.

After some investigation i came across something called 'dsXML' - and
below is the copied
explation given by the MSDN article:

"Note that an XML data island with the ID "dsXML" exists in the HTML
source; the data island was generated by the code in the Page_Load event
of the Web form"
what do i need to change so that i can display my chart data correctly?

Thks,
Mehul
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!