摘要:if (applicationInstance is ) { IHttpAsyncHandler handler2 = (IHttpAsyncHandler) applicationInstance; context.AsyncAppHandler = handler2; handle... 阅读全文
vs 快捷键
2009-12-08 10:40 by 蜡笔小旧, 167 阅读, 0 推荐, 收藏,
摘要:Ctrl + Shift + W (网上说是Ctrl + W,试了,不能用): 选中但前光标所在单词; 提供外部使用集合变量,尽量使用接口类型集合:如IList,ICollection,IEnumerable 阅读全文
fun_search.sql
2009-11-28 21:50 by 蜡笔小旧, 179 阅读, 0 推荐, 收藏,
摘要:SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER proc Full_Search(@string varchar(50)) as begin declare @tbname varchar(50) declare tbroy cursor for select name from sysobjects where xtype= 'u '... 阅读全文
IIF
2009-11-13 09:06 by 蜡笔小旧, 523 阅读, 0 推荐, 收藏,
摘要:project_Details_Group =Sum(CDec(Fields!PlanAmount.Value),"project_Details_Group",Recursive) =IIf(Sum(CDec(Fields!PlanAmount.Value),"plan_Details_Group",Recursive) <> 0 , Roun... 阅读全文
javascript css selector engine-mini
2009-09-21 23:38 by 蜡笔小旧, 658 阅读, 0 推荐, 收藏,
摘要:Javascript类库圈最近似乎活跃。类库、插件层出不穷。今天看到一则selector engine的新闻。介绍一款新的seletor engine - mini(好像是车吧,名如其J,很小很强大)。其他3款车(1)Sizzle(这个知道,jQuery中的selector),(2)Peppy(从没听过)(3)Sly(还是没听过)。4者数据分析上来看,mini快很多,也小得多。一起来看看他支持一些... 阅读全文
mini
2009-09-21 16:23 by 蜡笔小旧, 251 阅读, 0 推荐, 收藏,
摘要:var mini = (function() { var snack = / /, exprClassName = / /, exprId = / /, exprNodeName = / /, na = [null, null]; function _find(selector, context) { } function realArray() { } function filterParent... 阅读全文
SQL JOINS
2009-09-18 18:45 by 蜡笔小旧, 546 阅读, 0 推荐, 收藏,
摘要:URL:http://www.codeproject.com/KB/database/Visual_SQL_Joins.aspx 阅读全文
linq procedure int <Return Type="System.Int32" />
2009-09-10 16:26 by 蜡笔小旧, 250 阅读, 0 推荐, 收藏,
摘要:上次写的DBML存储过程返回值虽然可以返回非Int的值,但是有个小毛病。重新拖表或者存储过程,返回值又变成了<Return Type="System.Int32" /> <Table Name="dbo.Contract" Member="Contracts"> <Type Name="Contract" Id="ID1"> <Column Name="... 阅读全文
Sql Paging
2009-08-31 19:10 by 蜡笔小旧, 248 阅读, 0 推荐, 收藏,
摘要:以NorthWind为例: (1)两次排序CREATE PROC dbo.GetCategories@PageSize int,@PageNum intASDECLARE @Ignore intDECLARE @LastID intIF @PageNum > 1 BEGIN SET @Ignore = @PageSize * ( @PageNum -1 ) SET ROWCOUNT @I... 阅读全文
DBML存储过程返回值
2009-08-31 15:45 by 蜡笔小旧, 357 阅读, 1 推荐, 收藏,
摘要: [Function(Name="dbo.Search")] public int Search([Parameter(Name="KeyWord", DbType="NVarChar(100)")] string keyWord, [Parameter(Name="PageSize", DbTyp... 阅读全文
浙公网安备 33010602011771号