ASP:rs.getRows()
±¾ÎÄת×Ô£ºhttp://hi.baidu.com/viewhainan/blog/item/663d68605e7de942ebf8f80a.html
GetRows()·½·¨
Êǽ«Êý¾Ý´Ó Recordset ¸´ÖƵ½¶þάÊý×éÖУ¬ÕâÊÇÒ»¸ö¶þάÊý×飬µÚÒ»¸öϱê±êʶ×ֶΣ¬µÚ¶þ¸öÔò±êʶ¼Ç¼ºÅ£¬ËùÒÔ rsArray = rs.GetRows() rsArray(0, 0)¾Í±íʾ¼Ç¼¼¯µÚÒ»ÐеĵÚÒ»×Ö¶ÎÖµ rsArray(1, 0)¾Í±íʾ¼Ç¼¼¯µÚÒ»Ðеĵڶþ×Ö¶ÎÖµ Êý×éµÄÊý¾ÝÊDZ£´æÔÚÄÚ´æÖеģ¬Õâ¾Í´Ó¸ù±¾ÉϽâ¾öÁËÿ´ÎÏÔʾ¼Ç¼»¹ÐèÏòÊý¾Ý¿âÇëÇóµÄÂé·³
²Î¿¼:
¹ØÓÚGetRows()µÄÏêϸ½éÉܺÍÓ÷¨£º
GetRows ·½·¨
½« Recordset ¶ÔÏóµÄ¶à¸ö¼Ç¼»Ö¸´µ½Êý×éÖС£
Óï·¨
array = recordset.GetRows( Rows, Start, Fields )
·µ»ØÖµ ·µ»Ø¶þάÊý×é¡£
²ÎÊý
Rows ¿ÉÑ¡£¬³¤ÕûÐͱí´ïʽ£¬Ö¸¶¨Òª¼ìË÷¼Ç¼Êý¡£Ä¬ÈÏֵΪ adGetRowsRest (-1)¡£
Start ¿ÉÑ¡£¬×Ö·û´®»ò³¤ÕûÐÍ£¬¼ÆËãµÃµ½ÔÚ GetRows ²Ù×÷¿ªÊ¼´¦µÄ¼Ç¼µÄÊéÇ©¡£Ò²¿ÉʹÓÃÏÂÁÐ BookmarkEnum Öµ¡£³£Á¿ ˵Ã÷ AdBookmarkCurrent ´Óµ±Ç°¼Ç¼¿ªÊ¼¡£ AdBookmarkFirst ´ÓÊ׼Ǽ¿ªÊ¼¡£ AdBookmarkLast ´Óβ¼Ç¼¿ªÊ¼¡£
Fields ¿ÉÑ¡£¬±äÌåÐÍ£¬´ú±íµ¥¸ö×Ö¶ÎÃû¡¢Ë³ÐòλÖá¢×Ö¶ÎÃûÊý×é»ò˳ÐòλÖúš£ADO ½ö·µ»ØÕâЩ×Ö¶ÎÖеÄÊý¾Ý¡£
˵Ã÷
ʹÓà GetRows ·½·¨¿É½«¼Ç¼´Ó Recordset ¸´ÖƵ½¶þάÊý×éÖС£µÚÒ»¸öϱê±êʶ×ֶΣ¬µÚ¶þ¸öÔò±êʶ¼Ç¼ºÅ¡£µ± GetRows ·½·¨·µ»ØÊý¾ÝʱÊý×é±äÁ¿½«×Ô¶¯µ÷Õûµ½ÕýÈ·´óС¡£ Èç¹û²»Ö¸¶¨ Rows ²ÎÊýµÄÖµ£¬GetRows ·½·¨½«×Ô¶¯¼ìË÷ Recordset ¶ÔÏóÖеÄËùÓмǼ¡£Èç¹ûÇëÇóµÄ¼Ç¼±È¿ÉÓüǼ¶à£¬Ôò GetRows ½ö·µ»Ø¿ÉÓüǼÊý¡£ Èç¹û Recordset ¶ÔÏóÖ§³ÖÊéÇ©£¬Ôò¿ÉÒÔͨ¹ý´«Ë͸üǼµÄ Bookmark ÊôÐÔÖµ£¬À´Ö¸¶¨ GetRows ·½·¨½«´ÓÄĸö¼Ç¼¿ªÊ¼¼ìË÷Êý¾Ý¡£ ÈçÒª
Ïà¹ØÎĵµ£º
¡¡ASPÁ¬½ÓÊý¾Ý¿âµÄ11ÖÖ·½·¨——±¾ÎÄ×ܽáÁËʹÓÃASPÁ´½Ó¸÷ÖÖÊý¾Ý¿âµÄ·½·¨£º
¡¡¡¡1.AccessÊý¾Ý¿âµÄDSN-lessÁ¬½Ó·½·¨:
set adocon=Server.Createobject("adodb.connection")
adoconn.Open"Driver={Microsoft Access Driver(*.mdb)};DBQ="& _
Server.MapPath("Êý¾Ý¿âËùÔÚ·¾¶")
¡¡¡¡2.Access OLE DBÁ¬½Ó·½·¨£ ......
<%@Language="VBScript" CodePage="65001"%>
<% option explicit%>
<% on error resume next %>
<% Session.CodePage="65001" %>
<% response.charset="utf-8" %>
<%
dim conn,connstr,sql,rs,rs2,rs3
connstr="dbq=" & server.MapPath("../data091003/data09 ......
1£¬ÔÚweb·þÎñÆ÷ÉÏ°²×°OracleÊý¾Ý¿â¿Í»§¶Ë£¬ÕâÊÇÁ¬½ÓOracleÊý¾Ý¿âµÄ»ù´¡£¨µ«£¬²»Ò»¶¨ÊDZØÐëµÄ£©¡£
2£¬ÔÚ¿Í»§¶ËµÄNet Manager ÖнøÐÐÅäÖ÷þÎñµÄÃû³Æ£¬ÅäÖÃÈçͼ£¨ÕâÒ»µã·Ç³£µÄÖØÒªÒÔºóµÄÁ´½ÓÈ«¶¼ÔÚÕâ¸ö·þÎñÃû³ÆµÄ»ù´¡ÉϽøÐеģ©
3£¬ASPÁ´½Ó·þÎñµÄÁ´½Ó×Ö·û´®ºÍ·½·¨ÈçÏ£º
<%
connstr= "Provider=MSDAORA.1;Password=***; ......
ASP.NET Web ²¿¼þÊÇÒ»×鼯³É¿Ø¼þ£¬ÓÃÓÚ´´½¨Íøվʹ×îÖÕÓû§¿ÉÒÔÖ±½Ó´Óä¯ÀÀÆ÷ÐÞ¸ÄÍøÒ³µÄÄÚÈÝ¡¢Íâ¹ÛºÍÐÐΪ¡£ÕâЩÐ޸ĿÉÒÔÓ¦ÓÃÓÚÍøÕ¾ÉϵÄËùÓÐÓû§»ò¸ö±ðÓû§¡£µ±Óû§ÐÞ¸ÄÒ³ºÍ¿Ø¼þʱ£¬¿ÉÒÔ±£´æÕâЩÉèÖÃÒÔ±ã¿çÒÔºóµÄ¸÷ä¯ÀÀÆ÷»á»°±£ÁôÓû§µÄ¸öÈËÊ×Ñ¡ÏÕâÖÖ¹¦ÄܳÆΪ¸öÐÔ»¯ÉèÖá£ÕâЩ Web ²¿¼þ¹¦ ......
ÔÚ½« ASP.NET Web ²¿¼þµÄ¼¯³É¿Ø¼þ¼¯ÖеĿؼþ°üÀ¨ÔÚÍøÒ³ÖÐʱ£¬ÕâЩ¿Ø¼þ½«×ñÊظÃÒ³µÄ¹æÔò£»¾ßÌå¶øÑÔ¾ÍÊÇ£¬ÕâЩ¿Ø¼þ½«ÔÚ¸ÃÒ³µÄÉúÃüÖÜÆÚÄÚÔËÐС£
ÿ¸öÍøÒ³¶¼¾ßÓÐÒ»¸öÉúÃüÖÜÆÚ£¬ÍøÒ³ÔÚÆäÉúÃüÖÜÆÚÄÚ½«Ö´ÐÐһϵÁд¦Àí²½Öè¡£ÕâЩ²½Öè°üÀ¨³õʼ»¯¡¢´´½¨¿Ø¼þ¡¢»¹ÔºÍά»¤×´Ì¬¡¢ÔËÐÐʼþ´¦Àí³ÌÐò´ú ......