Thank you for the answer. But, I got this theoretical information already on
myself. So, I have just no idea to execute it to this example:
Imports System.Web
Imports System.Xml
Imports System.Xml.Xsl
Imports System.Data
Imports System.Data.SqlClient
Public Class MakeData
Implements IHttpHandler
Public ReadOnly Property IsReusable() As Boolean _
Implements IHttpHandler.IsReusable
Get
Return False
End Get
End Property
Public Sub ProcessRequest(ByVal context As HttpContext) _
Implements IHttpHandler.ProcessRequest
Dim sConn As String = "User ID=sa;Password=;Initial
Catalog=Northwind;Data Source=ibf-server;"
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"
'Connect to the data source.
Dim nwindConn As SqlConnection = New SqlConnection(sConn)
nwindConn.Open()
'Build a dataSet for Employee Sales.
Dim ds As DataSet
ds = New DataSet("MyDataset")
Dim da As SqlDataAdapter = New SqlDataAdapter(sSQL, nwindConn)
da.Fill(ds)
'Transform the dataSet using the stylesheet.
Dim xmlDoc_ds As XmlDataDocument = New XmlDataDocument(ds)
Dim xslTran As XslTransform = New XslTransform
xslTran.Load(context.Server.MapPath("Rowset.xslt") )
'Return the persisted recordset.
context.Response.ContentType = "text/xml"
context.Response.Charset = ""
xslTran.Transform(xmlDoc_ds, Nothing, context.Response.Output)
End Sub
End Class
"Oleg Tkachenko [MVP]" wrote:
Rouven Hertenstein wrote:
I'm trying to test the vb.net-exercise "How to use a DataSet with the Office
XP Chart Component and ASP.NET" on
http://support.microsoft.com/kb/303016/en-us
Visual Studio rails against the expression:
"xslTran.Transform(xmlDoc_ds, Nothing, context.Response.Output)"
and comments:
"Public Sub Transform(input As System.Xml.XPath.IXPathNavigable, args As
System.Xml.Xsl.XsltArgumentList, output As System.IO.TextWriter)" is
obsolete: "you should pass XmlResolver to Transform() method"
Sorry, but that's an untasted field for me. Please tell me, what to do.
Those are .NET 1.1 chages. Pass new XmlUrlResolver() as a fourth argument.
--
Oleg Tkachenko [XML MVP, MCAD]
http://blog.tkachenko.com
