隨筆 - 100  文章 - 50  trackbacks - 0
          <2025年5月>
          27282930123
          45678910
          11121314151617
          18192021222324
          25262728293031
          1234567

          常用鏈接

          留言簿(3)

          隨筆分類

          隨筆檔案

          文章分類

          文章檔案

          收藏夾

          我收藏的一些文章!

          搜索

          •  

          最新評論

          閱讀排行榜

          評論排行榜

          .獲得系統時間:
          <%=now()%>
          2.取得來訪用的IP:
          <%=request.serverVariables("remote_host")%>
          3.獲得系統,瀏覽器版本:
          <script>
          window.document.write("版本:"+navigator.appName+navigator.appVersion+"?browser.")
          </script>
          4.去除IE混動條:
          <body?scroll="no">?
          <body?style="overflow-y:hidden">
          5.進入網站,跳出廣告:
          <script?language="javascript">
          <!--?
          <!--?注意更改文件所在路徑-->
          window.open(''http://www.XXXXXX.com&#39;','''',''height=200,width=300,top=0,left=30'');
          //?-->
          </script>
          6.隨機數:
          <%randomize%>
          <%=(int(rnd()*n)+1)%>
          N為可改變數
          7.向上混動代碼:
          <marquee?direction="up"?scrolldelay="200"?style="font-size:?9pt;?color:?#FF0000;?line-height:?150%;?font-style:italic;?font-weight:bold"?scrollamount="2"?width="206"?height="207"?bgcolor="#FFFF00">hhhhhhhhhhhhhhhhhhh</marquee>
          8.自動關閉網頁:
          <script?LANGUAGE="javascript">
          <!--
          setTimeout(''window.close();'',?10000);?//60秒后關閉
          //?-->
          </script>
          <p?align="center">本頁10秒后自動關閉,請注意刷新頁面</p>
          9.隨機背景音樂:
          <%randomize%>
          <bgsound?src="mids/<%=(int(rnd()*60)+1)%>.mid"?loop="-1"> 

          可以修改數字,限制調用個數,我這里是60個.
          10.自動刷新本頁面:
          <script>?
          <!--? 

          var?limit="0:10"? 

          if?(document.images){?
          var?parselimit=limit.split(":")?
          parselimit=parselimit?*60+parselimit?*1?
          }?
          function?beginrefresh(){?
          if?(!document.images)?
          return?
          if?(parselimit==1)?
          window.location.reload()?
          else{?
          parselimit-=1?
          curmin=Math.floor(parselimit/60)?
          cursec=parselimit%60?
          if?(curmin!=0)?
          curtime=curmin+"分"+cursec+"秒后重刷本頁!"?
          else?
          curtime=cursec+"秒后重刷本頁!"?
          window.status=curtime?
          setTimeout("beginrefresh()",1000)?
          }?
          }? 

          window.onload=beginrefresh?
          file://-->?
          </script>
          11.ACCESS數據庫連接:
          <%
          option?explicit
          dim?startime,endtime,conn,connstr,db
          startime=timer()
          '更改數據庫名字
          db="data/dvBBS5.mdb"
          Set?conn?=?Server.CreateObject("ADODB.Connection")
          connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data?Source="?&?Server.MapPath(db)
          '如果你的服務器采用較老版本Access驅動,請用下面連接方法
          'connstr="driver={Microsoft?Access?Driver?(*.mdb)};dbq="?&?Server.MapPath(db)
          conn.Open?connstr
          function?CloseDatabase
          Conn.close
          Set?conn?=?Nothing
          End?Function
          %>
          12.SQL數據庫連接:
          <%
          option?explicit
          dim?startime,endtime,conn,connstr,db
          startime=timer()
          connstr="driver={SQL?Server};server=HUDENQ-N11T33NB;uid=sa;pwd=xsfeihu;database=dvbbs"?
          Set?conn?=?Server.CreateObject("ADODB.Connection")
          conn.Open?connstr
          function?CloseDatabase
          Conn.close
          Set?conn?=?Nothing
          End?Function
          %>


          <%
          Response.Buffer?=?True
          On?Error?Resume?Next
          Set?conn?=?Server.CreateObject("ADODB.Connection")
          strCon?=?"Provider=SQLOLEDB.1;Persist?Security?Info=False;Server=218.84.205.199;User?ID=GD;Password=ABCD;Database=gddb;"
          conn.Open?strCon
          If?Err?Then
          err.Clear
          Set?Conn?=?Nothing
          Response.Write?"數據庫連接出錯,請檢查連接字串。"
          Response.End
          End?If
          function?CloseDatabase
          Conn.close
          Set?conn?=?Nothing
          End?Function
          %>?


          13.用鍵盤打開網頁代碼:
          <script?language="javascript">
          function?ctlent(eventobject)
          {
          if((event.ctrlKey?&&?window.event.keyCode==13)||(event.altKey?&&?window.event.keyCode==83))
          {
          window.open('網址','','')
          }
          }
          </script> 

          這里是Ctrl+Enter和Alt+S的代碼?自己查下鍵盤的ASCII碼再換就行
          14.讓層不被控件復蓋代碼:
          <div?z-Index:2><object?***></object></div>?#?前面?
          <div?z-Index:1><object?***></object></div>?#?后面?
          <div?id="Layer2"?style="position:absolute;?top:40;width:400px;?height:95px;z-index:2"><table?height=100%?width=100%?bgcolor="#ff0000"><tr><td?height=100%?width=100%></td></tr></table><iframe?width=0?height=0></iframe></div>
          <div?id="Layer1"?style="position:absolute;?top:50;width:200px;?height:115px;z-index:1"><iframe?height=100%?width=100%></iframe></div>
          15.動網FLASH廣告代碼:
          <object?classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000"?codebase="http://download.macromedia.com/pub/sho...h/swflash.cab#version=5?,0,0,0"?width="468"?height="60"><param?name=movie?value="images/yj16d.swf"><param?name=quality?value=high><embed?src="images/dvbanner.swf"?quality=high?pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"; ... uot;60"></embed></object>?
          16.VBS彈出窗口小代碼:
          <script?language=vbscript>
          msgbox"你還沒有注冊或登陸論壇","0","精品論壇"
          location.href?=?"login.asp"
          </script>
          16.使用FSO修改文件特定內容的函數
          function?FSOchange(filename,Target,String)
          Dim?objFSO,objCountFile,FiletempData
          Set?objFSO?=?Server.CreateObject("Scripting.FileSystemObject")
          Set?objCountFile?=?objFSO.OpenTextFile(Server.MapPath(filename),1,True)
          FiletempData?=?objCountFile.ReadAll
          objCountFile.Close
          FiletempData=Replace(FiletempData,Target,String)
          Set?objCountFile=objFSO.CreateTextFile(Server.MapPath(filename),True)
          objCountFile.Write?FiletempData?
          objCountFile.Close
          Set?objCountFile=Nothing
          Set?objFSO?=?Nothing
          End?Function
          17.使用FSO讀取文件內容的函數
          function?FSOFileRead(filename)
          Dim?objFSO,objCountFile,FiletempData
          Set?objFSO?=?Server.CreateObject("Scripting.FileSystemObject")
          Set?objCountFile?=?objFSO.OpenTextFile(Server.MapPath(filename),1,True)
          FSOFileRead?=?objCountFile.ReadAll
          objCountFile.Close
          Set?objCountFile=Nothing
          Set?objFSO?=?Nothing
          End?Function
          18.使用FSO讀取文件某一行的函數
          function?FSOlinedit(filename,lineNum)
          if?linenum?<?1?then?exit?function
          dim?fso,f,temparray,tempcnt
          set?fso?=?server.CreateObject("scripting.filesystemobject")
          if?not?fso.fileExists(server.mappath(filename))?then?exit?function
          set?f?=?fso.opentextfile(server.mappath(filename),1)
          if?not?f.AtEndofStream?then
          tempcnt?=?f.readall
          f.close
          set?f?=?nothing
          temparray?=?split(tempcnt,chr(13)&chr(10))
          if?lineNum>ubound(temparray)+1?then
          exit?function
          else
          FSOlinedit?=?temparray(lineNum-1)
          end?if
          end?if
          end?function
          19.使用FSO寫文件某一行的函數
          function?FSOlinewrite(filename,lineNum,Linecontent)
          if?linenum?<?1?then?exit?function
          dim?fso,f,temparray,tempCnt
          set?fso?=?server.CreateObject("scripting.filesystemobject")
          if?not?fso.fileExists(server.mappath(filename))?then?exit?function
          set?f?=?fso.opentextfile(server.mappath(filename),1)
          if?not?f.AtEndofStream?then
          tempcnt?=?f.readall
          f.close
          temparray?=?split(tempcnt,chr(13)&chr(10))
          if?lineNum>ubound(temparray)+1?then
          exit?function
          else
          temparray(lineNum-1)?=?lineContent
          end?if
          tempcnt?=?join(temparray,chr(13)&chr(10))
          set?f?=?fso.createtextfile(server.mappath(filename),true)
          f.write?tempcnt
          end?if
          f.close
          set?f?=?nothing
          end?function
          20.使用FSO添加文件新行的函數
          function?FSOappline(filename,Linecontent)
          dim?fso,f
          set?fso?=?server.CreateObject("scripting.filesystemobject")
          if?not?fso.fileExists(server.mappath(filename))?then?exit?function
          set?f?=?fso.opentextfile(server.mappath(filename),8,1)
          f.write?chr(13)&chr(10)&Linecontent
          f.close
          set?f?=?nothing
          end?function
          21.讀文件最后一行的函數
          function?FSOlastline(filename)
          dim?fso,f,temparray,tempcnt
          set?fso?=?server.CreateObject("scripting.filesystemobject")
          if?not?fso.fileExists(server.mappath(filename))?then?exit?function
          set?f?=?fso.opentextfile(server.mappath(filename),1)
          if?not?f.AtEndofStream?then
          tempcnt?=?f.readall
          f.close
          set?f?=?nothing
          temparray?=?split(tempcnt,chr(13)&chr(10))
          FSOlastline?=?temparray(ubound(temparray))
          end?if
          end?function
          利用FSO取得BMP,JPG,PNG,GIF文件信息(大小,寬、高等)
          <%
          ':::?BMP,?GIF,?JPG?and?PNG?::: 

          ':::?This?function?gets?a?specified?number?of?bytes?from?any?:::
          ':::?file,?starting?at?the?offset?(base?1)?:::
          ':::?:::
          ':::?Passed:?:::
          ':::?flnm?=>?Filespec?of?file?to?read?:::
          ':::?offset?=>?Offset?at?which?to?start?reading?:::
          ':::?bytes?=>?How?many?bytes?to?read?:::
          ':::?:::
          ':::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
          function?GetBytes(flnm,?offset,?bytes)
          Dim?objFSO
          Dim?objFTemp
          Dim?objTextStream
          Dim?lngSize
          on?error?resume?next
          Set?objFSO?=?CreateObject("Scripting.FileSystemObject") 

          '?First,?we?get?the?filesize
          Set?objFTemp?=?objFSO.GetFile(flnm)
          lngSize?=?objFTemp.Size
          set?objFTemp?=?nothing
          fsoForReading?=?1
          Set?objTextStream?=?objFSO.OpenTextFile(flnm,?fsoForReading)
          if?offset?>?0?then
          strBuff?=?objTextStream.Read(offset?-?1)
          end?if
          if?bytes?=?-1?then?'?Get?All!
          GetBytes?=?objTextStream.Read(lngSize)?'ReadAll
          else
          GetBytes?=?objTextStream.Read(bytes)
          end?if
          objTextStream.Close
          set?objTextStream?=?nothing
          set?objFSO?=?nothing
          end?function 

          ':::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
          ':::?:::
          ':::?Functions?to?convert?two?bytes?to?a?numeric?value?(long)?:::
          ':::?(both?little-endian?and?big-endian)?:::
          ':::?:::
          ':::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
          function?lngConvert(strTemp)
          lngConvert?=?clng(asc(left(strTemp,?1))?+?((asc(right(strTemp,?1))?*?256)))
          end?function
          function?lngConvert2(strTemp)
          lngConvert2?=?clng(asc(right(strTemp,?1))?+?((asc(left(strTemp,?1))?*?256)))
          end?function 

          ':::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
          ':::?:::
          ':::?This?function?does?most?of?the?real?work.?It?will?attempt?:::
          ':::?to?read?any?file,?regardless?of?the?extension,?and?will?:::
          ':::?identify?if?it?is?a?graphical?image.?:::
          ':::?:::
          ':::?Passed:?:::
          ':::?flnm?=>?Filespec?of?file?to?read?:::
          ':::?width?=>?width?of?image?:::
          ':::?height?=>?height?of?image?:::
          ':::?depth?=>?color?depth?(in?number?of?colors)?:::
          ':::?strImageType=>?type?of?image?(e.g.?GIF,?BMP,?etc.)?:::
          ':::?:::
          ':::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
          function?gfxSpex(flnm,?width,?height,?depth,?strImageType)
          dim?strPNG?
          dim?strGIF
          dim?strBMP
          dim?strType
          strType?=?""
          strImageType?=?"(unknown)"
          gfxSpex?=?False
          strPNG?=?chr(137)?&?chr(80)?&?chr(78)
          strGIF?=?"GIF"
          strBMP?=?chr(66)?&?chr(77)
          strType?=?GetBytes(flnm,?0,?3)
          if?strType?=?strGIF?then?'?is?GIF
          strImageType?=?"GIF"
          Width?=?lngConvert(GetBytes(flnm,?7,?2))
          Height?=?lngConvert(GetBytes(flnm,?9,?2))
          Depth?=?2?^?((asc(GetBytes(flnm,?11,?1))?and?7)?+?1)
          gfxSpex?=?True
          elseif?left(strType,?2)?=?strBMP?then?'?is?BMP
          strImageType?=?"BMP"
          Width?=?lngConvert(GetBytes(flnm,?19,?2))
          Height?=?lngConvert(GetBytes(flnm,?23,?2))
          Depth?=?2?^?(asc(GetBytes(flnm,?29,?1)))
          gfxSpex?=?True
          elseif?strType?=?strPNG?then?'?Is?PNG
          strImageType?=?"PNG"
          Width?=?lngConvert2(GetBytes(flnm,?19,?2))
          Height?=?lngConvert2(GetBytes(flnm,?23,?2))
          Depth?=?getBytes(flnm,?25,?2)
          select?case?asc(right(Depth,1))
          case?0
          Depth?=?2?^?(asc(left(Depth,?1)))
          gfxSpex?=?True
          case?2
          Depth?=?2?^?(asc(left(Depth,?1))?*?3)
          gfxSpex?=?True
          case?3
          Depth?=?2?^?(asc(left(Depth,?1)))?'8
          gfxSpex?=?True
          case?4
          Depth?=?2?^?(asc(left(Depth,?1))?*?2)
          gfxSpex?=?True
          case?6
          Depth?=?2?^?(asc(left(Depth,?1))?*?4)
          gfxSpex?=?True
          case?else
          Depth?=?-1
          end?select 

          else
          strBuff?=?GetBytes(flnm,?0,?-1)?'?Get?all?bytes?from?file
          lngSize?=?len(strBuff)
          flgFound?=?0
          strTarget?=?chr(255)?&?chr(216)?&?chr(255)
          flgFound?=?instr(strBuff,?strTarget)
          if?flgFound?=?0?then
          exit?function
          end?if
          strImageType?=?"JPG"
          lngPos?=?flgFound?+?2
          ExitLoop?=?false
          do?while?ExitLoop?=?False?and?lngPos?<?lngSize 

          do?while?asc(mid(strBuff,?lngPos,?1))?=?255?and?lngPos?<?lngSize
          lngPos?=?lngPos?+?1
          loop
          if?asc(mid(strBuff,?lngPos,?1))?<?192?or?asc(mid(strBuff,?lngPos,?1))?>?195?then
          lngMarkerSize?=?lngConvert2(mid(strBuff,?lngPos?+?1,?2))
          lngPos?=?lngPos?+?lngMarkerSize?+?1
          else
          ExitLoop?=?True
          end?if
          loop
          '
          if?ExitLoop?=?False?then
          Width?=?-1
          Height?=?-1
          Depth?=?-1
          else
          Height?=?lngConvert2(mid(strBuff,?lngPos?+?4,?2))
          Width?=?lngConvert2(mid(strBuff,?lngPos?+?6,?2))
          Depth?=?2?^?(asc(mid(strBuff,?lngPos?+?8,?1))?*?8)
          gfxSpex?=?True
          end?if 

          end?if
          end?function 

          ':::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
          ':::?Test?Harness?:::
          '::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: 

          '?To?test,?we'll?just?try?to?show?all?files?with?a?.GIF?extension?in?the?root?of?C:
          Set?objFSO?=?CreateObject("Scripting.FileSystemObject")
          Set?objF?=?objFSO.GetFolder("c:\")
          Set?objFC?=?objF.Files
          response.write?"<table?border=""0""?cellpadding=""5"">"
          For?Each?f1?in?objFC
          if?instr(ucase(f1.Name),?".GIF")?then
          response.write?"<tr><td>"?&?f1.name?&?"</td><td>"?&?f1.DateCreated?&?"</td><td>"?&?f1.Size?&?"</td><td>"
          if?gfxSpex(f1.Path,?w,?h,?c,?strType)?=?true?then
          response.write?w?&?"?x?"?&?h?&?"?"?&?c?&?"?colors"
          else
          response.write?"?"
          end?if
          response.write?"</td></tr>"
          end?if
          Next
          response.write?"</table>"
          set?objFC?=?nothing
          set?objF?=?nothing
          set?objFSO?=?nothing 

          %>
          24.點擊返回上頁代碼:
          <form>
          <p><input?TYPE="button"?value="返回上一步"?onCLICK="history.back(-1)"></p>
          </form>
          24.點擊刷新代碼:
          <form>
          <p><input?TYPE="button"?value="刷新按鈕一"?onCLICK="ReloadButton()"></p>
          </form>
          <script?language="javascript"><!--
          function?ReloadButton(){location.href="allbutton.htm";}
          //?--></script> 

          24.點擊刷新代碼2:
          <form>
          <p><input?TYPE="button"?value="刷新按鈕二"?onClick="history.go(0)">?</p>
          </form> 

          <form>
          <p><input?TYPE="button"?value="打開一個網站"?onCLICK="HomeButton()"></p>
          </form>
          <script?language="javascript"><!--
          function?HomeButton(){location.href="http://nettrain.126.com";;;?}
          //?--></script> 

          25.彈出警告框代碼:
          <form>
          <p><input?TYPE="button"?value="彈出警告框"?onCLICK="AlertButton()"></p>
          </form>
          <script?language="javascript"><!--
          function?AlertButton(){window.alert("要多多光臨呀!");}
          //?--></script> 

          26.狀態欄信息
          <form>
          <p><input?TYPE="button"?value="狀態欄信息"?onCLICK="StatusButton()"></p>
          </form>
          <script?language="javascript"><!--
          function?StatusButton(){window.status="要多多光臨呀!";}
          //?--></script> 

          27.背景色變換
          <form>
          <p><input?TYPE="button"?value="背景色變換"?onClick="BgButton()"></p>
          </form>
          <script>function?BgButton(){
          if?(document.bgColor=='#00ffff')
          {document.bgColor='#ffffff';}
          else{document.bgColor='#00ffff';}
          }
          </script> 

          28.點擊打開新窗口
          <form>
          <p><input?TYPE="button"?value="打開新窗口"?onCLICK="NewWindow()"></p>
          </form>
          <script?language="javascript"><!--
          function?NewWindow(){window.open("http://www.mcmx.com";;?,"","height=240,width=340,status=no,location=no,toolbar=no,directories=no,menubar=no");}
          //?--></script></body>
          29.分頁代碼:
          <%''本程序文件名為:Pages.asp%>
          <%''包含ADO常量表文件adovbs.inc,可從"\Program?Files\Common?Files\System\ADO"目錄下拷貝%>
          <!--#Include?File="adovbs.inc"-->
          <%''*建立數據庫連接,這里是Oracle8.05數據庫
          Set?conn=Server.CreateObject("ADODB.Connection")?
          conn.Open?"Provider=msdaora.1;Data?Source=YourSrcName;User?ID=YourUserID;Password=YourPassword;"? 

          Set?rs=Server.CreateObject("ADODB.Recordset")?''創建Recordset對象
          rs.CursorLocation=adUseClient?''設定記錄集指針屬性
          ''*設定一頁內的記錄總數,可根據需要進行調整?
          rs.PageSize=10? 

          ''*設置查詢語句?
          StrSQL="Select?ID,姓名,住址,電話?from?通訊錄?Order?By?ID"?
          rs.Open?StrSQL,conn,adOpenStatic,adLockReadOnly,adCmdText
          %>
          <HTML>
          <HEAD>
          <title>分頁示例</title>
          <script?language=javascript>
          //點擊"[第一頁]"時響應:
          function?PageFirst()
          {?
          document.MyForm.CurrentPage.selectedIndex=0;
          document.MyForm.CurrentPage.onchange();
          }
          //點擊"[上一頁]"時響應:
          function?PagePrior()
          {?
          document.MyForm.CurrentPage.selectedIndex--;
          document.MyForm.CurrentPage.onchange();
          }
          //點擊"[下一頁]"時響應:
          function?PageNext()
          {?
          document.MyForm.CurrentPage.selectedIndex++;
          document.MyForm.CurrentPage.onchange();?
          }
          //點擊"[最后一頁]"時響應:
          function?PageLast()
          {?
          document.MyForm.CurrentPage.selectedIndex=document.MyForm.CurrentPage.length-1;
          document.MyForm.CurrentPage.onchange();
          }
          //選擇"第?頁"時響應:
          function?PageCurrent()
          {?//Pages.asp是本程序的文件名
          document.MyForm.action='Pages.asp?Page='+(document.MyForm.CurrentPage.selectedIndex+1)
          document.MyForm.submit();
          }?
          </Script>
          </HEAD>
          <BODY?bgcolor="#ffffcc"?link="#008000"?vlink="#008000"?alink="#FF0000""> 

          <%IF?rs.Eof?THEN
          Response.Write("<font?size=2?color=#000080>[數據庫中沒有記錄!]</font>")
          ELSE?
          ''指定當前頁碼
          If?Request("CurrentPage")=""?Then
          rs.AbsolutePage=1
          Else
          rs.AbsolutePage=CLng(Request("CurrentPage"))
          End?If? 

          ''創建表單MyForm,方法為Get
          Response.Write("<form?method=Get?name=MyForm>")?
          Response.Write("<p?align=center><font?size=2?color=#008000>")
          ''設置翻頁超鏈接
          if?rs.PageCount=1?then?
          Response.Write("[第一頁]?[上一頁]?[下一頁]?[最后一頁]?")
          else?
          if?rs.AbsolutePage=1?then
          Response.Write("[第一頁]?[上一頁]?")
          Response.Write("[<a?href=java?script:PageNext()>下一頁</a>]?")?
          Response.Write("[<a?href=java?script:PageLast()>最后一頁</a>]?")?
          else?
          if?rs.AbsolutePage=rs.PageCount?then
          Response.Write("[<a?href=java?script:PageFirst()>第一頁</a>]?")?
          Response.Write("[<a?href=java?script:PagePrior()>上一頁</a>]?")?
          Response.Write("[下一頁]?[最后一頁]?")
          else
          Response.Write("[<a?href=java?script:PageFirst()>第一頁</a>]?")?
          Response.Write("[<a?href=java?script:PagePrior()>上一頁</a>]?")?
          Response.Write("[<a?href=java?script:PageNext()>下一頁</a>]?")?
          Response.Write("[<a?href=java?script:PageLast()>最后一頁</a>]?")?
          end?if
          end?if
          end?if 

          ''創建下拉列表框,用于選擇瀏覽頁碼
          Response.Write("第<select?size=1?name=CurrentPage?onchange=PageCurrent()>")?
          For?i=1?to?rs.PageCount?
          if?rs.AbsolutePage=i?then
          Response.Write("<option?selected>"&i&"</option>")?''當前頁碼
          else
          Response.Write("<option>"&i&"</option>")
          end?if?
          Next?
          Response.Write("</select>頁/共"&rs.PageCount&"頁?共"&rs.RecordCount&"條記錄</font><p>")?
          Response.Write("</form>") 

          ''創建表格,用于顯示
          Response.Write("<table?align=center?cellspacing=1?cellpadding=1?border=1")?
          Response.Write("?bordercolor=#99CCFF?bordercolordark=#b0e0e6?bordercolorlight=#000066>") 

          Response.Write("<tr?bgcolor=#ccccff?bordercolor=#000066>")? 

          Set?Columns=rs.Fields? 

          ''顯示表頭
          For?i=0?to?Columns.Count-1
          Response.Write("<td?align=center?width=200?height=13>")
          Response.Write("<font?size=2><b>"&Columns(i).name&"</b></font></td>")?
          Next
          Response.Write("</tr>")
          ''顯示內容
          For?i=1?to?rs.PageSize?
          Response.Write("<tr?bgcolor=#99ccff?bordercolor=#000066>")?
          For?j=0?to?Columns.Count-1?
          Response.Write("<td><font?size=2>"&Columns(j)&"</font></td>")?
          Next
          Response.Write("</tr>") 

          rs.movenext?
          if?rs.EOF?then?exit?for?
          Next 

          Response.Write("</table>")? 

          END?IF
          %>
          </BODY>
          </HTML>
          posted on 2006-08-11 08:47 fly 閱讀(270) 評論(0)  編輯  收藏 所屬分類: ASP學習
          主站蜘蛛池模板: 四子王旗| 三都| 五原县| 临沂市| 泸西县| 资源县| 银川市| 浮山县| 岚皋县| 班玛县| 柳江县| 南漳县| 锦州市| 喜德县| 长葛市| 隆林| 四会市| 怀安县| 建瓯市| 徐水县| 商丘市| 芦山县| 贺兰县| 山东省| 博罗县| 静乐县| 青田县| 建始县| 文昌市| 娄底市| 保靖县| 高州市| 开封县| 资溪县| 当涂县| 佛学| 阿拉善盟| 西乌| 永善县| 沁阳市| 巴林右旗|