M
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
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