Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ASPÊý¾ÝÁ¬½Ó

1. ÓÃDSNÁ¬½Ó²¢ÇÒûÓÐÓû§ÃûºÍÃÜÂ룺
<%
set conn = Server.CreateObject("ADODB.Connection")
conn.open "YourDSNName"
%>
ÓÃDSNÁ¬½Ó²¢ÇÒÓÐÓû§ÃûºÍÃÜÂ룺
<%
set conn = Server.CreateObject("ADODB.Connection")
conn.open "YourDSNName","username","password"
%>
2. ÓÃʵ¼ÊµÄÊý¾Ý¿â¾ø¶Ô·¾¶Á¬½Ó£º
<%
Set conn = Server.CreateObject("ADODB.Connection")
Strconn="DRIVER={Microsoft Access Driver (*.mdb)}; "
Strconn=Strconn & "DBQ=e:\yanhang\database.mdb"
conn.Open Strconn
%>
ÓÃʵ¼ÊµÄÊý¾Ý¿âÏà¶Ô·¾¶Á¬½Ó£º
"provider=microsoft.jet.OLEDB.4.0;Data source="&server.mappath("/admin/#Database.mdb")
<%
Set conn = Server.CreateObject("ADODB.Connection")
Strconn="DRIVER={Microsoft Access Driver (*.mdb)}; "
Strconn=Strconn & "DBQ=" & Server.MapPath("/database/yanhang.mdb")
conn.Open Strconn
%>
¶þ¡¢MS SQL ServerÊý¾Ý¿âÁ¬½Ó
ÓÃDSNÁ¬½Ó£º
<%
set conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN=MyDSN;UID=user;PWD=password;DATABASE=databasename"
%>
²»ÓÃDSNÁ¬½Ó£º
<%
Set conn = Server.CreateObject("ADODB.Connection")
DSNtemp="DRIVER={SQL Server};SERVER=ServerName;UID=USER;PWD=password;DATABASE=databasename"
conn.open DSNtemp
%>
Èý¡¢FoxProÊý¾Ý¿âÁ¬½Ó
<%
Set Conn = Server.CreateObject("ADODB.connection")
ConnStr= "Driver=Microsoft Visual Foxpro Driver; UID=userID;SourceType=DBC;SourceDB=C:\yanhang\database.dbc"
Conn.Open ConnStr
%>
ËÄ¡¢OracleÊý¾Ý¿âÁ¬½Ó£º
<%
set conn=server.createobject("adodb.connection")
conn.cursorlocation=adUseClient
DSNTemp="Provider=MSDAORA.1;Password=xxxxx;User ID=yanhang;Data Source=xxx.world"
conn.open DSNtemp
%>
 


Ïà¹ØÎĵµ£º

ASPÓë´æ´¢¹ý³Ì


ASPÓë´æ´¢¹ý³Ì
ASPÓë´æ´¢¹ý³Ì(Stored Procedures)µÄÎÄÕ²»ÉÙ£¬µ«ÊÇÎÒ»³ÒÉ×÷ÕßÃÇÊÇ·ñÕæÕýʵ¼ù¹ý¡£ÎÒÔÚ³õѧʱ²éÔĹý´óÁ¿Ïà¹Ø×ÊÁÏ£¬·¢ÏÖÆäÖÐÌṩµÄºÜ¶à·½·¨Êµ¼Ê²Ù×÷ÆðÀ´²¢²»ÊÇÄÇô»ØÊ¡£¶ÔÓÚ¼òµ¥µÄÓ¦Óã¬ÕâЩ×ÊÁÏÒ²ÐíÊÇÓаïÖúµÄ£¬µ«½öÏÞÓÚ´Ë£¬ÒòΪËüÃǸù±¾¾ÍÊÇǧƪһÂÉ£¬»¥Ïà³­Ï®£¬ÉÔ΢¸´ÔÓµãµÄÓ¦Ó㬾ÍÈ«¶¼ÓïÑɲ»ÏêÁË ......

ASPÈëÃÅÓëʵÀý


1¡¢ÔËÐл·¾³ÓëÈí¼þÒªÇó
Windows 2000 ÒÔÉÏ £¨²»°üÀ¨Windows XP Home°æ£©
IIS 4.0 ÒÔÉÏ
Microsoft Access 2000
Dreamweaver MX
2¡¢IISµÄ°²×°ÓëÅäÖÃ
a.°²×°IIS
Èô²Ù×÷ϵͳÖл¹Î´°²×°IIS·þÎñÆ÷£¬¿É´ò¿ª“¿ØÖÆÃæ°å”£¬È»ºóµ¥»÷Æô¶¯ “Ìí¼Ó/ɾ³ý³ÌÐò”£¬ ÔÚµ¯³öµÄ¶Ô»°¿òÖÐÑ¡Ôñ “Ìí¼Ó/ɾ³ýWi ......

iisÎÞ·¨ä¯ÀÀaspÎļþ½â¾ö·½·¨

Ò»´óÔçÆðÀ´×°IIS¡£ÏÖÔÚÖÕÓÚ×°ºÃÁË¡£Ê®·Ö¸ÐлÒÔϵIJ©ÎÄ£¬ÌØ×ª¹ýÀ´·ÖÏí :)
תÖÁ£ºhttp://blog.sina.com.cn/s/blog_50070c4c0100bkq6.html
ÿÿװIIS£¬×Ü»áÅöµ½ÕâÑùÄÇÑùµÄÎÊÌ⣬´ÓĿǰ·´Ó¦Çé¿öÀ´¿´£¬IIS°²×°ºó¿Éä¯ÀÀHTML¾²Ì¬Îļþ£¬È´ÎÞ·¨ä¯ÀÀaspΪºó׺µÄ¶¯Ì¬Ò³Ãæ¡£
    ͨ¹ý¼¸´Îµ÷ÊÔºó£¬ÕÒµ½ÒÔϼ¸ÖÖ·½·¨£ ......

asp ʵÏÖµÄðÅÝÅÅÐò³ÌÐò

 arr = array(12,52,14,43,24,58,15,64,24,57,17,56,45)
arrLen = ubound(arr)
for i=0 to arrLen-1
for j = 0 to (arrlen -1)-i
if arr(j)>arr(j+1) then
temp = arr(j)
arr(j)= arr(j+1)
arr(j+1) = temp
end if
next
next

for each l in arr
response.Write l&"< ......

ASPÄÚÖöÔÏó

 Ò»¡¢Request ¶ÔÏó
¿ÉÒÔʹÓà Request ¶ÔÏó·ÃÎÊÈκλùÓÚ HTTP ÇëÇ󴫵ݵÄËùÓÐÐÅÏ¢£¬°üÀ¨´Ó HTML ±í¸ñÓà POST ·½·¨»ò GET ·½·¨´«µÝµÄ²ÎÊý¡¢cookie ºÍÓû§ÈÏÖ¤¡£
Request[.¼¯ºÏ|ÊôÐÔ|·½·¨](±äÁ¿)
1¡¢Form
Form ¼¯ºÏͨ¹ýʹÓà POST ·½·¨µÄ±í¸ñ¼ìË÷ÓÊË͵½ HTTP ÇëÇóÕýÎÄÖеıí¸ñÔªËØµÄÖµ¡£
Request.Form(element)[(i ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ