<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[小蔡哥的专栏]]></title><description><![CDATA[我喜欢，所以我做！]]></description><link>https://blog.youkuaiyun.com/clm0010</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; clm0010]]></copyright><item><title><![CDATA[MSSQL文本型字段使用replace函数，需转换类型]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/3863233</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/3863233</guid><author>clm0010</author><pubDate>Wed, 04 Feb 2009 23:56:00 +0800</pubDate><description><![CDATA[/*更新图片目录,!*!*!*!注意:news_content必须改为ntext类型,为text类型时会有内部错误,这是个bugreplace替换字段为text或者ntext时,必须转换类型后才能替换*/update news_info set news_content=replace(cast(news_content as varchar(8000)),/uploadfile/,/new]]></description><category></category></item><item><title><![CDATA[页面,跳转]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/3016374</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/3016374</guid><author>clm0010</author><pubDate>Sat, 04 Oct 2008 22:42:00 +0800</pubDate><description><![CDATA[//在当前页面打开location.href="http://www.google.cn/";window.location.href="http://www.google.cn/";//后退到前一页面history.go(-1);//在新页面打开window.open(http://www.google.cn/,,height=500,width=611,scr]]></description><category></category></item><item><title><![CDATA[?:判断]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/2497696</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/2497696</guid><author>clm0010</author><pubDate>Fri, 30 May 2008 23:32:00 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[?:判断]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/2497691</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/2497691</guid><author>clm0010</author><pubDate>Fri, 30 May 2008 23:30:00 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[使用DataReader提高性能的一些技巧]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/2484271</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/2484271</guid><author>clm0010</author><pubDate>Mon, 26 May 2008 22:40:00 +0800</pubDate><description><![CDATA[下面是使用DataReader提高性能的一些技巧： 　　l 在访问任何与命令（Command）相关的输出参数前DataReader必须关闭。 　　l 在读完数据后就关闭DataReader。如果你正在使用的连接只返回该DataReader，在关闭DataReader后立即关闭连接。 　　l 另一种明确地关闭连接的方法是给ExecuteReader方法传递CommandBehavior.CloseC]]></description><category></category></item><item><title><![CDATA[一行样式，网站都变成灰色]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/2458857</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/2458857</guid><author>clm0010</author><pubDate>Mon, 19 May 2008 17:06:00 +0800</pubDate><description><![CDATA[一行样式，网站都变成灰色*{filter:Gray;}]]></description><category></category></item><item><title><![CDATA[Win2003主机下无法播放FLV视频的设置方法]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/2451147</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/2451147</guid><author>clm0010</author><pubDate>Fri, 16 May 2008 12:01:00 +0800</pubDate><description><![CDATA[默认情况下，Win2003的主机.是没有指定输出FLV这种格式的。虽然FTP里面可以看见,但无法通过http访问,也就无法播放了。三种解决办法:一、找服务器管理员,添加FLV文件类型输出支持。　　1. 在windows 2003 server 打开IIS管理器　　2. 展开本地服务器　　3. 右键点击本地服务器选择属性　　4. 选择 MIME Type　　5. 点击New 输入以下信息]]></description><category></category></item><item><title><![CDATA[SQL语句参数化]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/2451027</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/2451027</guid><author>clm0010</author><pubDate>Fri, 16 May 2008 11:36:00 +0800</pubDate><description><![CDATA[SELECT AuthorID, Name, Adress FROM Author WHERE (Abrige = @Param2)  sqlDataAdapter1.SelectCommand.Parameters["Param2"].Value = Abrige_txt.Text;比如参数的sql的like是这样写的 字段 like @参数名@参数名=%农业%是不用写成%农业]]></description><category></category></item><item><title><![CDATA[ASP.net防止SQL注入方法 ]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/2451011</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/2451011</guid><author>clm0010</author><pubDate>Fri, 16 May 2008 11:33:00 +0800</pubDate><description><![CDATA[大家存在5点误区： 1、sql注入比较难防，需要替换select,delete等一打字符 其实对于字符型替换再多都没有替换单引号为两个单引号来的好！对于数字型替换再多都没有用，一定要类型转换。 2、忽略DropDownList传来的东西 其实是不对的，一切客户端的东西都是不可信任的，select下拉框也是！因为可以自己做一个htm提交到服务器。 3、access比sqlserver不安全 安全不安]]></description><category></category></item><item><title><![CDATA[javascript如何调用C#后代码中的过程 和ASP.NET调用JS乱码解决方案]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/2399677</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/2399677</guid><author>clm0010</author><pubDate>Tue, 06 May 2008 11:14:00 +0800</pubDate><description><![CDATA[ +++++++++++++++++第一种情况： 1.后台方法： protected string CsharpVoid(string strCC){  return strCC; } 2.javascript 调用   var s = "";     document.write(s);    +++++++++++++++++第二种情况： 1.后代码：protected v]]></description><category></category></item><item><title><![CDATA[页面自动刷新]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/2344884</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/2344884</guid><author>clm0010</author><pubDate>Tue, 29 Apr 2008 22:32:00 +0800</pubDate><description><![CDATA[自动刷新setTimeout("location.href=66.htm",100);]]></description><category></category></item><item><title><![CDATA[[关闭窗口]]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/2344837</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/2344837</guid><author>clm0010</author><pubDate>Tue, 29 Apr 2008 22:22:00 +0800</pubDate><description><![CDATA[[关闭窗口]]]></description><category></category></item><item><title><![CDATA[从标签中提取参数（数组）]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/2234531</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/2234531</guid><author>clm0010</author><pubDate>Tue, 01 Apr 2008 01:02:00 +0800</pubDate><description><![CDATA[protected void rp()    {        string t="aaaaaaaaaaaaaa{$link(20085,35502)$}bbbbbbbbbbbb";        Response.Write("测试来了");        Response.Write("原始标签"+ t + "");        int a1=t.IndexOf("{$link(");   ]]></description><category></category></item><item><title><![CDATA[asp计算两个时间内的工作日]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/1888186</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/1888186</guid><author>clm0010</author><pubDate>Fri, 16 Nov 2007 12:00:00 +0800</pubDate><description><![CDATA[****************************** 函数：workdays(date_begin , date_end) 参数：date_begin,开始日期；date_end,结束日期AddArray,特定假日数组;自定义工作日数组SArray,日期：2007/11/16 描述：计算两个时间内的工作日 作者：小蔡哥示例：workdays("2007-05-18" , "2]]></description><category></category></item><item><title><![CDATA[repeater嵌套]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/1856100</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/1856100</guid><author>clm0010</author><pubDate>Tue, 30 Oct 2007 10:42:00 +0800</pubDate><description><![CDATA[例子一：.aspx                                   ">   大类                                                                                     ">   小类                                                     ]]></description><category></category></item><item><title><![CDATA[select case 语句]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/1474270</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/1474270</guid><author>clm0010</author><pubDate>Thu, 04 Jan 2007 22:50:00 +0800</pubDate><description><![CDATA[SELECT ID,       (CASE WHEN tj = 2 THEN -- + FolderName WHEN tj = 3 THEN --- + foldername ELSE foldername       END) AS new_foldername, TS, TN, TJFROM KS_Class ]]></description><category></category></item><item><title><![CDATA[IE图标显示]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/1422391</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/1422391</guid><author>clm0010</author><pubDate>Thu, 30 Nov 2006 15:25:00 +0800</pubDate><description><![CDATA[ ]]></description><category></category></item><item><title><![CDATA[asp.net把utf-8编码转换为gb2312编码]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/1421844</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/1421844</guid><author>clm0010</author><pubDate>Thu, 30 Nov 2006 11:11:00 +0800</pubDate><description><![CDATA[最近在做的系统中，碰到了一个问题，交易系统采用的utf-8编码，而一些支持系统使用的是gb2312编码。不同编码的页面、脚本之间互相引用，就会产生乱码的问题，解决方法就是统一成一种编码。asp.net 中，如果要修改输出页面的编码，可以通过修改web.config中以下配置信息以上只是修改整体的默认编码，如果只有某个页的编码需要修改，asp.net 中则可以简单的使用下面代码：注:加到]]></description><category></category></item><item><title><![CDATA[C#字符串的使用笔记]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/587521</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/587521</guid><author>clm0010</author><pubDate>Tue, 24 Jan 2006 14:59:00 +0800</pubDate><description><![CDATA[                        C#字符串的使用笔记                                                                                                                                              ]]></description><category></category></item><item><title><![CDATA[时间处理:字符串转换成时间]]></title><link>https://blog.youkuaiyun.com/clm0010/article/details/586164</link><guid>https://blog.youkuaiyun.com/clm0010/article/details/586164</guid><author>clm0010</author><pubDate>Sun, 22 Jan 2006 14:25:00 +0800</pubDate><description><![CDATA[ Label6.Text=Convert.ToDateTime(dr["f3_date"].ToString()).ToShortDateString().ToString();DateTime.Now.tostring() Convert.ToDateTime(Eval("addDate")).ToString("MM-dd")]]></description><category></category></item></channel></rss>