<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[jiva1的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/jiva1</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; jiva1]]></copyright><item><title><![CDATA[SQL Server死锁总结]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/7062257</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/7062257</guid><author>jiva1</author><pubDate>Mon, 12 Dec 2011 04:23:31 +0800</pubDate><description><![CDATA[SQL Server死锁总结


  1. 死锁原理
    根据操作系统中的定义：死锁是指在一组进程中的各个进程均占有不会释放的资源，但因互相申请被其他进程所站用不会释放的资源而处于的一种永久等待状态。
    死锁的四个必要条件：
互斥条件(Mutual exclusion)：资源不能被共享，只能由一个进程使用。
请求与保持条件(Hold and wait)：已经得到资源的进程可]]></description><category></category></item><item><title><![CDATA[SQL  支持两个分格符]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/6799264</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/6799264</guid><author>jiva1</author><pubDate>Thu, 22 Sep 2011 08:53:00 +0800</pubDate><description><![CDATA[USE [alisoft]
GO
/****** Object:  UserDefinedFunction [dbo].[split]    Script Date: 09/22/2011 08:49:26 ******/
SET ANSI_NULLS ON
GO
SE]]></description><category></category></item><item><title><![CDATA[对web.config进行新增修改删除读取操作 ]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/6082191</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/6082191</guid><author>jiva1</author><pubDate>Fri, 17 Dec 2010 14:30:00 +0800</pubDate><description><![CDATA[1.建立一个class，ReadWriteConfig.cs
using System;
using System.Configuration;
using System.Reflection;
using System.Web;
using System.Xml;
public enum ConfigFileType
{
    WebConfig,
    AppConfig
}

namespace WebApplication1
{
    /**//// 
    /]]></description><category></category></item><item><title><![CDATA[Inno Setup详细教程]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/6014191</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/6014191</guid><author>jiva1</author><pubDate>Wed, 17 Nov 2010 10:47:00 +0800</pubDate><description><![CDATA[<br />一.关于Inno Setup如何在安装时播放音乐<br />方法（1）：<br />在脚本编译里的[Code]与[Files]段处添加以下代码：<br />[Code]<br />Function mciSendString(lpszCommand: String; lpszReturnString: Integer; cchReturnLength: Integer; hwndCallback: Integer): Integer;<br />external 'mciSendStringA@]]></description><category></category></item><item><title><![CDATA[Inno setup 常用代码收集]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/6014185</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/6014185</guid><author>jiva1</author><pubDate>Wed, 17 Nov 2010 10:44:00 +0800</pubDate><description><![CDATA[<br />1.安装卸载前检测软件是否在运行<br />说明：安装前用FindWindowByClassName检测迅雷程序是否在运行，注意这个循环语句。<br />用MicroSoft spy++找有关的程序的ClassName，迅雷的class是TfrmCmdCenter（本人是以TfrmCmdCenter来检测迅雷是否在运行的）。<br />ps:其实本文没什么创新，只是因为我首次使用MicroSoft spy++来找程序的ClassName，发现那些只在前台运行的程序的ClassName非常好找，而]]></description><category></category></item><item><title><![CDATA[INNO Setup 使用笔记]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/6014109</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/6014109</guid><author>jiva1</author><pubDate>Wed, 17 Nov 2010 10:23:00 +0800</pubDate><description><![CDATA[<br />[Setup]<br />AppName={#MyAppName}<br />AppVerName={#MyAppVerName}<br />AppPublisher={#MyAppPublisher}<br />AppPublisherURL={#MyAppURL}<br />AppSupportURL={#MyAppURL}<br />AppUpdatesURL={#MyAppURL}<br />DefaultDirName={pf}/My Programee<br />DefaultGro]]></description><category></category></item><item><title><![CDATA[INNO Setup 使用笔记]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/6014108</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/6014108</guid><author>jiva1</author><pubDate>Wed, 17 Nov 2010 10:23:00 +0800</pubDate><description><![CDATA[<br />[Setup]<br />AppName={#MyAppName}<br />AppVerName={#MyAppVerName}<br />AppPublisher={#MyAppPublisher}<br />AppPublisherURL={#MyAppURL}<br />AppSupportURL={#MyAppURL}<br />AppUpdatesURL={#MyAppURL}<br />DefaultDirName={pf}/My Programee<br />DefaultGro]]></description><category></category></item><item><title><![CDATA[Inno Setup  打包工具 调用MSI格式]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/6014101</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/6014101</guid><author>jiva1</author><pubDate>Wed, 17 Nov 2010 10:21:00 +0800</pubDate><description><![CDATA[<br /><br />[Code]<br /> procedure InstallDb;<br /> var<br />Path:string;<br />Path1:string;<br />Path2:string;<br />Path3:string;<br />Path4:string;<br />ResultCode: Integer;<br />RegPath:string;<br />CrystalReportsPath:string;<br />CrystalReportsChsPath:]]></description><category></category></item><item><title><![CDATA[正规表达式识别图片地址 并下载]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/5968252</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/5968252</guid><author>jiva1</author><pubDate>Wed, 27 Oct 2010 01:06:00 +0800</pubDate><description><![CDATA[private void GetPic(string htmlCode,string OutPath)        {            string pattern = @"={1}[/w/W][^=]+?(.jpg|.bmp|.gif|.png|.jpeg)";            RegexOptions options = RegexOptions.None;            Regex regex = new Regex(pattern, options);            M]]></description><category></category></item><item><title><![CDATA[C# 修改注册表]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/5660306</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/5660306</guid><author>jiva1</author><pubDate>Thu, 10 Jun 2010 09:24:00 +0800</pubDate><description><![CDATA[ static void Main(string[] args)
        {
            Console.Title = "修复注册表";
            try
            {
                //高级---通过HTTP 1.1设置  通过代理连接使用 HTTP 1.1√去掉
                RegistryKey rkey = Registry.CurrentUser.OpenSubKey(@"Software//Mic]]></description><category></category></item><item><title><![CDATA[System.DataTime.Now.ToString()的各种格式]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/5630271</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/5630271</guid><author>jiva1</author><pubDate>Fri, 28 May 2010 11:41:00 +0800</pubDate><description><![CDATA[Asp.net中的日期处理函数     //2007年4月24日     this.TextBox6.Text = System.DateTime.Now.ToString("D");     //2007-4-24     this.TextBox7.Text = System.DateTime.Now.ToString("d");     //2007年4月24日 16:3]]></description><category></category></item><item><title><![CDATA[C#时间格式转换、日期操作函数、常用转换语法]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/5623346</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/5623346</guid><author>jiva1</author><pubDate>Tue, 25 May 2010 17:17:00 +0800</pubDate><description><![CDATA[字符型转换为字符串// C 货币2.5.ToString("C"); // ￥2.50// D 10进制数25.ToString("D5"); // 25000// E 科学型25000.ToString("E"); // 2.500000E+005// F 固定点25.ToString("F2"); // 25.00// G 常规2.5.ToString(]]></description><category></category></item><item><title><![CDATA[Sandcastle初探——官方版的NDoc ]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/5619995</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/5619995</guid><author>jiva1</author><pubDate>Mon, 24 May 2010 14:14:00 +0800</pubDate><description><![CDATA[  Sandcastle初探——官方版的NDocSandcastle（CodeName）是微软出的用于编译发布组件（Assembly）信息的一个工具，基本上等同于NDoc（后者目前已经停止开发，最新版本仍然不支持.Net 2.0）。这个工具通过反射和Xslt技术，可以从dll文件及其xml注释（编译时加/doc参数得到），得到一个完整的帮助文档，格式可以是Html或CHM甚至是任何自定义的]]></description><category></category></item><item><title><![CDATA[使用c#打开文件（夹）及选中文件]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/5613708</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/5613708</guid><author>jiva1</author><pubDate>Fri, 21 May 2010 12:31:00 +0800</pubDate><description><![CDATA[引用：using System.Diagnostics;打开文件夹：System.Diagnostics.Process.Start(FilePath);打开文件夹中某个文件：System.Diagnostics.Process.Start(FilePath+"/"+FileName);打开文件夹并选中单个文件：System.Diagnostics.Process.Star]]></description><category></category></item><item><title><![CDATA[mysql数据Unix时间戳与C# DateTime时间类型互换]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/5604963</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/5604963</guid><author>jiva1</author><pubDate>Tue, 18 May 2010 17:49:00 +0800</pubDate><description><![CDATA[Unix时间戳最小单位是秒，开始时间为格林威治标准时间1970-01-01 00:00:00ConvertIntDateTime方法的基本思路是通过获取本地时区表示Unixk开始时间，加上Unix时间值（即过去的秒数）. ConvertDateTimeInt方法的基本思路是通过刻度数差，再把刻度数转换为秒数，当然要说明的是，我这里返回的是double类型，意义上并非是真正的Unix时间戳格式。要获]]></description><category></category></item><item><title><![CDATA[常用正则表达式]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/5601407</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/5601407</guid><author>jiva1</author><pubDate>Mon, 17 May 2010 18:08:00 +0800</pubDate><description><![CDATA["^/d+$"　　//非负整数（正整数 + 0） "^[0-9]*[1-9][0-9]*$"　　//正整数 "^((-/d+)|(0+))$"　　//非正整数（负整数 + 0） "^-[0-9]*[1-9][0-9]*$"　　//负整数 "^-?/d+$"　　　　//整数 "^/d+(/./d+)?$"　　//非负浮点数（正浮点数 + 0） "^(([0-9]+/.[0-9]*[1-9][0-9]]]></description><category></category></item><item><title><![CDATA[几个删除重复记录的SQL语句]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/5572284</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/5572284</guid><author>jiva1</author><pubDate>Sun, 09 May 2010 17:10:00 +0800</pubDate><description><![CDATA[比如现在有一人员表  （表名：peosons）若想将姓名、身份证号、住址这三个字段完全相同的记录查询出来 select   p1.*   from   persons   p1,persons   p2   where   p1.id可以实现上述效果． 几个删除重复记录的SQL语句 1.用rowid方法 2.用group by方法 3.用distinct方法 1。用rowid方]]></description><category></category></item><item><title><![CDATA[[图文]手把手教你用C#打包应用程序(安装程序)【卸载模块已添加】]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/5561868</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/5561868</guid><author>jiva1</author><pubDate>Thu, 06 May 2010 09:13:00 +0800</pubDate><description><![CDATA[声明:软件平台:VisualStudio2005中文版(在03下操作雷同).1:新建安装部署项目打开VS,点击新建项目,选择:其他项目类型->安装和部署->安装向导(安装项目也相同),然后点击确定.(周详见下图)2:安装向导关闭后打开安装向导,点击下一步,或直接点击完成.如下图:3:开始制作安装向导完成后即可进入项目文档夹:双击"应用程式文档夹"在右边的空白处右击,选择添加->文档]]></description><category></category></item><item><title><![CDATA[线程间操作无效: 从不是创建控件“**”的线程访问它   利用委托处理]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/5554845</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/5554845</guid><author>jiva1</author><pubDate>Tue, 04 May 2010 10:40:00 +0800</pubDate><description><![CDATA[System.Threading.Thread th;                        public delegate void SetValueEventHandler(Label label, string text);               private void btnUpdate_Click(object sender, EventArgs e)        ]]></description><category></category></item><item><title><![CDATA[收藏网址]]></title><link>https://blog.youkuaiyun.com/jiva1/article/details/5545270</link><guid>https://blog.youkuaiyun.com/jiva1/article/details/5545270</guid><author>jiva1</author><pubDate>Fri, 30 Apr 2010 10:32:00 +0800</pubDate><description><![CDATA[www.gliffy.com 页面画图编辑 ]]></description><category></category></item></channel></rss>