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

ASP.NETÔõôÏòºǫ́SQLÊý¾Ý¿â²åÈëNULL

Îҵıí×Ö¶Î titleÊÇstringÀàÐÍ,
ÎÒÔÚASP.NETÖвåÈëÊý¾Ý£¬ÓÐÒ»¸öÎÊÌâ¾Í³öÏÖÁË£º
titleÓÐÁ½ÖÖÇé¿ö£¬Êý¾Ý¿âÖпÉÒÔΪNULL,»òÕß²»ÎªNULL£¬
ÎÒÏëÔÚǰ̨²åÈëNULL£¬Ôõô²åÈëÄØ£¿
dbnull.value

ÒýÓÃ
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ÈçºÎʵÏÖ×Ô¶¯µÇ¼ - .NET¼¼Êõ / ASP.NET

ÄÄλ´ó¸çÓÐûÓÐASP.NETÖÐÀûÓÃCookiesʵÏÖÓû§×Ô¶¯µÇ¼µÄ´úÂë...ллÁË...Ô½ÏêϸԽºÃ....
ʲôÒâ˼£¿×Ô¶¯µÇ¼£¿

mark òÊÓÊÇ´æ´¢cookies ÎÒÒ²¶Ôcook±È½ÏÃÔºý ¹Ø×¢ÏÂ

¼ÈÈ»ÄãÖªµÀÓÃcookies×Ô¼º¶¯¶¯´óÄÔ¶àºÃ£¡ ......

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

±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
  101 50 08£º00 08£º30 30 40 50  
  101 50 09£º00 ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

asp.net»ñÈ¡Îļþ¼Ð·¾¶ - .NET¼¼Êõ / ASP.NET

ASP.NETÈçºÎÓÃÒ»¸ö°´Å¥ÊµÏÖÑ¡ÔñÎļþ¼Ð·¾¶µ½Îı¾¿òÖУ¿£¨×¢ÒâÊÇÎļþ¼Ð·¾¶£¬²»ÊÇÎļþ·¾¶£©
http://blog.csdn.net/xianfajushi/archive/2008/10/18/3094474.aspx

Õâ²»ÊÇÎÒÒªµÄЧ¹û£¬ÎÒÒªÓõÄÊÇÀàËÆÓÚÎļþÉÏ´«¿ÉÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ