Mon, 15 Jun 2009 09:38:00 GMThttp://blog.csdn.net/chenguang79/http://blog.csdn.net/chenguang79/archive/2009/06/15/4269465.aspxhttp://blog.csdn.net/chenguang79/comments/4269465.aspx0http://blog.csdn.net/chenguang79/comments/commentRss/4269465.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4269465<br />USE [Book]<br /> GO<br /> /****** 对象:  Table [dbo].[tt]    脚本日期: 06/15/2009 09:31:44 ******/<br /> SET ANSI_NULLS ON<br /> GO<br /> SET QUOTED_IDENTIFIER ON<br /> GO<br /> SET ANSI_PADDING ON<br /> GO<br /> CREATE TABLE [dbo].[tt](<br />     [id] [int] IDENTITY(1,1) NOT NULL,<br />     [title] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,<br />     [prive] [int] NULL,<br />     [DTime] [smalldatetime] NULL,<br />     [Classes] [int] NULL,<br />  CONSTRAINT [PK_tt] PRIMARY KE<img src ="http://blog.csdn.net/chenguang79/aggbug/4269465.aspx" width = "1" height = "1" /><img src="http://www1.feedsky.com/t1/232971064/chenguang79/csdn.net/s.gif?r=http://blog.csdn.net/chenguang79/archive/2009/06/15/4269465.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/chenguang79/232971064/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/chenguang79/232971064/art01.gif" onerror="this.style.display='none'" /></a></p>Mon, 15 Jun 2009 17:38:00 +0800chenguang79http://blog.csdn.net/chenguang79/archive/2009/06/15/4269465.aspx#Feedbackhttp://blog.csdn.net/chenguang79/archive/2009/06/15/4269465.aspxchenguang79http://blog.csdn.net/chenguang79/archive/2009/06/15/4269465.aspxhttp://blog.csdn.net/chenguang79/feed.aspxcsdn.net/chenguang79/~1125310/232971064/1125304http://blog.csdn.net/chenguang79/archive/2009/06/04/4241191.aspxhttp://blog.csdn.net/chenguang79/comments/4241191.aspx0http://blog.csdn.net/chenguang79/comments/commentRss/4241191.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4241191<br /><br /><br /><br /><br />日期联动选择器<br /><img src ="http://blog.csdn.net/chenguang79/aggbug/4241191.aspx" width = "1" height = "1" /><img src="http://www1.feedsky.com/t1/232971065/chenguang79/csdn.net/s.gif?r=http://blog.csdn.net/chenguang79/archive/2009/06/04/4241191.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/chenguang79/232971065/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/chenguang79/232971065/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 04 Jun 2009 18:09:00 +0800chenguang79http://blog.csdn.net/chenguang79/archive/2009/06/04/4241191.aspx#Feedbackhttp://blog.csdn.net/chenguang79/archive/2009/06/04/4241191.aspxchenguang79http://blog.csdn.net/chenguang79/archive/2009/06/04/4241191.aspxhttp://blog.csdn.net/chenguang79/feed.aspxcsdn.net/chenguang79/~1125310/232971065/1125304http://blog.csdn.net/chenguang79/archive/2009/05/31/4228271.aspxhttp://blog.csdn.net/chenguang79/comments/4228271.aspx0http://blog.csdn.net/chenguang79/comments/commentRss/4228271.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4228271平时用SQL语句不是很多。这几天在处理一个数据库时，就遇到这样一个问题。二个数据库要互导一些数据，这里遇到一个问题，有些表中的标识种子列，怎么办呢。如果你不管它，可是一些相关的字段却它有关链。是不行的。查了一下资料，用以下的方法可以很容易的解决这个问题比如我的表名叫，tables1,table2 从table2中将数据导入table1中里面的字段有id(标识种子),name,sex我们可以采用set identity_insert tables1 on    这句很关键，只要它为on时，才可以导insert into tables1(id,[name],sex)select id,[name],sex from table2这里要说明一点，这里不能用*处理，必须要写上每一个字段才行。<img src ="http://blog.csdn.net/chenguang79/aggbug/4228271.aspx" width = "1" height = "1" /><img src="http://www1.feedsky.com/t1/232971066/chenguang79/csdn.net/s.gif?r=http://blog.csdn.net/chenguang79/archive/2009/05/31/4228271.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/chenguang79/232971066/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/chenguang79/232971066/art01.gif" onerror="this.style.display='none'" /></a></p>Sun, 31 May 2009 22:21:00 +0800chenguang79http://blog.csdn.net/chenguang79/archive/2009/05/31/4228271.aspx#Feedbackhttp://blog.csdn.net/chenguang79/archive/2009/05/31/4228271.aspxchenguang79http://blog.csdn.net/chenguang79/archive/2009/05/31/4228271.aspxhttp://blog.csdn.net/chenguang79/feed.aspxcsdn.net/chenguang79/~1125310/232971066/1125304http://blog.csdn.net/chenguang79/archive/2009/04/28/4131486.aspxhttp://blog.csdn.net/chenguang79/comments/4131486.aspx0http://blog.csdn.net/chenguang79/comments/commentRss/4131486.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4131486<br />调用请用<% call ShowArticleContent() %><br /> 注意:rs("PaginationType")是分页种类,写入数据库.rs("Content")是内容,rs("ArticleID")是文章ID.<br />0 不分页<br /> 1 自动<br /> 2 手动(用[NextPage]分隔)<br /> ****************************************************<br /><%<br /> '=================================================<br /> '过程名：ShowArticleContent<br /> '作 用：显示文章具体的内容，可以分页显示<br /> '参 数：无<br /> '=================================================<br /> sub ShowArticleContent()<br /> dim PaginationType<br /> Pagi<img src ="http://blog.csdn.net/chenguang79/aggbug/4131486.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/chenguang79/232971067/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/chenguang79/232971067/art01.gif" onerror="this.style.display='none'" /></a></p>Tue, 28 Apr 2009 16:53:00 +0800chenguang79http://blog.csdn.net/chenguang79/archive/2009/04/28/4131486.aspx#Feedbackhttp://blog.csdn.net/chenguang79/archive/2009/04/28/4131486.aspxchenguang79http://blog.csdn.net/chenguang79/archive/2009/04/28/4131486.aspxhttp://blog.csdn.net/chenguang79/feed.aspxcsdn.net/chenguang79/~1125310/232971067/1125304http://blog.csdn.net/chenguang79/archive/2009/04/10/4061572.aspxhttp://blog.csdn.net/chenguang79/comments/4061572.aspx0http://blog.csdn.net/chenguang79/comments/commentRss/4061572.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4061572<br /><br /><br /><br /><br /><br />                     CommandArgument=' <%#Eval("ID") %>' OnClientClick="return window.confirm('您確定要刪除嗎?');" /> <br /><br /><img src ="http://blog.csdn.net/chenguang79/aggbug/4061572.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/chenguang79/232971068/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/chenguang79/232971068/art01.gif" onerror="this.style.display='none'" /></a></p>Fri, 10 Apr 2009 18:23:00 +0800chenguang79http://blog.csdn.net/chenguang79/archive/2009/04/10/4061572.aspx#Feedbackhttp://blog.csdn.net/chenguang79/archive/2009/04/10/4061572.aspxchenguang79http://blog.csdn.net/chenguang79/archive/2009/04/10/4061572.aspxhttp://blog.csdn.net/chenguang79/feed.aspxcsdn.net/chenguang79/~1125310/232971068/1125304http://blog.csdn.net/chenguang79/archive/2009/03/12/3984458.aspxhttp://blog.csdn.net/chenguang79/comments/3984458.aspx0http://blog.csdn.net/chenguang79/comments/commentRss/3984458.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3984458QQ在线客服的二种代码，感觉很不错<img src ="http://blog.csdn.net/chenguang79/aggbug/3984458.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/chenguang79/232971069/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/chenguang79/232971069/art01.gif" onerror="this.style.display='none'" /></a></p>Fri, 13 Mar 2009 00:04:00 +0800chenguang79http://blog.csdn.net/chenguang79/archive/2009/03/12/3984458.aspx#Feedbackhttp://blog.csdn.net/chenguang79/archive/2009/03/12/3984458.aspxchenguang79http://blog.csdn.net/chenguang79/archive/2009/03/12/3984458.aspxhttp://blog.csdn.net/chenguang79/feed.aspxcsdn.net/chenguang79/~1125310/232971069/1125304http://blog.csdn.net/chenguang79/archive/2009/03/02/3949716.aspxhttp://blog.csdn.net/chenguang79/comments/3949716.aspx0http://blog.csdn.net/chenguang79/comments/commentRss/3949716.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3949716FlyTreeView for .net控件的使用<img src ="http://blog.csdn.net/chenguang79/aggbug/3949716.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/chenguang79/232971070/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/chenguang79/232971070/art01.gif" onerror="this.style.display='none'" /></a></p>Mon, 02 Mar 2009 22:56:00 +0800chenguang79http://blog.csdn.net/chenguang79/archive/2009/03/02/3949716.aspx#Feedbackhttp://blog.csdn.net/chenguang79/archive/2009/03/02/3949716.aspxchenguang79http://blog.csdn.net/chenguang79/archive/2009/03/02/3949716.aspxhttp://blog.csdn.net/chenguang79/feed.aspxcsdn.net/chenguang79/~1125310/232971070/1125304http://blog.csdn.net/chenguang79/archive/2009/02/28/3945285.aspxhttp://blog.csdn.net/chenguang79/comments/3945285.aspx0http://blog.csdn.net/chenguang79/comments/commentRss/3945285.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3945285IE6及以上版本上的随屏幕移动而移动的代码<img src ="http://blog.csdn.net/chenguang79/aggbug/3945285.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/chenguang79/232971071/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/chenguang79/232971071/art01.gif" onerror="this.style.display='none'" /></a></p>Sat, 28 Feb 2009 23:07:00 +0800chenguang79http://blog.csdn.net/chenguang79/archive/2009/02/28/3945285.aspx#Feedbackhttp://blog.csdn.net/chenguang79/archive/2009/02/28/3945285.aspxchenguang79http://blog.csdn.net/chenguang79/archive/2009/02/28/3945285.aspxhttp://blog.csdn.net/chenguang79/feed.aspxcsdn.net/chenguang79/~1125310/232971071/1125304http://blog.csdn.net/chenguang79/archive/2009/02/25/3934706.aspxhttp://blog.csdn.net/chenguang79/comments/3934706.aspx0http://blog.csdn.net/chenguang79/comments/commentRss/3934706.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3934706asp.net读取asp的cookies乱码问题<img src ="http://blog.csdn.net/chenguang79/aggbug/3934706.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/chenguang79/232971072/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/chenguang79/232971072/art01.gif" onerror="this.style.display='none'" /></a></p>Wed, 25 Feb 2009 18:29:00 +0800chenguang79http://blog.csdn.net/chenguang79/archive/2009/02/25/3934706.aspx#Feedbackhttp://blog.csdn.net/chenguang79/archive/2009/02/25/3934706.aspxchenguang79http://blog.csdn.net/chenguang79/archive/2009/02/25/3934706.aspxhttp://blog.csdn.net/chenguang79/feed.aspxcsdn.net/chenguang79/~1125310/232971072/1125304http://blog.csdn.net/chenguang79/archive/2009/02/17/3899549.aspxhttp://blog.csdn.net/chenguang79/comments/3899549.aspx0http://blog.csdn.net/chenguang79/comments/commentRss/3899549.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3899549怎样在GridView中的DropDownList选项改变的时候获取GridView中的DataKeys.Value的二种方法<img src ="http://blog.csdn.net/chenguang79/aggbug/3899549.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/chenguang79/232971073/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/chenguang79/232971073/art01.gif" onerror="this.style.display='none'" /></a></p>Tue, 17 Feb 2009 19:45:00 +0800chenguang79http://blog.csdn.net/chenguang79/archive/2009/02/17/3899549.aspx#Feedbackhttp://blog.csdn.net/chenguang79/archive/2009/02/17/3899549.aspxchenguang79http://blog.csdn.net/chenguang79/archive/2009/02/17/3899549.aspxhttp://blog.csdn.net/chenguang79/feed.aspxcsdn.net/chenguang79/~1125310/232971073/1125304