Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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³ÌÐòµÄÅóÓѰïæÐÞ¸ÄÍøÕ¾

ÎÒÃÇÓÐÒ»¸öÍøÕ¾Ä£°å£¬www.c111.com.cn,Ï£ÍûÐÞ¸ÄһЩµØ·½£º
1£©µã»÷×ó²à¡°·þÎñÆ·ÅÆ¡±µÄÆäÖÐÒ»¸öС·ÖÀ࣬Èç¡°×ãÇò¡±£¬½çÃæµÄÓÒ²à¾Í³öÏÖÈçwww.c111.com.cn/1.jpg£¬µã»÷1.jpgÉÏ·½µÄÆäÖÐÒ»¸öÆ·ÅÆlogo£¬ÏÂÃæ¾Í³öÏÖÏà¹ØµÄÍ ......

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´¦Ñ§Õߣ¡ÏëÇë°ïÃ¦ÍÆ¼öÒ»±¾ASPºÃµÄÊé¼®

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

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

yun

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

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

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

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

³õʶasp,Çë¸ßÊÖÖ¸½Ì

ÎÒÏëÓÃaspд¸öÒ³ÃæÒÔǰûÓнӴ¥¹ý£¬ÎÒ¿´ÍøÉÏ˵aspµÄÔËÐл·¾³Ö»ÄÜÊÇwindows£¬»¹±ØÐëҪװIIS¡£
Çë½Ì¸÷λ¸ßÊÖ£¬asp»¹ÓÐÆäËûµÄÔËÐл·¾³Âð?
²î²»¶à¾ÍÕâЩÁË£¬¾ÍÊÇIISÒ»¶¨Òª×°ºÃ
»¹ÓÐÒªÊÇÓÃVS2005µÄ»°ºÃÏñ¿ÉÒÔÖ±½ÓÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ