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

°ïÎÒ¿´Ò»ÏÂÕâ¶ÎsqlÓï¾ä - .NET¼¼Êõ / ASP.NET

string sqlSel = "select imageID,alb.albumID,alb.albumName,imageName,imageUrl,imageTime,imageDesc";
  sqlSel = sqlSel + "from image as img,album as alb where img.albumID=alb.albumID and img.albumID=" + Request["id"];
µ½µ×´íÔÚÄÇÀïÄØ£¿
form Ç°ÃæÁô¸ö¿Õ¸ñ

string sqlSel = "select imageID,alb.albumID,alb.albumName,imageName,imageUrl,imageTime,imageDesc";
  sqlSel = sqlSel + "from image as img,album as alb where img.albumID=alb.albumID and img.albumID=" + Request["id"];
Request["id"]ÊÇʲô°¡
ÊÇRequest.QueryString["id"]Âð

SQL code:

string sqlSel = "select imageID,alb.albumID,alb.albumName,imageName,imageUrl,imageTime,imageDesc ";
sqlSel = sqlSel + " from image as img,album as alb where img.albumID=alb.albumID and img.albumID='" + Request["id"] + "'";


Èç¹ûalbumIDÊÇintÐ͵ģ¬ÄǺóÃæµÄµ¥ÒýºÅ¾Í²»Òª¼Ó£¬°´ÄãÔ­À´µÄÑù×Ó¾ÍÐУ¬
µ«ÊÇÇ°ÃæÎҼӵĿոñÄãÒ»¶¨Òª×Ðϸ¿´ºÃÀ²£¡£¡

ÒýÓÃ
form Ç°ÃæÁô¸ö¿Õ¸ñ

ÔÞ

ÒýÓÃ
string sqlSel = "select imageID,alb.albumID,alb.albumName,imageName,imageUrl,imageTime,imageDesc";
sqlSel = sqlSel + "from image as img,album as alb where img.alb


Ïà¹ØÎÊ´ð£º

WapµÄÒ»¸ö¾ÞÍ·ÌÛµÄÎÊÌ⣡ - .NET¼¼Êõ / ASP.NET

ÎÒÓÃasp.net¿ª·¢wapÕ¾µã£¬Íê³ÉºóÈ¥http://validator.w3.org/ÕâÀïÑéÖ¤ÎÒµÄWapÒ³ÃæÊÇ·ñ±ê×¼£¬ÆäËüÎÊÌâ¶¼¸ÄºÃÁË£¬
¾ÍÊ£ÕâÒ»¸ö´íÎóÁË£¬°´×ÖÃæÒâ˼Àí½âÊÇ˵nameÊôÐÔÒÑ´æÔÚ£¬ÀàËÆÕâÑùµÄ´íÎó»¹Óв»ÄÜÓÃborder ,align,sizeµ ......

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

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

SQL·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ