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

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

ÊÇ·ñÓнá¹û£¿
Êý¾Ý¿âÀïÃæÃ»ÓÐÎÊÌâ ¾Í ²»»áÓÐʲôÎÊÌâ




Ïà¹ØÎÊ´ð£º

¶¯Ì¬È¡µÃaspÀà³ÉÔ±

ÓÐÒ»¸öÀà
class adc
{
dim a,b,c
}
ÈçºÎÔÚÁíÍâÒ»¸öÀàÖÐÈ¡µÃÀà³ÉÔ±¼°³ÉÔ±¸öÊý
class getmenber
{
dim menbers()
function getmenbers(resclass)
'resΪһδ֪Àà
'getmenber ......

asp.netµ¼³öEXCELÎÊÌ⣡ - .NET¼¼Êõ / ASP.NET

C# code:

SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

asp.net ÏÂÔØ - .NET¼¼Êõ / ASP.NET

sqlserverµÄÊý¾Ý¿â£¬×Ö¶ÎÊÇimageÀàÐ͵ġ£Ôõôд´úÂ룬ÔÚÒ³ÃæÖеã»÷¡°ÏÂÔØ¡±¾ÍÄÜ´ò¿ªÄǸöÏÂÔØ¶Ô»°¿ò£¿
PS£ºOracleLob ÔÚsqlserverÀïÊÇʲô£¿
Response.Redirect("test.jpg")

ÒýÓÃ
Response.Redirect( ......

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ - MS-SQL Server / »ù´¡Àà

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ

¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿

Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ

º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£

sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ