<% @ Language = VBScript %>
<HTML>
<HEAD>
<Meta name = "GENERATOR" Content = "Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<OBJECT classid = "clsid: 3a2b370c-ba0a-11d1-b137-109f8753f5d"
Id = MSChart1 style = "LEFT: 0px; TOP: 0px" VIEWASTEXT height = 300 width = 300> </OBJECT>
<Script language = "VBScript">
<%
Set objConn = Server. CreateObject ("ADODB. Connection ")
Objconn. ConnectionString = "DSN = AdvWorks"
ObjConn. Open
Set objRS = Server. CreateObject ("ADODB. Recordset ")
ObjRS. ActiveConnection = objConn
ObjRS. CursorLocation = 3
ObjRS. Open ("select OrderDetailID, UnitPrice from Order_Details ")
I = 1
Response. Write "Const num =" & objrs. RecordCount & vbCr
Response. Write "Dim ID (" & objrs. RecordCount & ")" & vbCr
Response. Write "Dim Details (" & objrs. RecordCount & ")" & vbCr
Do While Not objRS. EOF
Response. Write ("ID (" & I & ") =" & objRS (0) & "& Chr (13 ))
Response. Write ("Details (" & I & ") =" & objRS (1) & "& Chr (13 ))
I = I + 1
ObjRS. MoveNext
Loop
%>
MSChart1.TitleText = "Example"
MSChart1.RowCount = 1
MSChart1.ColumnCount = num
For I = 1 to num
MSChart1.Column = I
MSChart1.ColumnLabel = ID (I)
Next
MSChart1.chartType = 14' 14 is a two-dimensional pie chart. I still don't know how to draw the curve.
MSChart1.ShowLegend = True
MSChart1.ChartData = Details
</SCRIPT>
</BODY>
</HTML>