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

<%On Error Resume Next
Set conn=Server.CreateObject("ADODB.Connection")
conn.begintrans
conn.Open ("Driver={SQL Server};server=(local);uid=sa;database=student;pwd=") ......

ÎÒÏë×öÒ»¸öaspÍøÕ¾£¬µ«ÊDz»ÖªµÀ×öʲô£¡

×î½üÎÒͨ¹ýѧϰ£¬¸Ð¾õ×Ô¼ºÑ§µÄ»¹¿ÉÒÔÁË£¬Ïë×öÒ»ÍøÕ¾£¬µ«ÊÇÒ»Ö±¶¼ÕÒ²»µ½Ìâ²Ä£¬²»ÖªµÀ×öʲô£¬Ï£Íû¸÷λ¸øÎÒµãÒâ¼û£¬Èç¹ûÓÐÐèÇóÎĵµ¾Í¸üºÃÁË£¡Ï£Íû´ó¼Ò¸øÎÒµãÒâ¼û£¬Ð»Ð»£¡
ÏÈ×ö¸öÆóÒµÍøÕ¾°É£¬ÎҸоõÒ»¸öÈË×öÍøÕ¾²»ÊÊÒË ......

aspÒ³Ãæµ÷ÊÔÎÊÌâ

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


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

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

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

Òªµ ......

ASP FCKÔÚÏ߱༭Æ÷

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

aspα¾²Ì¬ - Web ¿ª·¢ / ASP

ÎÒÕÒÁËÒ»¸öα¾²Ì¬´úÂ룬ÈçÏ£º
index.asp
<!--#include file="config.asp"-->  
<ol>  
<%  
Set rs=server.CreateObject("adodb.recordset") & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ