05 2011 档案
摘要:1.分页方案一:(利用Not In和SELECT TOP分页)SELECT TOP 页大小 * FROM 表名 WHERE(id NOT IN (SELECT TOP 页大小*页数id FROM 表名 ORDERBY id))ORDERBY id例:SELECT TOP10 * FROM TestTable WHERE (ID NOT IN (SELECT TOP20 id FROM TestTable ORDER BY id))ORDERBY ID分页方案一:(利用Not In和SELECT TOP分页) 效率第二,需要拼接SQL语句2.分页方案二:(利用ID大于多少和SELECT TOP分
阅读全文
摘要:public static void MakeSmallImg(System.IO.Stream fromFileStream, string fileSaveUrl, System.Double templateWidth, System.Double templateHeight) { //从文件取得图片对象,并使用流中嵌入的颜色管理信息 System.Drawing.Image myImage = System.Drawing.Image.FromStream(fromFileStream, true); //缩略图宽、高 System.Double newWidth = myImage
阅读全文