DJ메탈짱™의 Free Style

// 2011/07/13 - LINQ query (SUM)var tSum =from p in db.TBSimulation // from절ywhere p.USERID == this.hdUSERID.Text && p.GROUPID == "A" // where절yselect p.RESULT; // select절y // Total Profit this.lblTPROFIT.Text = tSum.Sum().ToString();

// LINQ query (SUM) var tSum = from p in db.TBSimulation // from절 where p.USERID == "" // where절 group p by new { p.GROUPID,p.USERID } into grouping // group by select new // sum column { grouping.Key, Totalprice = grouping.Sum(p => p.RESULT) }; // sum값 바인딩 foreach (var grp in tSum) { this.lblTPROFIT.Text = grp.Totalprice.ToString(); }

Textbox 배경색 code-behind에서 변경하는 방법 this.txtUSERID.BackColor = Color.FromArgb(240, 240, 240); this.txtUSERID.BackColor = ColorTranslator.FromHtml("#F0F0F0");