Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ò³Ãæµ÷ÊÔÎÊÌâ

½¨ÁËÒ»¸öÕ¾µã£¬ÀïÃæÓÐ login.aspx. events.aspx µÈµÈ ÆäËûµÄÒ³Ãæ¡£


µ«ÊÇÎÒµ÷ÊÔ ÆäËûÒ³ÃæµÄʱºò£¬±Ä³öÀ´µÄ×ÜÊÇ login.aspx Ò³Ãæ¡£

¸Õѧasp ÇëÖ¸½Ì
ÄãÉèÖÃÆðʼҳÁ˰ɡ£¡£

¶÷ÔõôȡÏûÄØ£¿

Òªµ ......

ASP FCKÔÚÏ߱༭Æ÷

ÓÐÄÄλ¸ßÊÖÓùýASP FCKÔÚÏ߱༭Æ÷ѽ£¬ËüÄǸöͼƬÉÏ´«¹¦ÄÜÔõôÅäÖÃѽ
ÄܸøÎÒ·¢¸öÄÜÓÃFCKÔÚÏ߱༭Âð£¿Ò»¶¨ÄÜÉÏ´«Í¼Æ¬¹¦ÄܵÄѽ£¬¼±Ñ½
Ö±½Óµ½¹Ù·½ÍøÕ¾È¥Ï¸ö¾Í¿ÉÒÔÁË£¬¹ØÓÚÉèÖÃô£¬Ö±½ÓGOOGLEÒ»ÏÂÄãµÄ°æ±¾ºÅ¾Í¿ÉÒÔÕÒµ ......

ASPµÄÊý¾Ý¼¯¿É²»¿ÉÒÔÕâÑùд£¿

set rs=server.createobject("adodb.recordset")
set RS=server.createobject("adodb.recordset")

sql1="select jufenjiekou from A"
Rs.open sql1,conn,1,1

whi ......

aspÔõÑùʵÏÖ¸ÊÌØÍ¼µÄЧ¹û£¿ - Web ¿ª·¢ / ASP

ÓÐË­Äܸø½²½²£¬Ôõô×öÂð£¿
ллÀ²£¡
¸ÊÌØÍ¼ ÊÇɶ£¿

½âÌâ˼·.¿´Ò»Ï½ø¶ÈÌõµÄÏÔʾ..
ÆäʵÄã¾ÍŪһ¶Ñtable ÿ¸ötableµÄ¿í¶È²»Í¬.µ×É«²»Í¬¼´¿É
µ±È»ÓÃdiv¿ØÖÆÎ»ÖøüºÃ

ÄãŪ100¸ötable¸ù¾Ý½ø¶ÈÆäÖÐǰ20¸ö·Ö¸øµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ