<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[wlhx]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/haixia521</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; haixia521]]></copyright><item><title><![CDATA[16进制随机颜色生成]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84701959</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84701959</guid><author>haixia521</author><pubDate>Fri, 13 Feb 2015 09:25:59 +0800</pubDate><description><![CDATA[[color=blue]前段时间做图表，用到了随机颜色值，虽然写了一种方法，但是不理想重复机率很大，今天在
网上看一网友博客看到的下面的方法：[/color][code=&quot;js&quot;]~~(Math.random()*(1...]]></description><category></category></item><item><title><![CDATA[将某个字段修改为随机数]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84676253</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84676253</guid><author>haixia521</author><pubDate>Sat, 18 Oct 2014 11:45:09 +0800</pubDate><description><![CDATA[将某一字段修改为随机数1-N 包括N代码如下：
[code=&quot;sql&quot;]UPDATE 表名
SET 字段名=(CAST(CEILING(RAND(CHECKSUM(NEWID()))*N) AS INT))
WHERE 条件[/code]]]></description><category></category></item><item><title><![CDATA[WEB 在线编辑器]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84546608</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84546608</guid><author>haixia521</author><pubDate>Tue, 08 Apr 2014 20:32:32 +0800</pubDate><description><![CDATA[[size=large]网上免费的在线编辑器[/size]
[url]http://ueditor.baidu.com/website/umeditor.html?qq-pf-to=pcqq.group[/url]
[url]http://kindeditor.net/demo.php[/url]]]></description><category></category></item><item><title><![CDATA[重置数据库自增列标识为0]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84521176</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84521176</guid><author>haixia521</author><pubDate>Sat, 18 Jan 2014 17:11:29 +0800</pubDate><description><![CDATA[[size=large]重置当前自增标识为0[/size][code=&quot;sql&quot;]
DBCC CHECKIDENT (#A, RESEED, 0) 
[/code] 
]]></description><category></category></item><item><title><![CDATA[Jquery局部打印]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84514875</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84514875</guid><author>haixia521</author><pubDate>Tue, 24 Dec 2013 21:01:29 +0800</pubDate><description><![CDATA[[size=x-small]最近用到了打印,网上搜了一下发现了jquery.PrintArea挺好代码如下：[/size][code=&quot;html&quot;]




Jquery局部打印



function Print(){ 
	$(&quot;#printArea&quot;).printArea(); }






	 这里是打印区域。。。




[/code]
jq...]]></description><category></category></item><item><title><![CDATA[C# OLEDB 读取Excel2003、Excel2007的内容到Table]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84496440</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84496440</guid><author>haixia521</author><pubDate>Wed, 06 Nov 2013 15:10:05 +0800</pubDate><description><![CDATA[[size=large]OLEDB 读取Excel2003、Excel2007内容为Table[/size][code=&quot;C#&quot;]
private DataTable GetData(string Path, string exceltype)
{
   try
   {
     string strConn = &quot;Provider=Microsoft.Jet.OLEDB.4.0;&quot; ...]]></description><category></category></item><item><title><![CDATA[SQL 实用技巧]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84492175</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84492175</guid><author>haixia521</author><pubDate>Thu, 24 Oct 2013 12:47:55 +0800</pubDate><description><![CDATA[[size=x-large]SQL实用技巧积累如下：[/size][code=&quot;SQL&quot;]
--1.查询某个数据库中总共有几张表
SELECT COUNT(id) AS COUNT FROM sysobjects s WHERE s.xtype='u'

--2.查询每张表对应的列的个数
SELECT S.NAME AS TableName,COUNT(C.ID) ColCount FR...]]></description><category></category></item><item><title><![CDATA[TabPanel 加载页面]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84484903</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84484903</guid><author>haixia521</author><pubDate>Mon, 30 Sep 2013 12:45:23 +0800</pubDate><description><![CDATA[最近项目改版，考虑用TabPanel加载页面，(就是点击每一个链接会自动添加一个Tab同时加载要请求的页面在里面)
网上搜了一下,看到jquery 的TablPanel挺好的 所以就用了。
现在记下来 提供给所需的程序猿们。...]]></description><category></category></item><item><title><![CDATA[MIME 导出多sheet的Excel]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84475970</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84475970</guid><author>haixia521</author><pubDate>Wed, 04 Sep 2013 08:27:15 +0800</pubDate><description><![CDATA[最近搞导出Excel 网上搜到了一篇好文章 解决了燃眉之急!
文章出处：http://www.cnblogs.com/birdshome/archive/2005/07/14/mime_excel_sheets.html
关于单元格格式：
http://www.blogjava.net/pzxsheng/archive/2012/08/30/386608.html...]]></description><category></category></item><item><title><![CDATA[获取鼠标实时坐标]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84469653</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84469653</guid><author>haixia521</author><pubDate>Thu, 15 Aug 2013 20:35:10 +0800</pubDate><description><![CDATA[[code=&quot;html&quot;]



无标题文档
 
#top_div{ 
    position:absolute; 
	width:100PX;
	height:50px;
	border:1px solid #00F;
	text-align:center;
	color:blue;
} 
 


function initMouseMove(){
docu...]]></description><category></category></item><item><title><![CDATA[JS取某年某月的最后一天]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84445019</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84445019</guid><author>haixia521</author><pubDate>Thu, 20 Jun 2013 13:21:14 +0800</pubDate><description><![CDATA[[size=x-large]js取某年某月的最后一天[/size]
[code=&quot;js&quot;]function GetLastDay(year,month,1)
{
  var date = new Date(year,month,1);
  var lastday=new Date(date.getTime()-1000*60*60*24).getDate();
  return  las...]]></description><category></category></item><item><title><![CDATA[SQL收缩数据库代码]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84441272</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84441272</guid><author>haixia521</author><pubDate>Sun, 09 Jun 2013 16:28:52 +0800</pubDate><description><![CDATA[[size=x-large]将下列代码在数据中执行即可收缩数据库[/size][code=&quot;sql&quot;]BACKUP LOG 库名 WITH NO_LOG; 
BACKUP LOG 库名 WITH TRUNCATE_ONLY;
DBCC SHRINKDATABASE(库名); [/code]]]></description><category></category></item><item><title><![CDATA[OWC11导出Excel的应用]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84421443</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84421443</guid><author>haixia521</author><pubDate>Sun, 21 Apr 2013 10:43:21 +0800</pubDate><description><![CDATA[[size=large][b]最近在做项目中的导出Excel功能,要求不依赖office组件所以研究了一下OWC11下面是具体代码:[/b][/size]
[code=&quot;c#&quot;]
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
//引入OWC11命名空间
usi...]]></description><category></category></item><item><title><![CDATA[JS给网页上所有的select加title]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84352553</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84352553</guid><author>haixia521</author><pubDate>Mon, 05 Nov 2012 14:26:53 +0800</pubDate><description><![CDATA[[size=large]最近开发的网站由于搜索条件多,所以每项宽度窄而导致有些浏览器看不全下拉框的文字,所以写了个脚本将所有的select加上title这样鼠标放上去就看全了 方法如下：[/size][code=&quot;javascript&quot;]
function BatchSetTitle() {
    var selects = $(&quot;select&quot;)
    var selectcount ...]]></description><category></category></item><item><title><![CDATA[修改数据库为多用户模式]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84351999</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84351999</guid><author>haixia521</author><pubDate>Sat, 03 Nov 2012 15:37:16 +0800</pubDate><description><![CDATA[SQL语句修改数据位多用户模式如下：
[code=&quot;sql&quot;]
DECLARE @SQL VARCHAR(MAX);
SET @SQL=''

SELECT @SQL=@SQL+'; KILL '+RTRIM(SPID)
FROM master..sysprocesses
WHERE dbid=DB_ID('数据库名称'); 

EXEC(@SQL);
GO
ALTER DA...]]></description><category></category></item><item><title><![CDATA[Window2008+IIS7部署网站的日期格式问题]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84342175</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84342175</guid><author>haixia521</author><pubDate>Wed, 31 Oct 2012 08:06:01 +0800</pubDate><description><![CDATA[最近系统升级了，把之前做的网站部署上去发现日期格式变成了yyyy/MM/dd的格式，后来经过查找资料得到以下解决方法，顺便写下来以备后用。
第一种方法
运行注册表编辑器（regedit）
进入到HKEY_USERS/.DEFAULT/Control Panel/International
修改右侧sDate值为 -
修改右侧sShortDate值为 yyyy-MM-dd
重启电脑OK...]]></description><category></category></item><item><title><![CDATA[该伙伴事务管理器已经禁止了它对远程/网络事务的支持]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84341776</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84341776</guid><author>haixia521</author><pubDate>Tue, 30 Oct 2012 13:10:27 +0800</pubDate><description><![CDATA[[color=red][size=x-large]针对“该伙伴事务管理器已经禁止了它对远程/网络事务的支持”问题解决方法如下：[/size]
[/color]
[color=red][size=large]1.双方启动MSDTC服务[/size][/color]
MSDTC(分布式交易协调器)，协调跨多个数据库、消息队列、文件系统等资源管理器的事务。该服务的进程名为Msdtc.exe,该进程...]]></description><category></category></item><item><title><![CDATA[查询数据库中所有的外键关系]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84281589</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84281589</guid><author>haixia521</author><pubDate>Sat, 01 Sep 2012 09:41:10 +0800</pubDate><description><![CDATA[用于查询数据库中所有外键关系的SQL语句如下：
[code=&quot;sql&quot;]
select fk.name fkname , ftable.name ptablename, cn.name fkcol, rtable.name ftablename from sysforeignkeys
join sysobjects fk
on sysforeignkeys.constid = fk.id...]]></description><category></category></item><item><title><![CDATA[WinInet错误代码大全]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84231524</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84231524</guid><author>haixia521</author><pubDate>Sat, 09 Jun 2012 16:44:23 +0800</pubDate><description><![CDATA[[list]
  Code        Error Message and Description
   -----       -----------------------------
   12001       ERROR_INTERNET_OUT_OF_HANDLES
               No more handles could be generated at th...]]></description><category></category></item><item><title><![CDATA[兼容IE FF Opera的 JS复制方法]]></title><link>https://blog.youkuaiyun.com/haixia521/article/details/84225305</link><guid>https://blog.youkuaiyun.com/haixia521/article/details/84225305</guid><author>haixia521</author><pubDate>Tue, 29 May 2012 15:42:13 +0800</pubDate><description><![CDATA[[code=&quot;js&quot;]
function copyToClipboard(txt) { 
 
     if(window.clipboardData) {  
             window.clipboardData.clearData();  
             window.clipboardData.setData(&quot;Text&quot;, txt);  
     }...]]></description><category></category></item></channel></rss>