http://blog.csdn.net/lovenjoy/Choose What you like,Like what you Choose!zh-CNThu, 16 Oct 2008 15:59:00 GMT60lovenjoyhttp://blog.csdn.net/lovenjoy/archive/2008/10/16/3086112.aspxThu, 16 Oct 2008 15:58:00 GMThttp://blog.csdn.net/lovenjoy/archive/2008/10/16/3086112.aspxhttp://blog.csdn.net/lovenjoy/comments/3086112.aspxhttp://blog.csdn.net/lovenjoy/archive/2008/10/16/3086112.aspx#Feedback0http://blog.csdn.net/lovenjoy/comments/commentRss/3086112.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3086112用DataFormatString格式化GridView在GridView里面显示数据,要显示的数据有好多位小数,就想让它只显示两位小数,在delphi里,直接用DisplayFormat就行了,在.net中,查了半天msdn,发现使用DataFormatString是可以实现这个功能的,但是怎么设置就不起作用,最后发现,由于2.0出于安全性的考虑,还要同时设置HtmlEncode = false,才能够使DataFormatString生效.留个记号,下次用的时候,就不用浪费N多时间了.还有还有,DataFormatString = "{0:F}",是默认格式,显示两位小数,如果需要显示的小数位数为其他值,DataFormatString = "{0:Fn}"即可.<br /><br /><br /><br />DataFormatString="{0:格式字符串}" <br /><br />在DataFormatString 中的 {0} 表示数据本身，而在冒号后面的格式字符串代表所们希望数据显示的格式；<br /><br />数字、货币格式：<br />在指定的格式符号后可以指定<img src ="http://blog.csdn.net/lovenjoy/aggbug/3086112.aspx" width = "1" height = "1" />lovenjoyhttp://blog.csdn.net/lovenjoy/archive/2008/10/14/3073651.aspxTue, 14 Oct 2008 14:14:00 GMThttp://blog.csdn.net/lovenjoy/archive/2008/10/14/3073651.aspxhttp://blog.csdn.net/lovenjoy/comments/3073651.aspxhttp://blog.csdn.net/lovenjoy/archive/2008/10/14/3073651.aspx#Feedback0http://blog.csdn.net/lovenjoy/comments/commentRss/3073651.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3073651sql server日期时间函数<br /><br />Sql Server中的日期与时间函数 <br />1.  当前系统日期、时间 <br />    select getdate()  <br />2. dateadd  在向指定日期加上一段时间的基础上，返回新的 datetime 值<br />   例如：向日期加上2天 <br />   select dateadd(day,2,'2004-10-15')  --返回：2004-10-17 00:00:00.000<br />3. datediff 返回跨两个指定日期的日期和时间边界数。<br />   select datediff(day,'2004-09-01','2004-09-18')   --返回：17<br />4. datepart 返回代表指定日期的指定日期部分的整数。<br />  SELECT DATEPART(month, '2004-10-15')  --返回 10<br />5. datename 返回代表指定日期的指定日期部分的字符串<br />   SELECT datename(weekday<img src ="http://blog.csdn.net/lovenjoy/aggbug/3073651.aspx" width = "1" height = "1" />lovenjoyhttp://blog.csdn.net/lovenjoy/archive/2008/06/28/2594293.aspxSat, 28 Jun 2008 13:59:00 GMThttp://blog.csdn.net/lovenjoy/archive/2008/06/28/2594293.aspxhttp://blog.csdn.net/lovenjoy/comments/2594293.aspxhttp://blog.csdn.net/lovenjoy/archive/2008/06/28/2594293.aspx#Feedback0http://blog.csdn.net/lovenjoy/comments/commentRss/2594293.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=259429394款免费软件<img src ="http://blog.csdn.net/lovenjoy/aggbug/2594293.aspx" width = "1" height = "1" />lovenjoyhttp://blog.csdn.net/lovenjoy/archive/2008/06/24/2580971.aspxTue, 24 Jun 2008 09:46:00 GMThttp://blog.csdn.net/lovenjoy/archive/2008/06/24/2580971.aspxhttp://blog.csdn.net/lovenjoy/comments/2580971.aspxhttp://blog.csdn.net/lovenjoy/archive/2008/06/24/2580971.aspx#Feedback0http://blog.csdn.net/lovenjoy/comments/commentRss/2580971.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2580971FireFox 3 插件，addon，<img src ="http://blog.csdn.net/lovenjoy/aggbug/2580971.aspx" width = "1" height = "1" />lovenjoyhttp://blog.csdn.net/lovenjoy/archive/2008/05/29/2492874.aspxThu, 29 May 2008 12:18:00 GMThttp://blog.csdn.net/lovenjoy/archive/2008/05/29/2492874.aspxhttp://blog.csdn.net/lovenjoy/comments/2492874.aspxhttp://blog.csdn.net/lovenjoy/archive/2008/05/29/2492874.aspx#Feedback0http://blog.csdn.net/lovenjoy/comments/commentRss/2492874.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=24928741、运行regedit打开注册表。如果运行不了的话,在windows目录找到regedit.exe 改名为regedit.com,怎么改名你应该知道的,双击后会出来注册表编缉器的,然后.2、在服务中找到Kerberos Key Distribution Centers 服务并停止它。查看进程确保进程列表中只有一个lsass.exe路径为c:\windows\system32。3、在注册表中清除如下健值：[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\WindowsNT\CurrentVersion\Image File ExecutionOptions\]中的cmd.exe、msconfig.exe、regedit.exe、regedt32.exe项。[HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\]中的kkdc项[HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\SharedAccess\Parameters\FirewallPolicy\Sta<img src ="http://blog.csdn.net/lovenjoy/aggbug/2492874.aspx" width = "1" height = "1" />lovenjoyhttp://blog.csdn.net/lovenjoy/archive/2008/05/26/2482228.aspxMon, 26 May 2008 13:31:00 GMThttp://blog.csdn.net/lovenjoy/archive/2008/05/26/2482228.aspxhttp://blog.csdn.net/lovenjoy/comments/2482228.aspxhttp://blog.csdn.net/lovenjoy/archive/2008/05/26/2482228.aspx#Feedback0http://blog.csdn.net/lovenjoy/comments/commentRss/2482228.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2482228问题解决： <br /><br />删除关联的注册表项及重新安装msdtc组件 <br /><br />把下面保存为 msdtc.bat <br /><br />@echo off<br />setlocal<br />@echo %WINDIR%\System32\msdtc.exe -uninstall<br />%WINDIR%\System32\msdtc.exe -uninstall<br />call :delkey "HKCR\CID"<br />call :delkey "HKLM\SYSTEM\CurrentControlSet\Services\MSDTC"<br />call :delkey "HKLM\SYSTEM\ControlSet001\Services\MSDTC"<br />call :delkey "HKLM\SYSTEM\ControlSet002\Services\MSDTC"<br />call :delkey "HKLM\Software\Microsoft\MSDTC"<br />@echo %WINDIR%\System32\msdtc.<img src ="http://blog.csdn.net/lovenjoy/aggbug/2482228.aspx" width = "1" height = "1" />lovenjoyhttp://blog.csdn.net/lovenjoy/archive/2008/03/27/2223286.aspxThu, 27 Mar 2008 16:02:00 GMThttp://blog.csdn.net/lovenjoy/archive/2008/03/27/2223286.aspxhttp://blog.csdn.net/lovenjoy/comments/2223286.aspxhttp://blog.csdn.net/lovenjoy/archive/2008/03/27/2223286.aspx#Feedback0http://blog.csdn.net/lovenjoy/comments/commentRss/2223286.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2223286外部连接和自联接 inner join(等值连接) 只返回两个表中联结字段相等的行 left join(左联接) 返回包括左表中的所有记录和右表中联结字段相等的记录 right join(右联接) 返回包括右表中的所有记录和左表中联结字段相等的记录 on 指定表间联结字段及其关系的等号 "=" 表达式, 返回 true 或 false. 当表达式返回 true 时, 则查询中包含该记录. ! 外部连接只能操作已存在于数据库中的数据<img src ="http://blog.csdn.net/lovenjoy/aggbug/2223286.aspx" width = "1" height = "1" />lovenjoyhttp://blog.csdn.net/lovenjoy/archive/2008/01/30/2072752.aspxWed, 30 Jan 2008 11:49:00 GMThttp://blog.csdn.net/lovenjoy/archive/2008/01/30/2072752.aspxhttp://blog.csdn.net/lovenjoy/comments/2072752.aspxhttp://blog.csdn.net/lovenjoy/archive/2008/01/30/2072752.aspx#Feedback0http://blog.csdn.net/lovenjoy/comments/commentRss/2072752.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2072752通用高效分页存储过程代码<img src ="http://blog.csdn.net/lovenjoy/aggbug/2072752.aspx" width = "1" height = "1" />lovenjoyhttp://blog.csdn.net/lovenjoy/archive/2008/01/15/2044455.aspxTue, 15 Jan 2008 09:03:00 GMThttp://blog.csdn.net/lovenjoy/archive/2008/01/15/2044455.aspxhttp://blog.csdn.net/lovenjoy/comments/2044455.aspxhttp://blog.csdn.net/lovenjoy/archive/2008/01/15/2044455.aspx#Feedback0http://blog.csdn.net/lovenjoy/comments/commentRss/2044455.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2044455看过此贴的人99.9%笑死你！！经典！ <img src ="http://blog.csdn.net/lovenjoy/aggbug/2044455.aspx" width = "1" height = "1" />lovenjoyhttp://blog.csdn.net/lovenjoy/archive/2007/12/26/1968253.aspxWed, 26 Dec 2007 16:00:00 GMThttp://blog.csdn.net/lovenjoy/archive/2007/12/26/1968253.aspxhttp://blog.csdn.net/lovenjoy/comments/1968253.aspxhttp://blog.csdn.net/lovenjoy/archive/2007/12/26/1968253.aspx#Feedback0http://blog.csdn.net/lovenjoy/comments/commentRss/1968253.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1968253系统，游戏，规则，金钱，权利<img src ="http://blog.csdn.net/lovenjoy/aggbug/1968253.aspx" width = "1" height = "1" />lovenjoyhttp://blog.csdn.net/lovenjoy/archive/2007/12/18/1946991.aspxTue, 18 Dec 2007 15:43:00 GMThttp://blog.csdn.net/lovenjoy/archive/2007/12/18/1946991.aspxhttp://blog.csdn.net/lovenjoy/comments/1946991.aspxhttp://blog.csdn.net/lovenjoy/archive/2007/12/18/1946991.aspx#Feedback0http://blog.csdn.net/lovenjoy/comments/commentRss/1946991.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1946991养老保险<img src ="http://blog.csdn.net/lovenjoy/aggbug/1946991.aspx" width = "1" height = "1" />lovenjoyhttp://blog.csdn.net/lovenjoy/archive/2007/11/07/1871467.aspxWed, 07 Nov 2007 13:43:00 GMThttp://blog.csdn.net/lovenjoy/archive/2007/11/07/1871467.aspxhttp://blog.csdn.net/lovenjoy/comments/1871467.aspxhttp://blog.csdn.net/lovenjoy/archive/2007/11/07/1871467.aspx#Feedback0http://blog.csdn.net/lovenjoy/comments/commentRss/1871467.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1871467我的SqlServerHelper.cs全代码<img src ="http://blog.csdn.net/lovenjoy/aggbug/1871467.aspx" width = "1" height = "1" />lovenjoyhttp://blog.csdn.net/lovenjoy/archive/2007/11/07/1871454.aspxWed, 07 Nov 2007 13:39:00 GMThttp://blog.csdn.net/lovenjoy/archive/2007/11/07/1871454.aspxhttp://blog.csdn.net/lovenjoy/comments/1871454.aspxhttp://blog.csdn.net/lovenjoy/archive/2007/11/07/1871454.aspx#Feedback0http://blog.csdn.net/lovenjoy/comments/commentRss/1871454.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1871454向DataSet中追加列<img src ="http://blog.csdn.net/lovenjoy/aggbug/1871454.aspx" width = "1" height = "1" />lovenjoyhttp://blog.csdn.net/lovenjoy/archive/2007/11/07/1871451.aspxWed, 07 Nov 2007 13:37:00 GMThttp://blog.csdn.net/lovenjoy/archive/2007/11/07/1871451.aspxhttp://blog.csdn.net/lovenjoy/comments/1871451.aspxhttp://blog.csdn.net/lovenjoy/archive/2007/11/07/1871451.aspx#Feedback0http://blog.csdn.net/lovenjoy/comments/commentRss/1871451.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1871451正整数，纯数字判断函数<img src ="http://blog.csdn.net/lovenjoy/aggbug/1871451.aspx" width = "1" height = "1" />lovenjoyhttp://blog.csdn.net/lovenjoy/archive/2007/11/07/1871439.aspxWed, 07 Nov 2007 13:30:00 GMThttp://blog.csdn.net/lovenjoy/archive/2007/11/07/1871439.aspxhttp://blog.csdn.net/lovenjoy/comments/1871439.aspxhttp://blog.csdn.net/lovenjoy/archive/2007/11/07/1871439.aspx#Feedback0http://blog.csdn.net/lovenjoy/comments/commentRss/1871439.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1871439用户登录函数<img src ="http://blog.csdn.net/lovenjoy/aggbug/1871439.aspx" width = "1" height = "1" />