09 2012 档案

sql存储过程转列例子
摘要：ALTER procedure PropertGetPivotasBegin DECLARE @ColumnNames VARCHAR(3000) SET @ColumnNames='' SELECT @ColumnNames = @ColumnNames + '[' + [getDeptID] + '],' FROM ( SELECT DISTINCT getDeptID FROM [pArticleGet] group by [getDeptID] )t SET @Column... 阅读全文
posted @ 2012-09-27 14:36 卢青松 阅读(203) 评论(0) 推荐(0) 编辑
C#禁止重复提交
摘要：C#禁止重复提交 1:连续2次提交 Button1.Attributes.Add("onclick", "this.value='正在提交中，请等待……';this.disabled=true;" + this.GetPostBackEventReference(Button1));2:刷新提交： Response.Write(" <script language=javascript> alert( '采购成功 ');window.location.href=window.location.href 阅读全文
posted @ 2012-09-20 14:44 卢青松 阅读(3683) 评论(0) 推荐(0) 编辑