<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[z542601362的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/z542601362</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; z542601362]]></copyright><item><title><![CDATA[用变量获得实体类中一个不确定名称的值]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/48311931</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/48311931</guid><author>z542601362</author><pubDate>Wed, 09 Sep 2015 10:15:26 +0800</pubDate><description><![CDATA[UserInfo _UserInfo = new UserInfo();
var property = _UserInfo.GetType().GetProperty(变量名称);
var oldvalue = property.GetValue(_UserInfo, null);
int zhi = Convert.ToInt32(oldvalue.ToString());]]></description><category></category></item><item><title><![CDATA[Server SQL 发布复制事物时的错误提示：读取代理器未运行 进程无法在“WIN-XXX”上执行“sp_replcmds”]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/46918343</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/46918343</guid><author>z542601362</author><pubDate>Thu, 16 Jul 2015 22:34:56 +0800</pubDate><description><![CDATA[来源：http://blog.sina.com.cn/s/blog_4b05f08e01011rue.html




服务器的环境是Server2008+SQL2008,做本机的发布，再推送到本机，可是总提示，“日志读取代理器未运行”

错误提示：

进程无法在“WIN-XXX”上执行“sp_replcmds”。 (源: MSSQL_REPL，错误号: MSSQL_REPL20]]></description><category></category></item><item><title><![CDATA[阻止“IIS短文件名泄露”]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/46822495</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/46822495</guid><author>z542601362</author><pubDate>Thu, 09 Jul 2015 22:15:45 +0800</pubDate><description><![CDATA[1.    简介：Microsoft IIS在实现上存在文件枚举漏洞，攻击者可利用此漏洞枚举网络服务器根目录中的文件。
2.    检测方法：http://www.xxxx.com/defaul*~1*/.aspx，将log换成你的文件名的前几位，如返回404则代表文件存在，如返回bad
 request则代表文件不存在，如有以上现象，则存在此漏洞。
3.    修复方法：修改注册列表HKL]]></description><category></category></item><item><title><![CDATA[服务器同时安装了两个版本的sql，如果分别连接不同版本的sql上的数据库]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/45642023</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/45642023</guid><author>z542601362</author><pubDate>Mon, 11 May 2015 11:25:04 +0800</pubDate><description><![CDATA[最先安装的sql端口是1433，连接这个不用输入端口，直接用ip去连接就可以。
第二个安装的sql，比方说是2014版本：
1.设置SQL SERVER2014实例的服务端口为静态端口：56566(找一个没有占用的)
SQL SERVER配置管理器-》SQL Server 网络配置-》你的2014实例 的协议-》TCP/IP-》IP地址-》IPAll-》TCP端口: 56566(注意：TCP]]></description><category></category></item><item><title><![CDATA[删除数据库中的重复数据记录、查找重复记录、查找不重复记录]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/45199121</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/45199121</guid><author>z542601362</author><pubDate>Wed, 22 Apr 2015 19:05:09 +0800</pubDate><description><![CDATA[﻿﻿
删除重复记录（保留最后一个重复的数据）：
delete   表 where 主键id  not   in   ( select   max([主键id])   from   表 group   by   (重复的字段一   +   重复的字段二))

删除重复记录（保留第一个重复的数据）：
delete   表 where 主键id  not   in   ( select   m]]></description><category></category></item><item><title><![CDATA[C#向MySql插入数据的时候中文变为乱码]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/45199103</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/45199103</guid><author>z542601362</author><pubDate>Wed, 22 Apr 2015 19:03:49 +0800</pubDate><description><![CDATA[基本上是编码问题，找了很久后来发现直接在数据库的连接字符串上写：charset=utf8; 就可以解决了。
如：
 charset=utf8;******;User Id=******;password=******;Database=******;]]></description><category></category></item><item><title><![CDATA[sql中把varchar类型转换为int型然后进行排序]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/45199079</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/45199079</guid><author>z542601362</author><pubDate>Wed, 22 Apr 2015 19:03:10 +0800</pubDate><description><![CDATA[﻿﻿
一、
[sql]
select * from yourtable order by cast(yourcol as int);  
适用于SQLServer  Oracle
二、
[sql]
select * from yourtable order by convert(int,yourcol);  
仅适用于SQLServer
数据库中的两个文本类型的信息相加：
up]]></description><category></category></item><item><title><![CDATA[sql update数据，条件是另一个表中的数据]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/45199059</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/45199059</guid><author>z542601362</author><pubDate>Wed, 22 Apr 2015 19:01:13 +0800</pubDate><description><![CDATA[﻿﻿
update NF_User_PeiXunBan set U_ZiDuanZhi026 = '258.00'  from NF_User_Record where U_PeiXunBanSN=417

and R_Idnumber='420982199707107227' and R_SN=U_UserSN;]]></description><category></category></item><item><title><![CDATA[我常用到的一些js]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/45158887</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/45158887</guid><author>z542601362</author><pubDate>Tue, 21 Apr 2015 00:22:10 +0800</pubDate><description><![CDATA[1、定义js随机字符：
var times1 = parseInt(Math.random()*99999999+1); 
Math.random(); //这个方法获得一个0.13246578 的的小数。


2、js修改div的css样式：
document.getElementById("dahang1").className="style1";


3、js修改div的背]]></description><category></category></item><item><title><![CDATA[点击图片，调用上传控件]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/45158805</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/45158805</guid><author>z542601362</author><pubDate>Tue, 21 Apr 2015 00:21:48 +0800</pubDate><description><![CDATA[附件1
        
    
         
             $(document).ready(function () {
                 $("#Texx_ZhengJuFuJian1").change(function () {//更改参加考试的事件
                     $("#fujian_1").html(docum]]></description><category></category></item><item><title><![CDATA[DropDownList 添加新内容]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/45158691</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/45158691</guid><author>z542601362</author><pubDate>Tue, 21 Apr 2015 00:19:20 +0800</pubDate><description><![CDATA[this.DropDownList1.Items.Insert(0, new ListItem( "--选择--",""));//指定位置添加
this.DropDownList1.Items.Add(new ListItem("--选择--", ""));//列的最后添加]]></description><category></category></item><item><title><![CDATA[WdatePicker日历控件使用方法]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/45158735</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/45158735</guid><author>z542601362</author><pubDate>Tue, 21 Apr 2015 00:18:57 +0800</pubDate><description><![CDATA[1. 跨无限级框架显示

 
无论你把日期控件放在哪里,你都不需要担心会被外层的iframe所遮挡进而影响客户体验,因为My97日期控件是可以跨无限级框架显示的
 
示例2-7 跨无限级框架演示
可无限跨越框架iframe,无论怎么嵌套框架都不必担心了,即使有滚动条也不怕
 
2. 民国年日历和其他特殊日历

 
当年份格式设置为yyy格式时,利用年份差量属性yearOffs]]></description><category></category></item><item><title><![CDATA[sql update数据，条件是另一个表中的数据]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/45158571</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/45158571</guid><author>z542601362</author><pubDate>Tue, 21 Apr 2015 00:17:22 +0800</pubDate><description><![CDATA[update User_PeiXunBan set U_ZiDuanZhi026 = '258.00'  from NF_User_Record where U_PeiXunBanSN=417

and R_Idnumber='420982199707107227' and R_SN=U_UserSN;]]></description><category></category></item><item><title><![CDATA[.net 引用Microsoft.Office.Interop.Word.dll对word文件进行操作]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/45158215</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/45158215</guid><author>z542601362</author><pubDate>Tue, 21 Apr 2015 00:14:25 +0800</pubDate><description><![CDATA[.net 4.0以上版本添加引用，如果不是4.0以上版本可能没有这个，自己去下载一个Microsoft.Office.Interop.Word.dll应该也可以。


  







引用完成之后，如果直接用vs进行跑是没有问题的，但是放在iis上面会提示：
检索 COM 类工厂中 CLSID 为 {000209FF-0000-0000-C000-00000000004]]></description><category></category></item><item><title><![CDATA[asp.net 输出txt文件的时候中文出现乱码，已解决]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/7938649</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/7938649</guid><author>z542601362</author><pubDate>Mon, 03 Sep 2012 16:34:07 +0800</pubDate><description><![CDATA[using System.Text;
using System.IO;

Response.ContentEncoding = Encoding.GetEncoding("gb2312");
String aa = Server.MapPath("/11.txt");
Response.Write("");
Response.WriteFile(Server.MapPath("/11.]]></description><category></category></item><item><title><![CDATA[asp.net 获得今天是星期几]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/7938637</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/7938637</guid><author>z542601362</author><pubDate>Mon, 03 Sep 2012 16:32:59 +0800</pubDate><description><![CDATA[string wd = Convert.ToDateTime(DateTime.Now).DayOfWeek.ToString().Replace("Monday", "星期一").Replace("Tuesday", "星期二").Replace("Wednesday", "星期三").Replace("Thursday", "星期四").Replace("Friday", "星期五").Rep]]></description><category></category></item><item><title><![CDATA[asp.net去掉<!-- -->注释字符]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/7938632</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/7938632</guid><author>z542601362</author><pubDate>Mon, 03 Sep 2012 16:32:34 +0800</pubDate><description><![CDATA[using System.Text.RegularExpressions;

string adf = "哈哈哈哈11哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈";
adf = Regex.Replace(adf, @"]*>", "", RegexOptions.IgnoreC]]></description><category></category></item><item><title><![CDATA[设置cookies过期时间的几种方法（cookies随浏览器关闭而失效的方法）]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/7938628</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/7938628</guid><author>z542601362</author><pubDate>Mon, 03 Sep 2012 16:31:48 +0800</pubDate><description><![CDATA[cookies随浏览器关闭而失效的方法:
如果不设置Expires的属性那么Cookie的存活时间就是在关闭浏览器的时候。

默认cookies失效时间是直到关闭浏览器，cookies失效，也可以指定cookies时间。
Response.Cookies("user_name").Expires=Date+1 '指定cookie保存时间
保留COOKIES一个小时
Response.C]]></description><category></category></item><item><title><![CDATA[删除文件夹、创建文件夹、删除文件 等操作]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/7938625</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/7938625</guid><author>z542601362</author><pubDate>Mon, 03 Sep 2012 16:31:04 +0800</pubDate><description><![CDATA[using System.IO;

System.IO.DirectoryInfo dirinfo = System.IO.Directory.CreateDirectory(Server.MapPath("/go/1111"));　　//创建文件夹
Directory.Delete(Server.MapPath("/go/1111"), true);　　 //删除1111文件夹 
Sys]]></description><category></category></item><item><title><![CDATA[TextMode="Password" 添加默认字符]]></title><link>https://blog.youkuaiyun.com/z542601362/article/details/7938620</link><guid>https://blog.youkuaiyun.com/z542601362/article/details/7938620</guid><author>z542601362</author><pubDate>Mon, 03 Sep 2012 16:30:36 +0800</pubDate><description><![CDATA[添加默认字符
User_Password.Attributes.Add("Value", "......");]]></description><category></category></item></channel></rss>