<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[chinaly的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/chinaly</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; chinaly]]></copyright><item><title><![CDATA[水晶报表显示条码设置]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/5219741</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/5219741</guid><author>chinaly</author><pubDate>Thu, 21 Jan 2010 11:09:00 +0800</pubDate><description><![CDATA[  1.定义一个公式字段,调用水晶报表的函数:MoroviaBarcodeCode128AutoAsian ({repWinzenCutPackComp.ColorCode}) 2.设置公式字段显示的格式:选中字段,设置对段对象格式->font->font选择字体的显示式:MRV Code128M  ]]></description><category></category></item><item><title><![CDATA["Failed to access IIS metabase"解决方法]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/5110544</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/5110544</guid><author>chinaly</author><pubDate>Thu, 31 Dec 2009 09:32:00 +0800</pubDate><description><![CDATA[原因：IIS没有注册,我是原有系统的IIS删了,造成运行IIS中的应用程序出现这种错误! 解决办法: 在CMD中进入目录C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727，运行aspnet_regiis1、aspnet_regiis -ga administrator（administrator为当前用户）2、aspnet_regii]]></description><category></category></item><item><title><![CDATA[An error has occurred while establishing a connection to the server处理方法]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/5009704</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/5009704</guid><author>chinaly</author><pubDate>Tue, 15 Dec 2009 11:03:00 +0800</pubDate><description><![CDATA[ 本机开发的应用程式(asp.net(C#)+sqlserver2005),运行没错! 当我把应用程序挂在服务器时,出现数据库连接错误:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be]]></description><category></category></item><item><title><![CDATA[sql动态读取Excel多个分页]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/4962786</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/4962786</guid><author>chinaly</author><pubDate>Tue, 08 Dec 2009 11:40:00 +0800</pubDate><description><![CDATA[ sql Code --先创建一个方法,动态读取一个文件夹下面所有的Excle文件 --sql functionset ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER function [dbo].[udf_getExcelTableNames] (@filename varchar (1000 ))returns @t t]]></description><category></category></item><item><title><![CDATA[未来五年程序员应当具备的十项技能]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/4907307</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/4907307</guid><author>chinaly</author><pubDate>Mon, 30 Nov 2009 17:43:00 +0800</pubDate><description><![CDATA[作为一名程序员，如果你想在这个领域内继续向前进步或者在当前的经济形势下保持不被炒鱿鱼，那么你就决不应当自满自足，你需要继续学习。近日，著名IT评论员Justin James在他的博客中列出了未来五年程序员应当具备的十项技能，如果照此实践，你未来的工作前景一定一片光明。当前的经济形势下，很多程序员将目光聚焦在短期内的工作形式上，但是你仍然要抽出时间和精力学习新的技能。以下是作为程序员应当即刻学习]]></description><category></category></item><item><title><![CDATA[asp.net程序Excel转成XML档]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/4888309</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/4888309</guid><author>chinaly</author><pubDate>Fri, 27 Nov 2009 14:11:00 +0800</pubDate><description><![CDATA[ 通过Asp.net(C#)应用程序读取本地上传的Excle文件,存放到DataSet中,通过DataSet中的方法直接生成XML文件. C# Code  if (this.FileUpload1.PostedFile != null)        {            string filename = this.FileUpload1.FileName.ToStrin]]></description><category></category></item><item><title><![CDATA[关于存储过程优化]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/4864882</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/4864882</guid><author>chinaly</author><pubDate>Tue, 24 Nov 2009 16:28:00 +0800</pubDate><description><![CDATA[存储过程编写经验和优化措施 阅读提示：本文介绍MS SQL的存储过程编写经验和优化措施 一、适合读者对象：数据库开发程序员，数据库的数据量很多，涉及到对SP（存储过程）的优化的项目开发人员，对数据库有浓厚兴趣的人。　 二、介绍：在数据库的开发过程中，经常会遇到复杂的业务逻辑和对数据库的操作，这个时候就会用SP来封装数据库操作。如果项目的SP较多，书写又没有一定的规范，将会影响以后的系统维护困难和大]]></description><category></category></item><item><title><![CDATA[Control 'GridView1' of type 'GridView' must be placed inside a form tag with runat=server]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/4814735</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/4814735</guid><author>chinaly</author><pubDate>Mon, 16 Nov 2009 09:56:00 +0800</pubDate><description><![CDATA[ Control GridView1 of type GridView must be placed inside a form tag with runat=server asp.net(C#) To Excel时出现这种错误!! C# Code     ///     /// To Excel    ///     /// 例如控件 GridView  ]]></description><category></category></item><item><title><![CDATA[sql code]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/4782630</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/4782630</guid><author>chinaly</author><pubDate>Sat, 07 Nov 2009 14:47:00 +0800</pubDate><description><![CDATA[这sql 语句写的真的很不错!  if object_id([tb]) is not null drop table [tb]go create table [tb]([col1] bigint,[col2] varchar(6),[col3] varchar(6))insert [tb]select 130126200201000275,王文霞,靳川川 union allse]]></description><category></category></item><item><title><![CDATA[sql数据表行转列]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/4744238</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/4744238</guid><author>chinaly</author><pubDate>Thu, 29 Oct 2009 17:34:00 +0800</pubDate><description><![CDATA[二個數據表,一個員工資料表(Users),另外一個員工學歷表(UserInfo);執行sql語結果為:    sql Code selecta.userno,(select username from users where userno=a.userno)as username,(select address from users where userno=a.u]]></description><category></category></item><item><title><![CDATA[sql查询结果集导出Excel]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/4744062</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/4744062</guid><author>chinaly</author><pubDate>Thu, 29 Oct 2009 17:05:00 +0800</pubDate><description><![CDATA[ T-SQL代码：EXEC master..xp_cmdshell bcp 库名.dbo.表名out c:/Temp.xls -c -q -S"servername" -U"sa" -P""参数：S 是SQL服务器名；U是用户；P是密码说明：还可以导出文本文件等多种格式declare @str varchar(600)select  @str= bcp   "select conve]]></description><category></category></item><item><title><![CDATA[oracle数据库导入到sql server2005]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/4722142</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/4722142</guid><author>chinaly</author><pubDate>Sat, 24 Oct 2009 10:11:00 +0800</pubDate><description><![CDATA[引用:http://blog.youkuaiyun.com/wizardlun/archive/2009/09/08/4531576.aspx 今天，终于把oracle中的数据库导入到sql server中了，方法如下：   一、在sql server中建个同名数据库，例如ssdb。   二、右键点击ssdb,选择“所有任务”——>“导入数据”，就会弹出一个“DTS导入/导出向导”，  点击下]]></description><category></category></item><item><title><![CDATA[Ajax调用asp.net后台方法功能实现]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/4313438</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/4313438</guid><author>chinaly</author><pubDate>Wed, 01 Jul 2009 15:45:00 +0800</pubDate><description><![CDATA[HTML http://www.w3.org/1999/xhtml">    EIP資訊系統-會議室申請單管理            function btn_delete()        {               if(confirm(确定要刪除嗎?)==true)            {                var select=document.getEl]]></description><category></category></item><item><title><![CDATA[Javascript实现页面自动重复加載一次]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/4313409</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/4313409</guid><author>chinaly</author><pubDate>Wed, 01 Jul 2009 15:41:00 +0800</pubDate><description><![CDATA[　　 //頁面五秒種自動刷新,數據重复加載一次　      function loadpop()　      {　          //功能:五秒種自動獲取 txt_value文本框的值　          var obj=document.getElementById("txt_value").value;　          alert(obj)　                      ]]></description><category></category></item><item><title><![CDATA[asp.net 文件上傳受限大小問題]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/4040602</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/4040602</guid><author>chinaly</author><pubDate>Wed, 01 Apr 2009 11:32:00 +0800</pubDate><description><![CDATA[ asp.net 文件上傳受限大小問題  只需要在web.config配制文件中加入此段代嗎:  ]]></description><category></category></item><item><title><![CDATA[Oracle 创建临时表]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/3602320</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/3602320</guid><author>chinaly</author><pubDate>Thu, 25 Dec 2008 12:07:00 +0800</pubDate><description><![CDATA[CREATE GLOBAL TEMPORARY table DAT_TEST_BOM4(2,4)                     (                         TREE_ID NUMBER,                         PART_ID NUMBER,                         PART_NO VARCHAR2(20),    ]]></description><category></category></item><item><title><![CDATA[oracle 存储过程的基本语法 及注意事项 ]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/3548130</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/3548130</guid><author>chinaly</author><pubDate>Thu, 18 Dec 2008 12:00:00 +0800</pubDate><description><![CDATA[oracle 存储过程的基本语法 及注意事项 oracle 存储过程的基本语法1.基本结构 CREATE OR REPLACE PROCEDURE 存储过程名字(    参数1 IN NUMBER,    参数2 IN NUMBER) IS变量1 INTEGER :=0;变量2 DATE;BEGINEND 存储过程名字2.SELECT INTO STATEMENT  将select查询]]></description><category></category></item><item><title><![CDATA[Oracle 查询两个日期间的记录]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/3529273</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/3529273</guid><author>chinaly</author><pubDate>Tue, 16 Dec 2008 11:33:00 +0800</pubDate><description><![CDATA[ SQL Code: SELECT * FROM DAT_BOM WHERE TO_CHAR(REVISE_DATE,YYYY/MM/DD)>=2008/12/10 AND TO_CHAR(REVISE_DATE,YYYY/MM/DD)  ]]></description><category></category></item><item><title><![CDATA[ORACLE带字符的自增值存储过程的实现]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/3476481</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/3476481</guid><author>chinaly</author><pubDate>Mon, 08 Dec 2008 14:37:00 +0800</pubDate><description><![CDATA[ /*   @author:BRUNOWU   @date:20080416   @desc:输入一个编号,找到下一个自动编号的值,如输入99,下一个编号就为:1A, */ PROCEDURE P_GEN_CUSNO (     V_CUSNOCODE_IN   VARCHAR2,--输入自编号     O_CUSNOCODE  OUT VARCHAR2--下一个自动编号 ) A]]></description><category></category></item><item><title><![CDATA[ORACLE 存储过程:传表名,栏位名,获取表该栏位的最大值]]></title><link>https://blog.youkuaiyun.com/chinaly/article/details/3476471</link><guid>https://blog.youkuaiyun.com/chinaly/article/details/3476471</guid><author>chinaly</author><pubDate>Mon, 08 Dec 2008 14:34:00 +0800</pubDate><description><![CDATA[/*   @author:ly   @date:20081208   @desc:传表名,栏位名,获取表该栏位的最大值    */  PROCEDURE P_GETMAXID (   V_TABLE VARCHAR2,   V_FILEID VARCHAR2,   O_MAX OUT NUMBER ) AS  V_SQL VARCHAR2(500); BEGIN      V_SQL:=SEL]]></description><category></category></item></channel></rss>