<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[merry3688的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/merry3688</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; merry3688]]></copyright><item><title><![CDATA[office 自带excel内容变动比较【Spreadsheet Compare】]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/121679202</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/121679202</guid><author>merry3688</author><pubDate>Thu, 02 Dec 2021 15:54:00 +0800</pubDate><description><![CDATA[C:\Program Files (x86)\Microsoft Office\root\Office16\DCF\SPREADSHEETCOMPARE.EXE




]]></description><category></category></item><item><title><![CDATA[c#用EPPLUS操作excel]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/121678544</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/121678544</guid><author>merry3688</author><pubDate>Thu, 02 Dec 2021 15:33:54 +0800</pubDate><description><![CDATA[c#用EPPLUS操作excel - 猪冰龙 - 博客园
]]></description><category></category></item><item><title><![CDATA[c#通过账号密码访问网络路径的方法]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/108462070</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/108462070</guid><author>merry3688</author><pubDate>Tue, 08 Sep 2020 09:38:01 +0800</pubDate><description><![CDATA[1

			2

			3

			4

			5

			6

			7

			8

			9

			10

			11

			12

			13
			
			
			//访问路径登录信息

			string_Server =@"192.168.0.95";

			string_ID ="administrator";

			string_Password ="testadmin";

			using(SharedTool tool =newSharedTool(...]]></description><category></category></item><item><title><![CDATA[vb.net按字节截取字符串代码]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/105449831</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/105449831</guid><author>merry3688</author><pubDate>Sat, 11 Apr 2020 11:50:43 +0800</pubDate><description><![CDATA['■MidB
'''&lt;summary&gt;Mid関数のバイト版。文字数と位置をバイト数で指定して文字列を切り抜く。&lt;/summary&gt;'''&lt;param name="str"&gt;対象の文字列&lt;/param&gt;'''&lt;param name="Start"&gt;切り抜き開始位置。全角文字を分割するよう位置が指定された場合、戻り値の文字列の先頭は意味...]]></description><category></category></item><item><title><![CDATA[farpoint Spread 常用事件]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/104636958</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/104636958</guid><author>merry3688</author><pubDate>Tue, 03 Mar 2020 17:25:41 +0800</pubDate><description><![CDATA[1//单元格编辑结束，焦点离开或者按回车键时 比如：你要判断当前单元格输入内容是否合法。
privatevoidfpSpread1_EditModeOff(objectsender, System.EventArgs e)






2//单元格得到焦点时触发
privatevoidfpSpread1_EnterCell(objectsender, FarPoint....]]></description><category></category></item><item><title><![CDATA[apache启动报错AH00526解决方法]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/101457912</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/101457912</guid><author>merry3688</author><pubDate>Thu, 26 Sep 2019 17:51:19 +0800</pubDate><description><![CDATA[AH00526: Syntax error on line 580 of E:/Bitnami/redmine-4.0.4-5/apache2/conf/httpd.conf:
SetEnv takes 1-2 arguments, an environment variable name and optional value to pass to CGI.

打开httpd.conf，找到580...]]></description><category></category></item><item><title><![CDATA[App.config 文件读写]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/95460017</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/95460017</guid><author>merry3688</author><pubDate>Thu, 11 Jul 2019 11:28:24 +0800</pubDate><description><![CDATA[ConfigurationManagerClass

定义

命名空间:

System.Configuration

Assemblies:

System.Configuration.dll, System.Configuration.ConfigurationManager.dll

提供对客户端应用程序配置文件的访问。此类不能被继承。

C#复制


public static cla...]]></description><category></category></item><item><title><![CDATA[按字节截取字符串]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/89851035</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/89851035</guid><author>merry3688</author><pubDate>Sun, 05 May 2019 17:19:28 +0800</pubDate><description><![CDATA[按字节截取字符串



1.日本网站上使用的一种方法



select substring(CAST(カラム as TEXT),n,m)



2.个人经常使用的方法



select Cast('中文z哈hongwen123' As varchar(7)) as ee



3.和cast相同的一种



select convert(varchar(200), substri...]]></description><category></category></item><item><title><![CDATA[知道这20个正则表达式，能让你少写1,000行代码]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/62038525</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/62038525</guid><author>merry3688</author><pubDate>Tue, 14 Mar 2017 10:50:45 +0800</pubDate><description><![CDATA[﻿﻿
正则表达式，一个十分古老而又强大的文本处理工具，仅仅用一段非常简短的表达式语句，便能够快速实现一个非常复杂的业务逻辑。熟练地掌握正则表达式的话，能够使你的开发效率得到极大的提升。
正则表达式经常被用于字段或任意字符串的校验，如下面这段校验基本日期格式的JavaScript代码：
var reg = /^(\\d{1,4})(-|\\/)(\\d{1,2})\\2(\\d{1,2})$/]]></description><category></category></item><item><title><![CDATA[VB编程的调用带参数的exe]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/55049872</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/55049872</guid><author>merry3688</author><pubDate>Mon, 13 Feb 2017 16:07:15 +0800</pubDate><description><![CDATA[﻿﻿



这个软件的原本参数是
FastCopy.exe /cmd=sync /open_window "c:\123.mp3" /to="d:\"

我
在vb里调用就出了问题
a= "c:\123.mp3"
b="d:\"
SHELL
 "FastCopy.exe /cmd=sync /open_window " & chr(34) & a & chr(34) & "]]></description><category></category></item><item><title><![CDATA[主干(trunk)、分支(branch )、标记(tag) 用法示例 + 图解]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/53420173</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/53420173</guid><author>merry3688</author><pubDate>Thu, 01 Dec 2016 12:49:38 +0800</pubDate><description><![CDATA[﻿﻿
财经大爆炸 2016-11-30 19:05

以svn为例，git的master相当于trunk，dev分支相当于branches
------------------------------------------------------------------------------------------------------------------------------]]></description><category></category></item><item><title><![CDATA[ASP.NET Core 开发-Logging 使用NLog 写日志文件]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/52064214</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/52064214</guid><author>merry3688</author><pubDate>Fri, 29 Jul 2016 14:00:05 +0800</pubDate><description><![CDATA[ASP.NET Core 开发-Logging 使用NLog 写日志文件。

NLog 可以适用于 .NET Core 和 ASP.NET Core 。

ASP.NET Core已经内置了日志支持,可以轻松输出到控制台。

学习Logging 组件的相关使用，使用NLog 将日志写入到文件记录。

 

Logging 使用

新建一个 ASP.NET Core 项目，为]]></description><category></category></item><item><title><![CDATA[SQL2005关于quotename的用法（转）]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/51991277</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/51991277</guid><author>merry3688</author><pubDate>Fri, 22 Jul 2016 08:33:06 +0800</pubDate><description><![CDATA[首先，sqlserver里的标识符有一定的规则，比如  你 
create table abc 123(...) 
那么中间含有空格，它不是符合规则的。 

你会写做 create table [abc 123](....) 
即以[]来定界标识符。

quotename将 字串成为有效的标识符。 

它有什么用呢？ 我举个例子：


你有个表名字叫做 aa[]bb 
]]></description><category></category></item><item><title><![CDATA[User Secrets – Storing sensitive data in ASP.NET Core projects]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/51983639</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/51983639</guid><author>merry3688</author><pubDate>Thu, 21 Jul 2016 15:53:55 +0800</pubDate><description><![CDATA[What do we mean by User Secrets?

This was the question which strike’d my mind when I first read about it. Is it really worth coming with something like. Yes, it’s really worth. Believe me at end of]]></description><category></category></item><item><title><![CDATA[动态SQL字符长度超过8000]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/51983614</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/51983614</guid><author>merry3688</author><pubDate>Thu, 21 Jul 2016 15:52:27 +0800</pubDate><description><![CDATA[动态SQL字符长度超过8000，我记得SQL SERVER 2005中用SP_EXECUTESQL打破了这个限制。

 

平常用动态SQL，可能都会用EXEC(),但是有限制，就是8000字符串长度。自从SQL SERVER 2005起，在 INSIDE SQLSERVER 2005 T-SQL PROGRAMMING中提到，使用SP_EXECUTESQL()和NVARCHAR(MAX)]]></description><category></category></item><item><title><![CDATA[.Net 高效开发之不可错过的实用工具]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/51917729</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/51917729</guid><author>merry3688</author><pubDate>Fri, 15 Jul 2016 14:48:57 +0800</pubDate><description><![CDATA[转自葡萄城控件技术团队博客
工欲善其事，必先利其器，没有好的工具，怎么能高效的开发出高质量的代码呢？本文为各ASP.NET 开发者介绍一些高效实用的工具，涉及SQL 管理，VS插件，内存管理，诊断工具等，涉及开发过程的各个环节，让开发效率翻倍。


 


Visual Studio


Visual Studio Productivity Power tool: VS 专业版]]></description><category></category></item><item><title><![CDATA[tar32.dll解压，压缩]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/39006453</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/39006453</guid><author>merry3688</author><pubDate>Tue, 02 Sep 2014 15:02:02 +0800</pubDate><description><![CDATA[1

  _
        Private Shared Function Tar(ByVal hwnd As IntPtr, _
                                    ByVal szCmdLine As String, _
                                    ByVal szOutput As String, _]]></description><category></category></item><item><title><![CDATA[C#获取桌面某个窗体截图进行OCR识别]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/38728563</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/38728563</guid><author>merry3688</author><pubDate>Thu, 21 Aug 2014 13:29:43 +0800</pubDate><description><![CDATA[1.首先电脑需要安装完整版的Microsoft Office并选择安装Microsoft Office 工具（默认是不安装的）。

 

2.添加项目对MODI的引用：右键单击项目下的引用--添加引用--选择COM下的--Microsoft Office Document Imaging 12.0 Object Library--确定。

 

3.添加 using System.]]></description><category></category></item><item><title><![CDATA[ICSharpCode.SharpZipLib生成tar、tar.gz]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/37761415</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/37761415</guid><author>merry3688</author><pubDate>Mon, 14 Jul 2014 14:27:25 +0800</pubDate><description><![CDATA[源码地址：http://www.icsharpcode.net/OpenSource/SharpZipLib/Default.aspx

 

调用方法：



[csharp] view
 plaincopy






///   
/// 生成 ***.tar.gz 文件  
///   
/// 文件基目录（源文件、生成文件所在目录）  
/// 待]]></description><category></category></item><item><title><![CDATA[log4net配置]]></title><link>https://blog.youkuaiyun.com/merry3688/article/details/37598691</link><guid>https://blog.youkuaiyun.com/merry3688/article/details/37598691</guid><author>merry3688</author><pubDate>Wed, 09 Jul 2014 14:56:24 +0800</pubDate><description><![CDATA[1、概述

log4net是.Net下一个非常优秀的开源日志记录组件。log4net记录日志的功能非常强大。它可以将日志分不同的等级，以不同的格式，输出到不同的媒介。本文主要是介绍如何在Visual
 Studio2008中使用log4net快速创建系统日志，如何扩展以输出自定义字段。

2、一个简单的使用实例

第一步：在项目中添加对log4net.dll的引用，这里引用版本是1.]]></description><category></category></item></channel></rss>