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

ASPµ÷ÓÃSQL´æ´¢¹ý³Ì

¸÷λ´óÏÀ£ºÇëÎÊÔõÑùÔÚASP³ÌÐòÖе÷ÓÃSQL´æ´¢¹ý³Ì£¿Ð»Ð»£¬Çë¸ø¸öÀý×Ó£¡
http://hi.baidu.com/lz0830/blog/item/e847e5e9077fde39b80e2db9.html


1 ÕâÒ²ÊÇ×î¼òµ¥µÄ·½·¨,Á½¸öÊäÈë²ÎÊý£¬ÎÞ·µ»ØÖµ£º
set connection = server.createobject("adodb.connection")
connection.open someDSN
Connection.Execute "procname varvalue1, varvalue2"

''½«ËùÓжÔÏóÇåΪnothing£¬ÊÍ·Å×ÊÔ´
connection.close
set connection = nothing


2 Èç¹ûÒª·µ»Ø Recordset ¼¯:
set connection = server.createobject("adodb.connection")
connection.open someDSN
set rs = server.createobject("adodb.recordset")
rs.Open "Exec procname varvalue1, varvalue2",connection

''½«ËùÓжÔÏóÇåΪnothing£¬ÊÍ·Å×ÊÔ´
rs.close
connection.close
set rs = nothing
set connection = nothing


3 ÒÔÉÏÁ½ÖÖ·½·¨¶¼²»ÄÜÓзµ»ØÖµ£¬£¨Recordset³ýÍ⣩£¬Èç¹ûÒªµÃµ½·µ»ØÖµ£¬ÐèÒªÓÃCommandµÄ·½·¨¡£
Ê×ÏÈ˵Ã÷£¬·µ»ØÖµÓÐÁ½ÖÖ¡£Ò»ÖÖÊÇÔÚ´æ´¢¹ý³ÌÖÐÖ±½ÓreturnÒ»¸öÖµ£¬¾ÍÏóCºÍVBµÄº¯Êý·µ»ØÖµÄÇÑù£»ÁíÒ»ÖÖÊÇ¿ÉÒÔ·µ»Ø¶à¸öÖµ£¬´æ
´¢ÕâЩֵµÄ±äÁ¿Ãû³ÆÐèÒªÔÚµ÷ÓòÎÊýÖÐÏÈÐÐÖ¸¶¨¡£
Õâ¸öÀý×ÓÒª´¦Àí¶àÖÖ²ÎÊý£¬ÊäÈë²ÎÊý£¬Êä³ö²ÎÊý£¬·µ»Ø¼Ç¼¼¯ÒÔ¼°Ò»¸öÖ±½Ó·µ»ØÖµ£¨¹»È«Á˰ɣ¿£©
´æ´¢¹ý³ÌÈçÏ£º

use pubs
GO

-- ½¨Á¢´æ´¢¹ý³Ì
create procedure sp_PubsTest

-- ¶¨ÒåÈý¸ö²ÎÊý±äÁ¿£¬×¢ÒâµÚÈý¸ö£¬Ìرð±ê¼ÇÊÇ


Ïà¹ØÎÊ´ð£º

Ò»¶Îaspתphp

<%if request.QueryString("start") <>"" then%>
<%if cint(start)>0 then%>
<a href="search.asp?q= <%=q%>&start= <%if request.Query ......

ÎÒÊÇÒ»ÃûASP´¦Ñ§Õߣ¡ÏëÇë°ïÃ¦ÍÆ¼öÒ»±¾ASPºÃµÄÊé¼®

ÎÒÔ­±¾ÊÇѧjspµÄ¿ÉÕÒÁËÒ»¸öASPµÄ¹«Ë¾£¡ÎÒÒªÖØÐÂѧϰ£¡ ѧϰASP£¡ Ï£Íû´ó¼ÒÍÆ¼öÒ»±¾ºÃÊ鏸ÎÒлл
<ASP3.0¸ß¼¶±à³Ì> ÍøÉÏÓеç×Ó°æµÄ

·¢ÏÖÍøÉÏaspÐÅϢʱ×î¶àµÄ ±ÈÆäËûµÄ¶¼¶àºÃ¶à

yun

ÕÒ±¾ÓÐÓ¦ÓÃÊÂÀýµÄA ......

ASP網頁ÖÐÈ¡µÃµÇ陸µÄÓÃ戶Ãû

ÎÒµÄ網頁´ú碼為ASP語ÑÔ,驗證·½Ê½為ϵ統×Ô帶µÄWINDOW驗證ģʽ.

現ÔÚÎÒÈç¹ûÒªÔÚASP´ú碼ÖÐ獲È¡當ǰµÄµÇÈëÈË ......

ÈçºÎÖÆ×÷aspÊÔÓðæ?

Ò»¶Îʱ¼äºó ¾Í²»ÄÜÓõÄÄÇÖÖ

¿ÉÒÔÓÃ×é¼þдÂð?
×é¼þ  ÊDz»ÊDZØÐëÏÈÔÚ·þÎñÆ÷°²×°  ²ÅÄÜʹÓÃ?

ÄÇÓÃÐéÄâÖ÷»úµÄ  ²»¾ÍûϷÁË....

ewebeditor¾ÍÊÇҪע²á²ÅÄÜÓõĠ
Ã²ËÆÊÇûɶÓõ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ