随笔分类 -  Ajax

摘要:1、新建一个分页存储过程:CREATEprocedure[dbo].[P_Pager] (@PageNumberint, @PageSizeint) asdeclare@sqlnvarchar(4000) set@sql='selecttop'+Convert(varchar,@PageSize)+'*fromT_Testwhere[type]=1andidnotin(selecttop'+Convert(varchar,(@PageNumber-1)*@PageSize)+'idfromT_Testorderbyiddesc)orderbyiddesc 阅读全文
posted @ 2012-06-29 23:04 念余温 阅读(282) 评论(0) 推荐(0)
摘要:遍历查询窗体界面的textbox为空值 foreach (System.Windows.Forms.Control control in this.Controls) { if (control is TextBox) { TextBox tx = (TextBox)control; tx.Text = string.Empty; } } 一列数的规则如下: 1、1、2、3、5、8、1... 阅读全文
posted @ 2012-05-17 15:38 念余温 阅读(424) 评论(0) 推荐(1)