ASP.NETÔõôÏòºǫ́SQLÊý¾Ý¿â²åÈëNULL
Îҵıí×Ö¶Î titleÊÇstringÀàÐÍ,
ÎÒÔÚASP.NETÖвåÈëÊý¾Ý£¬ÓÐÒ»¸öÎÊÌâ¾Í³öÏÖÁË£º
titleÓÐÁ½ÖÖÇé¿ö£¬Êý¾Ý¿âÖпÉÒÔΪNULL,»òÕß²»ÎªNULL£¬
ÎÒÏëÔÚǰ̨²åÈëNULL£¬Ôõô²åÈëÄØ£¿
dbnull.value
µ«ÊǶÔÓÚstringÀàÐ͵ÄÊý¾Ý²»Ðа¡,Èç¹ûÐдúÂëÔõÃ´Ð´ÄØ?
Äã¿ÉÒÔÔÙ²ÎÊý¸³ÖµµÄʱºò¸³SqlString.Null£¬Ê×ÏÈÒªÒýÓÃusing System.Data.SqlTypes;
¾ÍÏñÕâÑù param[i] = SqlHelper.GetParameter("@Query", model.Query== null
? SqlString.Null
: SqlString.Parse(model.Query.ToString()));
Ö±½ÓÕâÑù²»¿ÉÒÔÂð£¿
update a set col1=null where id=1
Ò²¿ÉÒÔ´æ¿ÕÖµµÄ¡£
string str=null;
if(a!="")
str=a;
update a set col1='"+str+"' where id=1
DBNull.Value
DBNull.Value
Ö±½Ó ='null' ²»¿ÉÒÔÂð£¿
int? y = null;
Ïà¹ØÎÊ´ð£º
ÄÄλ´ó¸çÓÐûÓÐASP.NETÖÐÀûÓÃCookiesʵÏÖÓû§×Ô¶¯µÇ¼µÄ´úÂë...ллÁË...Ô½ÏêϸԽºÃ....
ʲôÒâ˼£¿×Ô¶¯µÇ¼£¿
mark òÊÓÊÇ´æ´¢cookies ÎÒÒ²¶Ôcook±È½ÏÃÔºý ¹Ø×¢ÏÂ
¼ÈÈ»ÄãÖªµÀÓÃcookies×Ô¼º¶¯¶¯´óÄÔ¶àºÃ£¡ ......
±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
101 50 08£º00 08£º30 30 40 50
101 50 09£º00 ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
ASP.NETÈçºÎÓÃÒ»¸ö°´Å¥ÊµÏÖÑ¡ÔñÎļþ¼Ð·¾¶µ½Îı¾¿òÖУ¿£¨×¢ÒâÊÇÎļþ¼Ð·¾¶£¬²»ÊÇÎļþ·¾¶£©
http://blog.csdn.net/xianfajushi/archive/2008/10/18/3094474.aspx
Õâ²»ÊÇÎÒÒªµÄЧ¹û£¬ÎÒÒªÓõÄÊÇÀàËÆÓÚÎļþÉÏ´«¿ÉÒ ......