精品秘无码一区二区三区老师-精品秘一区二三区免费雷安-精品蜜桃秘一区二区三区-精品蜜桃秘一区二区三区粉嫩-精品蜜桃一区二区三区-精品蜜臀国产aⅴ一区二区三区

[p]　　我們工作中經常需要將數據轉化成柱狀圖，餅圖等，以方便直觀的分析數據， 這里給大家介紹一個asp中制作餅圖、柱狀圖的組件：csdrawgraph，csdgt.zip,因為是組件，所以我們在使用之前需要用regsvr32.exe 注冊一下，csdrawgraph，可以在asp中創建餅圖，柱狀圖以及線圖，其支持的格式有gif, png, jpg and bmp.[/p] [p]　　看看如下的柱狀圖，餅圖如何生成的例子：[/p] [p][align=center][img]http://ninedns.com/images/tech/images/a4215_img200748_1.jpg[/img][/align][/p] [p][br]chartdemo.asp[/p] <%@ language=vbscript %>[br][br][br][br][br][br]

this simple demonstration shows two graphs using the same data. the first is [br]a bar chart:

[br]

[br]

[br]

the second is a pie chart. the background colour is set to light [br]grey to show the overall size of the image.

[br]

[br]

[br][br] [p]chartimages.asp[/p] [p]<%@ language=vbscript %>[/p] [p]<%[br]response.expires = 0[br]response.buffer = true[br]response.clear [br]response.contenttype = "image/gif"[/p] [p]set chart = server.createobject("csdrawgraphtrial.draw")[/p] [p][br]chart.adddata "no> 1", 17, "ff0000"[br]chart.adddata "no> 2", 28, "00ff00"[br]chart.adddata "no> 3", 5, "0000ff"[/p] [p]if request.querystring("type") = "pie" then[br] chart.title = "sample pie chart"[br] chart.bgcolor = "eeeeee"[br] chart.labelbgcolor = "eeeeee"[br] chart.titlebgcolor = "eeeeee"[br] response.binarywrite chart.gifpie[br]else[br] chart.title = "sample bar chart"[br] response.binarywrite chart.gifbar[br]end if[/p] [p]response.end[br]%>[/p][br]程序很簡單，再些不詳細說明，下面看一個將[url=http://ninedns.com/webhosting/mssql.asp]數據庫[/url]中的數據轉換到圖表的例子： [p][/p] [p]lines.asp:[/p] [p][br][br][/p] [p][/p] [p][br][br][br][br]

links to the other result pages:

[br]

bar chart showing all results for any one day.

[br]

bar charts showing results for each colour separately.

[br][br][/p] [p]gif_lines.asp:[/p] [p]<%@ language=vbscript %>[br]<%[br]'利用[url=http://ninedns.com/webhosting/mssql.asp]數據庫[/url]中的數據生成線圖。[br]'根據4個不同的值分別生成4條線。[br]'在x軸上顯示星期的名稱。[/p] [p]response.expires = 0[br]response.buffer = true[br]response.clear[/p] [p] '利用下面的語句創建chart對象，版本不同會有所差異。[br]'set chart = server.createobject("csdrawgraph.draw")[br]set chart = server.createobject("csdrawgraphtrial.draw")[/p] [p]connectionstring = "provider=microsoft.jet.oledb.4.0;data source=" & _ [br] server.mappath("data.mdb")[br]set dbconn = server.createobject("adodb.connection")[br]dbconn.open connectionstring[br]set rs = server.createobject("adodb.recordset")[br]sql = "select * from table1 order by day"[br]rs.open sql, dbconn[/p] [p] while not rs.eof[br] chart.addpoint cint(rs("day")), cint(rs("red")), "ff0000", "red"[br] chart.addpoint cint(rs("day")), cint(rs("blue")), "0000ff", "blue"[br] chart.addpoint cint(rs("day")), cint(rs("green")), "00ff00", "green"[br] chart.addpoint cint(rs("day")), cint(rs("yellow")), "ffff00", "yellow"[br] chart.addxvalue cint(rs("day")), rs("dayname")[br] rs.movenext[br] wend[/p] [p]'關閉[url=http://ninedns.com/webhosting/mssql.asp]數據庫[/url]連接[br]rs.close[br]dbconn.close[/p] [p]'下面設置組件屬性[br]'x軸坐標從1開始而不是0。(xoffset = 1)[br][br]chart.title = "all the combined results"[br]chart.titlex = 100[br]chart.yaxistext = "total for each day"[br]chart.originy = 220[br]chart.xoffset = 1[br]chart.xtop = 7[br]chart.xgrad = 1[br]chart.usexaxislabels = true[br]chart.linewidth = 2[br]chart.pointsize = 3[br]chart.pointstyle = 1[/p] [p]'最后圖片以gif格式發送到瀏覽器[br]response.contenttype = "image/gif"[br]response.binarywrite chart.gifline[br]response.end[br]%>[/p] [p]結果如圖所示：[/p] [p][align=center][img]http://ninedns.com/images/tech/images/a4215_img200748_2.gif[/img][/align][/p] [p]csdrawgraph的下載地址：http://chestysoft.com/download/csdgt.zip[/p]