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

asp Êý¾Ý²éѯÁ½ÖÖ·½Ê½µÄ×ܽá

µÚÒ»ÖÖ£º
 'ʹÓÃÊý¾Ý¿âÁ¬½Ó¶ÔÏó²éѯÊý¾Ý¼¯¶ÔÏó£¬Óà set±äÁ¿½ÓÊÕ¡£
 set rset1 = conn.execute("select * from productType where id="&request("id"))
 
 '±íʾֻÄÜÈ¡³ö½á¹û¼¯ÀïÃæµÄÖµ£¬µ«ÊDz»ÄÜÈ¡µ½×ܵÄÌõÊýÖ®ÀàµÄ¡£¡£¡£
 set rset2 = conn.execute("select top 8 * from productType where typeId="&request("id")&" order by id")
µÚ¶þÖÖ£º
 '±íʾµÄÊÇ¿ÉÒÔÈ¡½á¹û¼¯¡¢¿ÉÒÔÈ¡µ½×ܵÄÌõÊý£¬±ÈÈç·ÖÒ³
 'set rset2=server.createobject("adodb.recordset")  =========´´½¨Ò»¸ö¿ÉÒÔÓÃÓÚ·ÖÒ³µÈ¹¦ÄܵĽá¹û¼¯¶ÔÏó¡£°üº¬ÓÐһЩÊôÐԺͷ½·¨
 'rset2.open "select top 8 * from productType where typeId="&request("id")&" order by id",conn,1,1 ====µ÷ÓÃÕâ¸ö½á¹û¼¯¶ÔÏóÖ´ÐÐopen·½·¨£¬Ê¹ÓÃÊý¾Ý¿âÁ¬½Ó²éѯÊý¾Ý£¬²¢·µ»ØÒ»¸ö·â×°ºÃµÄ½á¹û¶ÔÏó¡£


Ïà¹ØÎĵµ£º

ASPʵÏÖÓïÒô·ÖʱÎʺò

<bgsound src="wen.mid" loop="0">
  <% dim weh
  If Time >=#1:00:00 AM# And Time < #6:00:00 PM# Then
   weh = "<bgsound src="1.mid" loop="0">"
  Else If Time >#6:00:00 AM# And Time < #9:00:00 PM#
   weh = "<bgso ......

asp ÖÐÊý¾Ýµ¼³öΪ word £¬excl £¬text £¬µÈ¸ñʽÎļþ

ÕâÊÇ´Ó·½·¨Ö±½Ó¸´ÖƵģ¬
 ²ÎÊý fileTypeÊÇÎļþ¸ñʽ
²ÎÊýfiledNameÊÇд³öºóÎļþµÄÎļþÃû¡£
²ÎÊýsuffixÊÇд³öºóÎļþµÄÎļþºó׺Ãû¡£
 Response.Clear(); //Çå¿Õ »º³åÇøµÄËùÓÐÊä³öÊý¾Ý
        Response.Charset = "utf-8";//ÉèÖÃÊä³öÊä³öÁ÷×Ö·ûÀàÐÍ
   &nb ......

aspÖÐ×Ö·û´®×ª»¯ÎªÊµÌåÀàµÄ·½·¨£¨ÈëÃÅÆª£¬´«Í³·½·¨£©

      ´ËÎÄÖ»ÊÇÈëÃÅ£¬ÑÝʾÁËÈçºÎÓÃʵÌåÀà´æ´¢Êý¾Ý£¬ÎÞʵ¼ÊÒâÒå¡£ºóÃæÓÐÂ½Ðø¸üÐÂÓÅ»¯¡££¨ÒÔºóµÄÎÄÕÂÖн«Â½ÐøÊµÏÖÎÞÐèÉùÃ÷¾ßÌåÀà×Ô¶¯´æ´¢Êý¾Ý£¬ºÍ¼òµ¥µÄÐÔÄÜÓÅ»¯£©
  
    ÔÚasp³ÌÐò¿ª·¢¹ý³ÌÖУ¬½á¹¹Êý¾ÝµÄ´æ´¢Ò»Ö±ÊǸöÎÊÌ⣬aspµÄÊý×éÒ»Ö±ºÜÈõ£¬¶øÇÒ²»ÄÜ×Ô½âÊÍ£¬ ......

ASPµ÷Óô洢¹ý³Ì£ºÖ»·µ»Øµ¥Ò»¼Ç¼¼¯µÄ´æ´¢¹ý³Ì


¡¡¡¡1. Ö»·µ»Øµ¥Ò»¼Ç¼¼¯µÄ´æ´¢¹ý³Ì
¡¡¡¡¼ÙÉèÓÐÒÔÏ´洢¹ý³Ì(±¾ÎĵÄÄ¿µÄ²»ÔÚÓÚ½²ÊöT-SQLÓï·¨£¬ËùÒÔ´æ´¢¹ý³ÌÖ»¸ø³ö´úÂ룬²»×÷˵Ã÷)£º
/*SP1*/
CREATE PROCEDURE dbo.getUserList
as
set nocount on
begin
select * from dbo.[userinfo]
end
go
¡¡¡¡ÒÔÉÏ´æ´¢¹ý³ÌÈ¡µÃuserinfo±íÖеÄËùÓмǼ£¬·µ»ØÒ»¸ö¼Ç¼¼¯¡£Í¨¹ ......

aspÈçºÎµ÷Óô洢¹ý³ÌʵÏÖ·ÖÒ³£¡£¨°Ù¶ÈÖªµÀ£©

ÎÊÌ⣺
aspÈçºÎµ÷Óô洢¹ý³ÌʵÏÖ·ÖÒ³£¡
´æ´¢¹ý³ÌÈçÏ£º
CREATE PROCEDURE GetRecordfromPage
    @tblName      varchar(255),       -- ±íÃû
    @fldName      varchar(255),   &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ