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

aspÄÜÖ´Ðж¯Ì¬T-SQLÂð£¿

Ö±½ÓÔÚsqlÓï¾äÖÐд£º
sql= " declare @1 nvarchar(max),@2 nvarchar(max£©...... "
È»ºó
Rs.open sql,CONN,3,2
Response.Write Rs.recordcount

µ«ÊÇûÓдò¿ª£¬±¨´í
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.

ÊDz»ÊÇÒªÓô洢¹ý³Ì²Å¿ÉÒÔѽ£¿
ÔÚasp.netÖÐÊÇ¿ÉÒÔÖ±½ÓÔÚsqlÀïÃæÄÇÑùдµÄ¡£

³Ô·¹»ØÀ´¹Ø×¢¡£

CONN.execute sql

²»ÐÐ ¡£

ÒýÓÃ
CONN.execute sql


»¹ÊDZ¨´í
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.

ÒýÓÃ
ÒýÓà 2 Â¥ hookee µÄ»Ø¸´:
CONN.execute sql


»¹ÊDZ¨´í
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.


²Ù×÷±»¾Ü¾ø£¡ÔÚ¶ÔÏóÒѹرյÄʱºò

±¨Ê²Ã´´í?
Á¬½Ó´®µÄÕʺÅÒªÓÐ×ã¹»µÄȨÏÞÖ´ÐвÙ×÷
ÒÔϲâÊÔ¿ÉÒÔ

VBScript code:
sql= " declare @1 nvarchar(max), @2 nvarchar(max);"
Set conn = CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB;Data source=127.0.0.1;Initial Catalog=DB;User ID=sa;Password=sa;"
conn.Execute sql
conn.Close


{{---


Ïà¹ØÎÊ´ð£º

asp³õѧÎÊÌâ¡£responseÕÒ²»µ½

<%@language="vbscript"%>
<%option explicit%>
<html>
<head> <title>xxx </title> </head>
<script language=vbs>
'×¢Òâ±äÁ¿ ......

ASPÅжϵÄÎÊÌâ,ÓôÃÆÁË!Åжϲ»³öÀ´!

HTML code:

dim jf
set conn=server.createobject("adodb.connection")
connstr="Driver={Sql Server};Server="&Sqlip&";Database="&Sqldb&";Uid="& ......

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

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


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

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

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

Òªµ ......

asp±íµ¥Ìá½»ÎÊÌâ

Çë¸÷λ¸ßÊÖ°ï½â¾ö,¼±!!!
<script language="JavaScript" type="text/javascript">
function CheckInput(){
if (document.frm.loginname.length =0){
alert('ÇëÕý ......

asp¿ò¼ÜÎÊÌâ ºÜÑÏÖØ

ÎÒ×ö¸öÕ¾ ¿ò¼ÜÓõıȽ϶à~
µ½ºóÀ´Ê²Ã´¶¼ÔÚ¿ò¼ÜÀïÏÔʾ,ÕâÒ²´ïµ½ÎÒµÄÄ¿µÄ
µ«ÎÒÌí¼Ó×ÊÁÏÔÚÊý¾Ý¿âÀï´øÓÐÁ´½Ó,¾ÍÊǽéÉܱðÈ˹«Ë¾ÍøÕ¾
²»ºÃÔڱ༭Æ÷ÀïÐÞ¸Ä~~~ Ò²±»¿ò¼Ü½øÈ¥ÁË
Õâ²»ÊÇÎÒÏëÒªµÄÁË
¸÷λ´óϺÏëÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ