ASPͨ¹ý²éѯ¼Ç¼ÊýÁ¿Éú³ÉÎı¾¿ò£¬È»ºóÔÙÒ»Æð¸üÐÂ
ÎÒÔÚ×öÒ»¸ö¸É²¿»¥ÆÀϵͳ£¬ÄѶÈÔÚÓÚ²»Í¬¼¶±ðµÄ¸É²¿£¬ËûËùÒªÆÀ¼ÛµÄÈËÊýÒÔ¼°¼¶±ðÊDz»Í¬µÄ£¬Õâ¾ÍÒª¸ù¾Ý²éѯ£¬ÏȰÑËûËùÒªÆÀ¼ÛµÄ¸É²¿±àºÅÕÒ³öÀ´£¬È»ºó¸ù¾Ý¸É²¿±àºÅµÄÊýÁ¿Éú³ÉÎı¾¿ò£¬È»ºó·ÖÊýÌîдºÃÒԺ󣬰ѷÖÊý¶ÔÓ¦²»Í¬µÄ¸É²¿±àºÅ£¬¸üе½Êý¾Ý¿âÀïÈ¥£¬ËÄÜÌṩÒÔÏÂ˼·»òÕßÏà¹Ø´úÂ룿¸Ð¼¤²»½û
ÎÒµÄÊý¾Ý¿âÊÇMSSQL
°ï¶¥!
ÔÎËÀ,Äã˵µÄ˼·¶¼ÕâôÇå³þÁË
»¹ÒªÔõô˵°¡?
Äã²»¾Í²éдÏֳɴúÂëÁË?
ÓÐÁ½¸öÎÊÌ⣬µÚÒ»£¬ÅúÁ¿Éú³ÉÎı¾¿òʱ£¬ÔõÃ´Çø·Ö£¿µÚ¶þ£¬Ôõô½«Îı¾¿òµÄIDºÍ¸É²¿±àºÅ¹ØÁªÆðÀ´
ÓдúÂë×îºÃ~²»Ê¤¸Ð¼¤
¸ù¾ÝID»ònameÇø·Ö
±ÈÈç
VBScript code:
sql="select id from table"
set rs=conn.execute(sql)
i=0
response.write("<tr>")
while not rs.eof
response.write("<td><input type='text' id='"&id&"_"&i&"'><td>")
'µÚÒ»¸öidÊǸɲ¿±àºÅ£¬µÚ¶þiÊÇ˳Ðò±àºÅ
i=i+1;
rs.movenext
loop
respons.write("</tr>")
ÎÒ×öÕâÑù¶¯Ì¬Éú³ÉµÄ¶¼ÊÇÓÃajaxÈ¥±£´æ
ÓÃjavascriptÌáȡֵºÍÅжÏ
Â¥Éϵķ½·¨ÎÒ»ØÈ¥ÊÔÊÔ
º¹!!
rs.AddNewÕâ¸ö¼Ò»ï²»ÄÜÑ»·Å¶!!
¿Í»§¶Ë¹â±êÅúÁ¿¸üз½Ê½ÏÂÑ»·AddNewÊÇ¿ÉÒÔµÄ
Ïà¹ØÎÊ´ð£º
<%@language="vbscript"%>
<%option explicit%>
<html>
<head> <title>xxx </title> </head>
<script language=vbs>
'×¢Òâ±äÁ¿ ......
ÎÒÃÇÓÐÒ»¸öÍøÕ¾Ä£°å£¬www.c111.com.cn,Ï£ÍûÐÞ¸ÄһЩµØ·½£º
1£©µã»÷×ó²à¡°·þÎñÆ·ÅÆ¡±µÄÆäÖÐÒ»¸öС·ÖÀ࣬Èç¡°×ãÇò¡±£¬½çÃæµÄÓÒ²à¾Í³öÏÖÈçwww.c111.com.cn/1.jpg£¬µã»÷1.jpgÉÏ·½µÄÆäÖÐÒ»¸öÆ·ÅÆlogo£¬ÏÂÃæ¾Í³öÏÖÏà¹ØµÄÍ ......
ÎÊÌ⣺µ±ÍøÒ³Îļþ³¬¹ýÏÔʾÆ÷·Ö±æÂʵÄʱºò£¬´¹Ö±¹ö¶¯ÌõÓ¦¸Ã³öÏֵ쬵«ÎªÊ²Ã´Ë®Æ½¹ö¶¯ÌõÒ²³öÏÖÄØ£¿ÈçºÎÈ¥µô°¡£¬ÏÂÃæÊǽØÍ¼ºÍ¿ò¼ÜÒ³Ãæ´úÂ룺
http://hi.baidu.com/w511170721/album/item/a61278226d558e4f9922ed13.h ......
<%On Error Resume Next
Set conn=Server.CreateObject("ADODB.Connection")
conn.begintrans
conn.Open ("Driver={SQL Server};server=(local);uid=sa;database=student;pwd=")
......
----´íÎóÌáʾ--------------
Microsoft OLE DB Provider for ODBC Drivers ´íÎó '80004005'
»ùÓÚ²éѯµÄ¸üÐÂʧ°Ü£¬ÒòΪû·¢ÏÖÒª¸üеÄÐС£
/admin/inboundSQL.asp£¬ÐÐ 406
-- ......