asp wap sqlÓï¾äÖлñÈ¡µÄºº×Ö²»ºÃÊ - Web ¿ª·¢ / ASP
SQL code: rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1 do while not rs.eof or rs.bof ¡£¡£ ¡£¡£ ¡£¡£ rs.movenext loop Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐÊý¾Ý µ«ÊÇ»¹ÊÇËÑË÷²»µ½
ÔÚÊý¾Ý¿âÀïÃæÖ±½ÓÔËÐÐ £ºselect * from guide where city_name='±±¾©' order by pai descÊÇ·ñÓнá¹û£¿ ±±¾©ÊÇÄã´«µÝµÄ²ÎÊý£¿»¹ÊÇÖ±½Ó¾ÍÄÇÑùдµÄ£¿£¿ÒýÓà ÔÚÊý¾Ý¿âÀïÃæÖ±½ÓÔËÐÐ £ºselect * from guide where city_name='±±¾©' order by pai descÊÇ·ñÓнá¹û£¿ ±±¾©ÊÇÄã´«µÝµÄ²ÎÊý£¿»¹ÊÇÖ±½Ó¾ÍÄÇÑùдµÄ£¿£¿ ÎÒÕâ¿ìÊÇ»ñÈ¡µÄÖµ ×Ö¶ÎÀï¿Ï¶¨Óб±¾© ¶øÇҺü¸Ìõ µ«¾ÍÊDz»ÏÔʾ³öÀ´ µ«ÊÇÈç¹ûÎÒ°ÑÓï¾ä¸Ä³É select * from guide where id>2500 order by pai desc ¾ÍÄÜÑ»·do while Óï¾äÁË ÔÚÊý¾Ý¿âÀïÃæÖ±½ÓÔËÐÐ select * from guide where city_name='±±¾©' order by pai desc ÊÇ·ñÓнá¹û£¿ Êý¾Ý¿âÀïÃæÃ»ÓÐÎÊÌâ ¾Í ²»»áÓÐʲôÎÊÌâ
Ïà¹ØÎÊ´ð£º
ÓÐÒ»¸öÀà class adc { dim a,b,c } ÈçºÎÔÚÁíÍâÒ»¸öÀàÖÐÈ¡µÃÀà³ÉÔ±¼°³ÉÔ±¸öÊý class getmenber { dim menbers() function getmenbers(resclass) 'resΪһδ֪Àà 'getmenber ......
C# code: SqlConnection conn = CsDB.sqlcon(); SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£© tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname ½á¹û£º µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
sqlserverµÄÊý¾Ý¿â£¬×Ö¶ÎÊÇimageÀàÐ͵ġ£Ôõôд´úÂ룬ÔÚÒ³ÃæÖеã»÷¡°ÏÂÔØ¡±¾ÍÄÜ´ò¿ªÄǸöÏÂÔØ¶Ô»°¿ò£¿ PS£ºOracleLob ÔÚsqlserverÀïÊÇʲô£¿ Response.Redirect("test.jpg") ÒýÓà Response.Redirect( ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ ÖÁÉٵø½¼Óµ½sqlserverÉÏ ¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿ Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£ sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......