°ïÎÒ¿´Ò»ÏÂÕâ¶Î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