<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[昭阳的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/jackson627</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; jackson627]]></copyright><item><title><![CDATA[重写页面中form中的action（隐藏页面地址）]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/6003452</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/6003452</guid><author>jackson627</author><pubDate>Thu, 11 Nov 2010 20:15:00 +0800</pubDate><description><![CDATA[using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
namespace MyAction
{
    /// 
    /// 重新页面中form中的action（用来隐藏页面地址）
    /// 
    public class MyPage : Page
    {
        protected override]]></description><category></category></item><item><title><![CDATA[1.IIS负载均衡--安装应用程序请求路由]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/5935450</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/5935450</guid><author>jackson627</author><pubDate>Tue, 12 Oct 2010 13:15:00 +0800</pubDate><description><![CDATA[1-安装应用程序请求路由窗体顶端首页 > 学习 > 安装和配置 IIS 7 > 应用请求路由模块 > 安装应用程序请求路由安装应用程序请求路由·        发表于 2008 年 7 月 02 的pharr·        2009 年 11 月 05 pharr的更新·        标签: 应用程序请求路由ARR·         打印·         电子邮件·         将保存到收藏夹本主题将导致在 IIS 7.0 上安装 Microsoft 应用程序请求路由（ARR) 版本 1 的步骤通]]></description><category></category></item><item><title><![CDATA[创建临时表（缓存数据集）]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/5787659</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/5787659</guid><author>jackson627</author><pubDate>Wed, 04 Aug 2010 12:01:00 +0800</pubDate><description><![CDATA[<br />--新建临时表
if(object_id('tempdb..#testTable') is null)
	select uid into #testTable from WebUsers
--查询
select * from #testTable
--删除临时表
if(object_id('tempdb..#testTable') is not null)
	drop table #testTable]]></description><category></category></item><item><title><![CDATA[js 防止页面后退]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/5590911</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/5590911</guid><author>jackson627</author><pubDate>Fri, 14 May 2010 13:35:00 +0800</pubDate><description><![CDATA[     onunload=function(){window.location.href=window.location.href;}点击一次后退按钮时OK，要是点击两次时，就后退两步 ]]></description><category></category></item><item><title><![CDATA[sql server 自定义split(分割)函数]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/5589999</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/5589999</guid><author>jackson627</author><pubDate>Fri, 14 May 2010 11:01:00 +0800</pubDate><description><![CDATA[ALTER function [dbo].[split](@SourceSql varchar(8000),@StrSeprate varchar(10))returns @temp table(F1 varchar(100))asbegin    declare @i int    set @SourceSql = rtrim(ltrim(@SourceSql]]></description><category></category></item><item><title><![CDATA[js 时间对比 精确到秒]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/5589282</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/5589282</guid><author>jackson627</author><pubDate>Fri, 14 May 2010 09:23:00 +0800</pubDate><description><![CDATA[function MyFormatTime(str){       var year=str.split(-)[0];    var month=str.split(-)[1];    var date = str.split(-)[2].split( )[0];    var h = str.split(-)[2].split( )[1].spli]]></description><category></category></item><item><title><![CDATA[分享笔记本无线网]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/5449639</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/5449639</guid><author>jackson627</author><pubDate>Sun, 04 Apr 2010 15:58:00 +0800</pubDate><description><![CDATA[第一步：第二步：第三步：O(∩_∩)O~  OK了 ]]></description><category></category></item><item><title><![CDATA[无法在web服务器上启动调试。与web服务器通信时出现身份验证错误]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/5438059</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/5438059</guid><author>jackson627</author><pubDate>Wed, 31 Mar 2010 16:41:00 +0800</pubDate><description><![CDATA[ 禁用环回检查 1.打开注册表（regedit）2. 在注册表编辑器, 找到并单击以下注册表项： HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Lsa3. 右击 Lsa  “新建” 一个 DWORD 值 。4. 命名为 DisableLoopbackCheck然后按 Enter。5. 右击 DisableLoopba]]></description><category></category></item><item><title><![CDATA[IUSR_用户（Internet来宾账号） ]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/5437887</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/5437887</guid><author>jackson627</author><pubDate>Wed, 31 Mar 2010 16:16:00 +0800</pubDate><description><![CDATA[1.匿名访问 Internet 信息服务的内置帐户2.密码是随机生成的。如果更改了“IUSR_用户”账户的密码，就会报错“HTTP 错误 401.1 - 未经授权：访问由于凭据无效被拒绝。” 如果已经更改了“IUSR_用户”账户的密码，补救的办法是：从新设置“IUSR_用户”密码，然后在IIS中从新设置一次匿名账户的密码（如上图）]]></description><category></category></item><item><title><![CDATA[获取本机公网上的IP地址（借助发布在公网上的IP查询网站）]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/5134963</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/5134963</guid><author>jackson627</author><pubDate>Tue, 05 Jan 2010 13:36:00 +0800</pubDate><description><![CDATA[using System.Net;using System.Text;using System.Text.RegularExpressions;private string GetIp()        {            WebClient client = new WebClient();            byte[] bytRecv = client.Do]]></description><category></category></item><item><title><![CDATA[发送Email  C#]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/5130481</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/5130481</guid><author>jackson627</author><pubDate>Mon, 04 Jan 2010 16:59:00 +0800</pubDate><description><![CDATA[          using System.Net.Mail;  MailAddress form = new MailAddress("XXXXX@gmail.com", "我的Gmail");            MailAddress to = new MailAddress("XXXXX@gmail.com");            //邮件           ]]></description><category></category></item><item><title><![CDATA[sql游标]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/5113571</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/5113571</guid><author>jackson627</author><pubDate>Thu, 31 Dec 2009 16:06:00 +0800</pubDate><description><![CDATA[游标的类型：  1、静态游标(不检测数据行的变化）  2、动态游标（反映所有数据行的改变）  3、仅向前游标（不支持滚动）  4、键集游标（能反映修改，但不能准确反映插入、删除）游标使用顺序：   1、定义游标   2、打开游标   3、使用游标   4、关闭游标   5、释放游标Transact-SQL：declare 游标名 cursor []]></description><category></category></item><item><title><![CDATA[T-SQL常用的时间函数]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/5091402</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/5091402</guid><author>jackson627</author><pubDate>Mon, 28 Dec 2009 15:12:00 +0800</pubDate><description><![CDATA[1、本周的星期一     用周(wk)的时间间隔来计算哪一天是本周的星期一。     SELECT  DATEADD(wk,  DATEDIFF(wk,0,getdate()), 0)2、一年的第一天     用年(yy)的时间间隔来显示这一年的第一天。     SELECT  DATEADD(yy,  DATEDIFF(yy,0,getdate()),  0)3、季度的第]]></description><category></category></item><item><title><![CDATA[文件下载（web），把文件写入response流中]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/5070477</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/5070477</guid><author>jackson627</author><pubDate>Thu, 24 Dec 2009 16:42:00 +0800</pubDate><description><![CDATA[    private bool downfile(HttpResponse response,string fullpath)    {           string saveFileName = "";        int intStart = fullpath.LastIndexOf("//") + 1;        saveFileName = fullpath.S]]></description><category></category></item><item><title><![CDATA[c#  向Excel文件写入数据（Workbook 和Worksheet ）]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/5070318</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/5070318</guid><author>jackson627</author><pubDate>Thu, 24 Dec 2009 16:29:00 +0800</pubDate><description><![CDATA[//注意：这个方法在服务器上运行时，服务器必须安装Office//引用using MyExcel=Microsoft.Office.Interop.Excel;using System.Reflection;public void DbExcel(string filepath,DataTable dt)    {            //打开excel模板   ]]></description><category></category></item><item><title><![CDATA[Sql server存储过程中 数据集的缓存]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/5023554</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/5023554</guid><author>jackson627</author><pubDate>Thu, 17 Dec 2009 10:06:00 +0800</pubDate><description><![CDATA[create procedure DeleteWareHouse_StoreArea_SummaryByPUR(@po_no nvarchar(100))as begin	declare @cacheTable table(wh_id int);--声明一个table类型的变量	insert @cacheTable select wh_id from aps_inventory]]></description><category></category></item><item><title><![CDATA[asp.net  客户端缓存(ClientCaching)]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/4912482</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/4912482</guid><author>jackson627</author><pubDate>Tue, 01 Dec 2009 10:16:00 +0800</pubDate><description><![CDATA[using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;public partial class _Default : System.Web.UI.Page{]]></description><category></category></item><item><title><![CDATA[HTTP Header中的内容（请求Header、响应Header）]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/4912176</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/4912176</guid><author>jackson627</author><pubDate>Tue, 01 Dec 2009 09:31:00 +0800</pubDate><description><![CDATA[<!--v/:* {behavior:url(#default#VML);}o/:* {behavior:url(#default#VML);}w/:* {behavior:url(#default#VML);}.shape {behavior:url(#default#VML);}-->   Normal  0        7.8 磅]]></description><category></category></item><item><title><![CDATA[js 获取URL后缀的参数]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/4886857</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/4886857</guid><author>jackson627</author><pubDate>Fri, 27 Nov 2009 10:43:00 +0800</pubDate><description><![CDATA[  var array = window.location.href.split("?");    if ((parseInt(array.length) - parseInt(1)) > 0) {       //有参数        var array1 = array[1].split("&");//？号后面参数部分        if (array1.length > 0)]]></description><category></category></item><item><title><![CDATA[Ext grid添加右击菜单]]></title><link>https://blog.youkuaiyun.com/jackson627/article/details/4872074</link><guid>https://blog.youkuaiyun.com/jackson627/article/details/4872074</guid><author>jackson627</author><pubDate>Wed, 25 Nov 2009 16:40:00 +0800</pubDate><description><![CDATA[grid . addListener ( rowcontextmenu , rightClickFn ); // 右键菜单代码关键部分    //Menu 建立    var rightClick = new Ext . menu . Menu ({        id : rightClickCont , // 在 HTML 文件中必须有个 rightClickCont 的 ]]></description><category></category></item></channel></rss>