<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Ricky_66的专栏]]></title><description><![CDATA[放飞你的梦想]]></description><link>https://blog.youkuaiyun.com/Ricky_66</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Ricky_66]]></copyright><item><title><![CDATA[ORACLE实用小记]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/6656340</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/6656340</guid><author>Ricky_66</author><pubDate>Wed, 03 Aug 2011 12:12:34 +0800</pubDate><description><![CDATA[本人刚接触ORACLE数据库，总结一些实用语法及解决方案：

ORACLE SELECT语句使用注意点：
1、字段的合并显示
   通常SQL SERVER字段显示合并，我们使用的是'+'，例如：
   SELECT a+'-'+bas ab FROM TABLE]]></description><category></category></item><item><title><![CDATA[JavaScript计算两个日期相差天数，周数]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/6640828</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/6640828</guid><author>Ricky_66</author><pubDate>Thu, 28 Jul 2011 14:03:32 +0800</pubDate><description><![CDATA[//返回两个日期相差的天数
function WeeksBetw(date1,date2)
{
//这里的date1、date2为日期的字符串
//将date1,date2转换为Date对象
var _dt1=new Date(date1);
var _dt2=new Date(]]></description><category></category></item><item><title><![CDATA[一条SQL语句 判断某个表中是否存在某个栏位！！]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/6597597</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/6597597</guid><author>Ricky_66</author><pubDate>Mon, 11 Jul 2011 14:27:13 +0800</pubDate><description><![CDATA[首先要进入到该表的所在的库中USE DB_Nameselect count(name) from syscolumns where id=(select id from sysobjects where name='表名') and name='栏位名称' 若输出=0，則栏位名称]]></description><category></category></item><item><title><![CDATA[ASP导出到Excel文档]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/6597591</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/6597591</guid><author>Ricky_66</author><pubDate>Mon, 11 Jul 2011 14:24:35 +0800</pubDate><description><![CDATA[xmlns:o="urn:schemas-microsoft-com:office:office"xmlns:x="urn:schemas-microsoft-com:office:excel"xmlns="http://www.w3.org/TR/REC-html40">'Re]]></description><category></category></item><item><title><![CDATA[JavaScript实现Iframe自适应高度]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/6597589</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/6597589</guid><author>Ricky_66</author><pubDate>Mon, 11 Jul 2011 14:23:01 +0800</pubDate><description><![CDATA[此段代码的功用如题。function resizeIframes(){document.getElementById("iframe1").style.height=document.getElementById("iframe1").contentWindow.document]]></description><category></category></item><item><title><![CDATA[SQL SERVER数据库 LINK ORACLE数据库 如何实现在SQL SERVER查询分析器中对ORACLE查询]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/6597573</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/6597573</guid><author>Ricky_66</author><pubDate>Mon, 11 Jul 2011 14:21:31 +0800</pubDate><description><![CDATA[本文采用的是Sql Server 中的OpenQuery函数来实现对ORACLE数据库交互OPENQUERY ( linked_server ,'query' ) 参数linked_server表示链接服务器名称的标识符。' query '在链接服务器中执行的查询字符串。该字符串]]></description><category></category></item><item><title><![CDATA[DataGrid分页显示复选框选中]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/5911962</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/5911962</guid><author>Ricky_66</author><pubDate>Tue, 28 Sep 2010 14:30:00 +0800</pubDate><description><![CDATA[<br />我们都曾做过DataGrid的分页实现，使用.NET中的控件非常简单，但如果在DataGrid中添加一个模板列，内部放一个CheckBox的话，
转到下一页再转回则会发现原来选中的内容已经没有了！以下的演示是在.NET2005中使用GridView控件实现的分页后实现复选框多选功能，请先观
察代码！
<br /> <br />Default.aspx<br /><%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.]]></description><category></category></item><item><title><![CDATA[ JavaScript高级应用]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/5911781</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/5911781</guid><author>Ricky_66</author><pubDate>Tue, 28 Sep 2010 13:41:00 +0800</pubDate><description><![CDATA[//各种尺寸 s  +=  "/r/n网页可见区域宽："+  document.body.clientWidth;   s  +=  "/r/n网页可见区域高："+  document.body.clientHeight;   s  +=  "/r/n网页可见区域高："+  document.body.offsetWeight  +"  (包括边线的宽)";   s  +=  "/r/n网页可见区域高："+  document.body.offsetHeight  +"  (包括边线的宽)";   s  +]]></description><category></category></item><item><title><![CDATA[Asp.net中防止用户多次登录的方法]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/5911755</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/5911755</guid><author>Ricky_66</author><pubDate>Tue, 28 Sep 2010 13:28:00 +0800</pubDate><description><![CDATA[在web开发时，有的系统要求同一个用户在同一时间只能登录一次，也就是如果一个用户已经登录了，在退出之前如果再次登录的话需要报错。　　常见的处理方法是，在用户登录时，判断此用户是否已经在Application中存在，如果存在就报错，不存在的话就加到Application中(Application是所有Session共有的，整个web应用程序唯一的一个对象)：string strUserId = txtUser.Text; ArrayList list = Application.Get("GLOBAL_USE]]></description><category></category></item><item><title><![CDATA[asp连接数据库大全]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/5911732</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/5911732</guid><author>Ricky_66</author><pubDate>Tue, 28 Sep 2010 13:18:00 +0800</pubDate><description><![CDATA[Function GetMdbConnection( FileName )   Dim Provider, DBPath   Provider = "Provider=Microsoft.Jet.OLEDB.4.0;"   DBPath = "Data Source=" & Server.MapPath(FileName)   Set GetMdbConnection = GetConnection( Provider & DBPath )End Function'---------------------]]></description><category></category></item><item><title><![CDATA[js一些用法及几个常用的ASP代码]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/5911727</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/5911727</guid><author>Ricky_66</author><pubDate>Tue, 28 Sep 2010 13:15:00 +0800</pubDate><description><![CDATA[3.获得系统,浏览器版本:4.去除IE混动条:5.进入网站,跳出广告:6.随机数:]]></description><category></category></item><item><title><![CDATA[ORACLE使用注意事項总结]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/5911719</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/5911719</guid><author>Ricky_66</author><pubDate>Tue, 28 Sep 2010 13:11:00 +0800</pubDate><description><![CDATA[ORACLE SELECT語句使用注意點：1、欄位的合併顯示   通常SQL SERVER欄位顯示合併，我們使用的是'+'，例如：   SELECT a+'-'+b as ab FROM TABLE   而ORACLE的欄位合併顯示，使用的就不是'+',而是'||',例如：   SELECT a||'-'|| as ab FROM TABLE2、資料庫的匯出：cmd：exp   system/password@databaeServername     owner=system   direct=y   f]]></description><category></category></item><item><title><![CDATA[解決Windows 2003自带的IIS上傳文檔限制]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/5911716</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/5911716</guid><author>Ricky_66</author><pubDate>Tue, 28 Sep 2010 13:08:00 +0800</pubDate><description><![CDATA[Windows 2003自带的IIS 6.0出于安全考虑，限制ASP上传的文件大小为200K，但日常做的网站随便传点东西就大于200K的，所以遇到2003的机器总需要自己去改。虽然改动不大，但找改动点的时候却是很麻烦的。　前几天没事时偶然看到了一个改200K限制的VBS脚本，用它改可就方便多了。　　把以下内容另存为.vbs文件然后双击就可以运行了:set obj1=GetObject("winmgmts:/root/MicrosoftIISv2")set obj2=obj1.get("IIsWebVirtu]]></description><category></category></item><item><title><![CDATA[Javascrpt获取页面的传递的参数,超简单更新【2种方法】]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/5003636</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/5003636</guid><author>Ricky_66</author><pubDate>Mon, 14 Dec 2009 13:27:00 +0800</pubDate><description><![CDATA[请注意此方法仅对GET方式提交有效！！！ function getParameterValue(parameter){var hrefstr,pos,parastr,para,tempstr,str="";   hrefstr = window.location.href;   //获取浏览器中URL地址   pos = hrefstr.indexOf("?");   //检索参数]]></description><category></category></item><item><title><![CDATA[图形验证功能：后台实现和前段JAVASCRIPT实现]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/5002727</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/5002727</guid><author>Ricky_66</author><pubDate>Mon, 14 Dec 2009 10:52:00 +0800</pubDate><description><![CDATA[//创建一个类文件，将下面代码保存其中，命名位Code.csusing System.Text;using System;using System.Web;using System.IO;using System.Drawing;using System.Drawing.Imaging;/// ///Code 的摘要说明/// public class Co]]></description><category></category></item><item><title><![CDATA[ASP.NET URL重写做法]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/4980892</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/4980892</guid><author>Ricky_66</author><pubDate>Thu, 10 Dec 2009 17:30:00 +0800</pubDate><description><![CDATA[下载完成后，在web.config里设置如下：                                                        ~/d(/d+)/.aspx                ~/default.aspx?id=$1                                                             其中]]></description><category></category></item><item><title><![CDATA[JavaScript:文本框长度限制20个字节，中文位2个字节]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/4980887</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/4980887</guid><author>Ricky_66</author><pubDate>Thu, 10 Dec 2009 17:29:00 +0800</pubDate><description><![CDATA[限制一个Textbox的长度为 20个字节,如果是中文则计算为2个字节。下面用前台JavaScript脚本实现的代码：http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">http://www.w3.org/1999/xhtml" >    未命名頁面             function Chck()        ]]></description><category></category></item><item><title><![CDATA[JAVASCRIPT 自定义onchange事件]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/4980878</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/4980878</guid><author>Ricky_66</author><pubDate>Thu, 10 Dec 2009 17:27:00 +0800</pubDate><description><![CDATA[注：将下面一段代码在整个页面加载完成后执行！！！自定义实现onchange事件！！！function LoadEvent(func){var oldonload = window.onload;if (typeof window.onload != function) { window.onload = func;} else {window.onload = function() {]]></description><category></category></item><item><title><![CDATA[将DataSet数据集导入CSV后缀文件中]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/2506402</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/2506402</guid><author>Ricky_66</author><pubDate>Tue, 03 Jun 2008 10:01:00 +0800</pubDate><description><![CDATA[#region 將DATASET導出到CSV格式文檔中        private string Save_CSV(DataSet ds)        {            //準備一個變量            string str_Data = "";foreach (DataTable dt in ds.Tables)         ]]></description><category></category></item><item><title><![CDATA[将图片等比例缩小不影响图片的分辨率]]></title><link>https://blog.youkuaiyun.com/Ricky_66/article/details/2506376</link><guid>https://blog.youkuaiyun.com/Ricky_66/article/details/2506376</guid><author>Ricky_66</author><pubDate>Tue, 03 Jun 2008 09:55:00 +0800</pubDate><description><![CDATA[#region 生成缩略图    ///     /// 生成缩略图    ///     /// 传入图片的路径    private void SaveImage(string filePath)    {        string fileName = Path.GetExtension(File1.PostedFile.FileName).ToLower();]]></description><category></category></item></channel></rss>