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ÊÇ¿ÉÒÔµÄ
Ïà¹ØÎÊ´ð£º
<form id="form1" runat="server">
<div>
<script type="text/javascript">
function oo(a){
document.getEleme ......
´ÓAcessÊý¾Ý¿âÀï²éÕÒµ½Ä³Ò»Ìõ¼Ç¼£¬Òª±È½ÏÕâÌõ¼Ç¼ÖеÄijһÁеÄÖµÊÇ·ñ°üº¬Ä³Ò»×ֶΡ£
±ÈÈ磬Êý¾Ý¶ÔËùÓеÄÓû§²Ù×÷½øÐÐÁ˼Ǽ¡£
ÔÚÈÕÖ¾²éѯÀÏë°ÑÓû§É¾³ý¼Ç¼ÒÔºìÉ«ÐÅÏ¢ÏÔʾ¡£
ÿÌõɾ³ýµÄÈÕÖ¾¼Ç¼ÀïÓÐÒ»Á ......
<%On Error Resume Next
Set conn=Server.CreateObject("ADODB.Connection")
conn.begintrans
conn.Open ("Driver={SQL Server};server=(local);uid=sa;database=student;pwd=")
......
"title"Õâ¸öÖµ±£´æ²»ÁË?ÇëÎʸßÊÖ´íÎóÔÒò
<%set rs=server.createobject("adodb.recordset")
rs.open "select * from question",conn,1,3
if ......
----´íÎóÌáʾ--------------
Microsoft OLE DB Provider for ODBC Drivers ´íÎó '80004005'
»ùÓÚ²éѯµÄ¸üÐÂʧ°Ü£¬ÒòΪû·¢ÏÖÒª¸üеÄÐС£
/admin/inboundSQL.asp£¬ÐÐ 406
-- ......