asp.netµÚ 1 ÐÐ: '=' ¸½½üÓÐÓï·¨´íÎó
public DataRow dr;
public static string newsid;
protected void Page_Load(object sender, EventArgs e)
{
newsid = Request.Params["nid"];
SqlConnection con = DB.con();
SqlDataAdapter dad4 = new SqlDataAdapter("select * from news where nid="+newsid,con);
DataSet dst = new DataSet();
dad4.Fill(dst, "aaa");
dr = dst.Tables["aaa"].Rows[0];
}
³£ÏêϸÐÅÏ¢: System.Data.SqlClient.SqlException: µÚ 1 ÐÐ: '=' ¸½½üÓÐÓï·¨´íÎó¡£
Ô´´íÎó:
ÐÐ 22: SqlDataAdapter dad4 = new SqlDataAdapter("select * from news where nid="+newsid,con);
ÐÐ 23: DataSet dst = new DataSet();
ÐÐ 24: dad4.Fill(dst, "aaa");
ÐÐ 25: dr = dst.Tables["aaa"].Rows[0];
ÐÐ 26:
ÎÊÌâ²¹³ä£ºµ÷ÊÔÁËһϣ¬¾¹È»newsidµÄֵΪnull,ÇëÎʳöÏÖΪ¿ÕÖµ£¬Ò»°ãÔÚʲôÇé¿öÏ£¿
×îºÃ¸ø¸öÏêϸ½â¾ö·½°¸..
¶Ïµã²é¿´Ò»ÏÂnewsidÓÐÖµÂð?
Request.Params["nid"]; ûÓÐÖµ
int i= dst.Tables["aaa"].count£»
if£¨i>0£©{.....}
{{---
Ïà¹ØÎÊ´ð£º
select top 12 * from Product where [id] not in (select top 12 [id] from Product)
ÕâÑù¿ÉÒÔ·ÖÒ³£¬µ«ÊÇÎÒÔÚºóÃæÏë¼Ó¸öÌõ¼þ
select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......
°ÑÒµÎñ²ãµÄ¶¼Ð´ÔÚdllÎļþÖÐÁË£¬ÏÖÔÚÏëÒªÐ޸쬴ó¼Ò¶¼ÓÃʲô¹¤¾ß´ò¿ª£¿
ÓÃvisual studio×Ô´øµÄ ildasm¿ÉÒÔÂð£¿
ÆÚ´ý¸ßÊÖ
LZºÃÀ÷º¦
Ó÷´±àÒëÈí¼þ
ÎÒÓÃReflectorÖ»ÄÜ¿´£¬²»Äܸİ¡£¿
ÓÐÃ ......
ASP.NETÈçºÎÓÃÒ»¸ö°´Å¥ÊµÏÖÑ¡ÔñÎļþ¼Ð·¾¶µ½Îı¾¿òÖУ¿£¨×¢ÒâÊÇÎļþ¼Ð·¾¶£¬²»ÊÇÎļþ·¾¶£©
http://blog.csdn.net/xianfajushi/archive/2008/10/18/3094474.aspx
Õâ²»ÊÇÎÒÒªµÄЧ¹û£¬ÎÒÒªÓõÄÊÇÀàËÆÓÚÎļþÉÏ´«¿ÉÒ ......
ÇëÎʸ÷λ´óϺ ѧϰASP.NETÄÄЩÎÊÌâÔÚ¹¤×÷ÖÐÊdz£ÓÃµÄ ÎÒÊÇÒ»Ãû´óѧÉú Ï£ÍûÍÆ¼ö¼¸±¾Êé ллÁË
asp.net±¦µä Äã±ØÐëÖªµÀµÄ.net ¿ò¼ÜÉè¼Æ
ÏÂÔØÌìºä´©µÄÊÓÆµ½Ì³Ì£¬»¹²»´í£¬ÓпÕÁËÔÙѧϰһÏÂjsºÍcss£¬Èç¹û×öweb£¬ÕâÁ½¸ö ......