04 2009 档案

摘要:优酷 - 歌曲:http://v.youku.com/v_playlist/f2054483o1p10.html 阅读全文
posted @ 2009-04-30 13:43 boer 阅读(146) 评论(0) 推荐(0)
摘要:join语句: join语句 Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --> var query = from tblMaterialInZhiSi in objPlantDataClassesDataContext.tbl_Materia... 阅读全文
posted @ 2009-04-26 10:14 boer 阅读(406) 评论(0) 推荐(0)
摘要:Linq 增删改查例子 Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->public class WorkshopDAL { PlantDataClassesDataContext objPlantDataClasse... 阅读全文
posted @ 2009-04-20 15:49 boer 阅读(782) 评论(0) 推荐(0)
摘要:多个条件查询(相当于根据多个条件进行合并一些相同的元素,个人觉得分组统计时用到) var q = from p in db.Products group p by new { p.CategoryID, p.SupplierID } into g select new { g.Key, g }; 求最大值(按照相同的做法可以,求最小值,求和 ,求平均值... var q = from p in db.Products group p by p.CategoryID into g select new { g.Key, MaxPrice = g.Max(p => p.UnitPrice) }; 对于统计的数据进行遍历 foreach (var gp in q) { if (gp.Key == 2) { foreach 阅读全文
posted @ 2009-04-13 16:12 boer 阅读(321) 评论(0) 推荐(0)
摘要:http://book.51cto.com/art/200812/100240.htm 阅读全文
posted @ 2009-04-09 16:49 boer 阅读(129) 评论(0) 推荐(0)