2012年3月7日
[Visual C#] 异步HttpListener 完全并发处理HTTP请求示例
摘要： 1usingSystem;2usingSystem.Collections.Generic;3usingSystem.Linq;4usingSystem.Text;5usingSystem.Net;6usingSystem.Net.Sockets;7usingDevSDK.Net.Sockets;8usingSystem.IO;910namespaceConsoleApplication111{12classProgram13{14staticHttpListenersSocket=null;1516staticvoidMain(string[]args)17{18sSocket=newHtt 阅读全文
posted @ 2012-03-07 03:31 star丶清影 阅读(14266) 评论(7) 推荐(0)
[SQL Server] RANK (Transact-SQL) 返回结果集的分区内每行的排名
摘要： 语法：1RANK()OVER([<partition_by_clause>]<order_by_clause>)示例：1Select*FromElectricBP2WhereRowIDin(SelectRowIDFrom3(4SelectRowID,RANK()Over(PARTITIONBYInsureNoOrderByOperateTimeDesc)As[RANK]FromElectricBP5)TWhere[RANK]=1) 阅读全文
posted @ 2012-03-07 03:26 star丶清影 阅读(254) 评论(0) 推荐(0)
[SQL Server] SQL Server 2005/2008 获取数据表全部信息
摘要： 1SELECT*FROM(2SELECTTableName=D.NAME,TableExplain=CASEWHENA.COLORDER=1THENISNULL(F.VALUE,'')ELSE''END,3ColumnName=A.NAME,IsIdentity=COLUMNPROPERTY(A.ID,A.NAME,'ISIDENTITY'),4IsPrimaryKey=CASEWHENEXISTS(Select1FROMSYSOBJECTSWhereXTYPE='PK'ANDPARENT_OBJ=A.IDANDNAMEIN(5S 阅读全文
posted @ 2012-03-07 03:08 star丶清影 阅读(275) 评论(0) 推荐(0)
[Visual C#] DataTable Compute方法计算表达式
摘要： 1publicstaticobjectEval(stringAExpression)2{3try4{5returnnewSystem.Data.DataTable().Compute(AExpression,"");6}7catch8{9returnnull;10}11}Example:string text = Eval("(1.5+2.5)*2/4").ToString();MessageBox.Show(text); 阅读全文
posted @ 2012-03-07 03:06 star丶清影 阅读(554) 评论(0) 推荐(0)