台灣最大程式設計社群網站
線上人數
1254
 
會員總數:246203
討論主題:189776
歡迎您免費加入會員
討論區列表 >> ASP >> 請問要如何化折線圖
[]  
[我要回覆]
1
回應主題 加入我的關注話題 檢舉此篇討論 將提問者加入個人黑名單
請問要如何化折線圖
價值 : 100 QP  點閱數:924 回應數:1
樓主

Nice
門外漢
0 8
583 11
發送站內信

請問若要由SQL資料庫將傳回欄位值,用折線圖顯示:有無範例可套用:
<%
a=0
while not dg_rs.eof
a=a+1
%>
<table x:str border="0" cellpadding="0" cellspacing="0" style="border:1px solid #000000; border-collapse:collapse;width:850px" id="table1" height="45">
<colgroup>
<col width="42" style="width: 32pt">
<col width="64" span="2" style="width:48pt">
<col width="64" span="2" style="width:48pt">
<col width="86" style="width: 64pt">
<col width="86" style="width: 64pt">
<col width="71" style="width: 53pt">
<col width="78" style="width: 58pt">
<col width="109" style="width: 82pt">
</colgroup>
<tr height="22" style="height:16.8pt">
<td style="width: 35px; font-size: 10.0pt; text-align: left; color: windowtext; font-weight: 400; font-style: normal; text-decoration: none; font-family: 新細明體, serif; vertical-align: middle; white-space: nowrap; border-left: 1.0pt solid windowtext; border-right: .5pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 1px; padding-right: 1px; padding-top: 1px; background: #FFFFFF">
<%=A%></td>
<td style="width: 92px; font-size: 10.0pt; text-align: left; color: windowtext; font-weight: 400; font-style: normal; text-decoration: none; font-family: 新細明體, serif; vertical-align: middle; white-space: nowrap; border-left: medium none; border-right: .5pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 1px; padding-right: 1px; padding-top: 1px; background: #FFFF00" height="37">
<%=(dg_rs("aaa"))%></td>
<td style="width: 91px; font-size: 10.0pt; text-align: left; color: windowtext; font-weight: 400; font-style: normal; text-decoration: none; font-family: 新細明體, serif; vertical-align: middle; white-space: nowrap; border-left: medium none; border-right: .5pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 1px; padding-right: 1px; padding-top: 1px; background: #FFFFFF; " height="37">
<%=(dg_rs("bbb"))%></td>
<td style="width: 121px; font-size: 10.0pt; text-align: left; color: windowtext; font-weight: 400; font-style: normal; text-decoration: none; font-family: 新細明體, serif; vertical-align: middle; white-space: nowrap; border-left: medium none; border-right: .5pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 1px; padding-right: 1px; padding-top: 1px; background: #FFFFFF; " height="37">
<%=(dg_rs("ccc"))%></td>
<td style="width: 121px; font-size: 10.0pt; text-align: left; color: windowtext; font-weight: 400; font-style: normal; text-decoration: none; font-family: 新細明體, serif; vertical-align: middle; white-space: nowrap; border-left: medium none; border-right: .5pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 1px; padding-right: 1px; padding-top: 1px; background: #FFFFFF; " height="37">
<%=(dg_rs("ddd"))%></td>
<td style="width: 97px; font-size: 10.0pt; text-align: left; color: windowtext; font-weight: 400; font-style: normal; text-decoration: none; font-family: 新細明體, serif; vertical-align: middle; white-space: nowrap; border-left: medium none; border-right: .5pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 1px; padding-right: 1px; padding-top: 1px; background: #FFFFFF; " height="37">
<%=(dg_rs("eee"))%></td>
<td style="width: 88px; font-size: 10.0pt; text-align: left; color: windowtext; font-weight: 400; font-style: normal; text-decoration: none; font-family: 新細明體, serif; vertical-align: middle; white-space: nowrap; border-left: medium none; border-right: .5pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 1px; padding-right: 1px; padding-top: 1px; background: #FFFFFF; " height="37">
<%=(dg_rs("fff"))%></td>
<td style="width: 95px; font-size: 10.0pt; text-align: left; color: windowtext; font-weight: 400; font-style: normal; text-decoration: none; font-family: 新細明體, serif; vertical-align: middle; white-space: nowrap; border-left: medium none; border-right: .5pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 1px; padding-right: 1px; padding-top: 1px; background: #FFFFFF; " height="37">
<%=(dg_rs("ggg"))%></td>
<td style="width: 190px; font-size: 10.0pt; text-align: left; color: windowtext; font-weight: 400; font-style: normal; text-decoration: none; font-family: 新細明體, serif; vertical-align: middle; white-space: nowrap; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 1px; padding-right: 1px; padding-top: 1px; background: #FFFFFF; " height="37">
<a href="javascript:;" onclick="window.open('report1.asp?stuff_id=<%=dg_rs("no")%>');return false;"><img border="0" src="../images/fOLDER.gif" width="22" height="20"></td>
</tr>
</table>
<% dg_rs.movenext
wend %>
</table>







搜尋相關Tags的文章: [ ASP圖表 ] ,
本篇文章發表於2015-11-09 17:20
1樓
最有價值解答

Daimom
捐贈 VP 給 Daimom 檢舉此回應
Google chart
本篇文章回覆於2015-11-10 12:18
== 簽名檔 ==
--未登入的會員無法查看對方簽名檔--
   
1

回覆
如要回應,請先登入.