代码改变世界

随笔档案-2011年05月

SQL CURSOR 同时选择多列值

2011-05-23 20:04 by calm_水手, 441 阅读, 收藏,
摘要： DECLARE @ofId int,@Amount decimal(18,2),@OrderID varchar(20)DECLARE curOfId CURSOR FOR SELECT lotOfId,lotWinMoney,t1.lotOrderIDFROM IP_OrderLottery AS t1 INNER JOIN View_OfficeInfo_CityCountry AS t2ON t1.lotOfId=t2.ofIdWHERE t1.lotIsUpdateReward=0 OPEN curOfId FETCH NEXT FROM curOfId INTO @ofId,@Amo 阅读全文

XML文件操作小结

2011-05-14 16:45 by calm_水手, 269 阅读, 收藏,
摘要： 一、简单介绍using System.Xml;//初始化一个xml实例XmlDocument xml=new XmlDocument();//导入指定xml文件xml.Load(path);xml.Load(HttpContext.Current.Server.MapPath("~/file/bookstore.xml"));//指定一个节点XmlNode root=xml.SelectSingleNode("/root");//获取节点下所有直接子节点XmlNodeList childlist=root.ChildNodes;//判断该节点下是否有子节 阅读全文

c# 32位16位MD5加密

2011-05-01 17:31 by calm_水手, 1164 阅读, 收藏,
摘要： 以下为MD5算法用c#的实现//MD5.cs//MD5 16-bit,32-bits algorithm implemented in C#using System;using System.Text;namespace Encrypter{/// <summary>/// Summary description for MD5./// </summary>public class MD5{ const int BITS_TO_A_BYTE = 8; const int BYTES_TO_A_WORD = 4; const int BITS_TO_A_WORD = 32 阅读全文

彩票双色球 选号 组合[温习一下排列组合的知识吧]

2011-05-01 09:39 by calm_水手, 1612 阅读, 收藏,
摘要： 排列组合公式=900) window.open('http://dl.qzzn.com/pic.jsp?url=%2Fatt%2FDay_071105%2F131_390516_58645f8f2dd85d8.jpg&name=%CE%B4%B1%EA%CC%E2-1+%BF%BD%B1%B4.jpg');" border=0 src="http://dl.qzzn.com/pic.jsp?url=%2Fatt%2FDay_071105%2F131_390516_58645f8f2dd85d8.jpg&name=%CE%B4%B1%EA%CC 阅读全文