.獲得系統(tǒng)時(shí)間:
<%=now()%>
2.取得來(lái)訪用的IP:
<%=request.serverVariables("remote_host")%>
3.獲得系統(tǒng),瀏覽器版本:
<script>
window.document.write("版本："+navigator.appName+navigator.appVersion+"?browser.")
</script>
4.去除IE混動(dòng)條:
<body?scroll="no">?
<body?style="overflow-y:hidden">
5.進(jìn)入網(wǎng)站,跳出廣告:
<script?language="javascript">
<!--?
<!--?注意更改文件所在路徑-->
window.open(''http://www.XXXXXX.com&#39;','''',''height=200,width=300,top=0,left=30'');
//?-->
</script>
6.隨機(jī)數(shù):
<%randomize%>
<%=(int(rnd()*n)+1)%>
N為可改變數(shù)
7.向上混動(dòng)代碼:
<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.自動(dòng)關(guān)閉網(wǎng)頁(yè):
<script?LANGUAGE="javascript">
<!--
setTimeout(''window.close();'',?10000);?//60秒后關(guān)閉
//?-->
</script>
<p?align="center">本頁(yè)10秒后自動(dòng)關(guān)閉,請(qǐng)注意刷新頁(yè)面</p>
9.隨機(jī)背景音樂(lè):
<%randomize%>
<bgsound?src="mids/<%=(int(rnd()*60)+1)%>.mid"?loop="-1">　

可以修改數(shù)字，限制調(diào)用個(gè)數(shù)，我這里是６０個(gè)．
10.自動(dòng)刷新本頁(yè)面:
<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+"秒后重刷本頁(yè)！"?
else?
curtime=cursec+"秒后重刷本頁(yè)！"?
window.status=curtime?
setTimeout("beginrefresh()",1000)?
}?
}?　

window.onload=beginrefresh?
file://-->?
</script>
11.ACCESS數(shù)據(jù)庫(kù)連接:
<%
option?explicit
dim?startime,endtime,conn,connstr,db
startime=timer()
'更改數(shù)據(jù)庫(kù)名字
db="data/dvBBS5.mdb"
Set?conn?=?Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data?Source="?&?Server.MapPath(db)
'如果你的服務(wù)器采用較老版本Access驅(qū)動(dòng)，請(qǐng)用下面連接方法
'connstr="driver={Microsoft?Access?Driver?(*.mdb)};dbq="?&?Server.MapPath(db)
conn.Open?connstr
function?CloseDatabase
Conn.close
Set?conn?=?Nothing
End?Function
%>
12.SQL數(shù)據(jù)庫(kù)連接:
<%
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?"數(shù)據(jù)庫(kù)連接出錯(cuò)，請(qǐng)檢查連接字串。"
Response.End
End?If
function?CloseDatabase
Conn.close
Set?conn?=?Nothing
End?Function
%>?


13.用鍵盤(pán)打開(kāi)網(wǎng)頁(yè)代碼:
<script?language="javascript">
function?ctlent(eventobject)
{
if((event.ctrlKey?&&?window.event.keyCode==13)||(event.altKey?&&?window.event.keyCode==83))
{
window.open('網(wǎng)址','','')
}
}
</script>　

這里是Ctrl+Enter和Alt+S的代碼?自己查下鍵盤(pán)的ASCII碼再換就行
14.讓層不被控件復(fù)蓋代碼:
<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.動(dòng)網(wǎng)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"你還沒(méi)有注冊(cè)或登陸論壇","0","精品論壇"
location.href?=?"login.asp"
</script>
16.使用FSO修改文件特定內(nèi)容的函數(shù)
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讀取文件內(nèi)容的函數(shù)
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讀取文件某一行的函數(shù)
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寫(xiě)文件某一行的函數(shù)
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添加文件新行的函數(shù)
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.讀文件最后一行的函數(shù)
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.點(diǎn)擊返回上頁(yè)代碼:
<form>
<p><input?TYPE="button"?value="返回上一步"?onCLICK="history.back(-1)"></p>
</form>
24.點(diǎn)擊刷新代碼:
<form>
<p><input?TYPE="button"?value="刷新按鈕一"?onCLICK="ReloadButton()"></p>
</form>
<script?language="javascript"><!--
function?ReloadButton(){location.href="allbutton.htm";}
//?--></script>　

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

<form>
<p><input?TYPE="button"?value="打開(kāi)一個(gè)網(wǎng)站"?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.狀態(tài)欄信息
<form>
<p><input?TYPE="button"?value="狀態(tài)欄信息"?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.點(diǎn)擊打開(kāi)新窗口
<form>
<p><input?TYPE="button"?value="打開(kāi)新窗口"?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.分頁(yè)代碼:
<%''本程序文件名為：Pages.asp%>
<%''包含ADO常量表文件adovbs.inc，可從"\Program?Files\Common?Files\System\ADO"目錄下拷貝%>
<!--#Include?File="adovbs.inc"-->
<%''＊建立數(shù)據(jù)庫(kù)連接，這里是Oracle8.05數(shù)據(jù)庫(kù)
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")?''創(chuàng)建Recordset對(duì)象
rs.CursorLocation=adUseClient?''設(shè)定記錄集指針屬性
''＊設(shè)定一頁(yè)內(nèi)的記錄總數(shù)，可根據(jù)需要進(jìn)行調(diào)整?
rs.PageSize=10?　

''＊設(shè)置查詢語(yǔ)句?
StrSQL="Select?ID,姓名,住址,電話?from?通訊錄?Order?By?ID"?
rs.Open?StrSQL,conn,adOpenStatic,adLockReadOnly,adCmdText
%>
<HTML>
<HEAD>
<title>分頁(yè)示例</title>
<script?language=javascript>
//點(diǎn)擊"[第一頁(yè)]"時(shí)響應(yīng)：
function?PageFirst()
{?
document.MyForm.CurrentPage.selectedIndex=0;
document.MyForm.CurrentPage.onchange();
}
//點(diǎn)擊"[上一頁(yè)]"時(shí)響應(yīng)：
function?PagePrior()
{?
document.MyForm.CurrentPage.selectedIndex--;
document.MyForm.CurrentPage.onchange();
}
//點(diǎn)擊"[下一頁(yè)]"時(shí)響應(yīng)：
function?PageNext()
{?
document.MyForm.CurrentPage.selectedIndex++;
document.MyForm.CurrentPage.onchange();?
}
//點(diǎn)擊"[最后一頁(yè)]"時(shí)響應(yīng)：
function?PageLast()
{?
document.MyForm.CurrentPage.selectedIndex=document.MyForm.CurrentPage.length-1;
document.MyForm.CurrentPage.onchange();
}
//選擇"第？頁(yè)"時(shí)響應(yīng)：
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>[數(shù)據(jù)庫(kù)中沒(méi)有記錄！]</font>")
ELSE?
''指定當(dāng)前頁(yè)碼
If?Request("CurrentPage")=""?Then
rs.AbsolutePage=1
Else
rs.AbsolutePage=CLng(Request("CurrentPage"))
End?If?　

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

''創(chuàng)建下拉列表框，用于選擇瀏覽頁(yè)碼
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>")?''當(dāng)前頁(yè)碼
else
Response.Write("<option>"&i&"</option>")
end?if?
Next?
Response.Write("</select>頁(yè)/共"&rs.PageCount&"頁(yè)?共"&rs.RecordCount&"條記錄</font><p>")?
Response.Write("</form>")　

''創(chuàng)建表格，用于顯示
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>")
''顯示內(nèi)容
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>