01.private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
02.{
03. DataGridView dgv = (DataGridView)sender;
04. DataGridViewRow dgvr = dgv.Rows[e.RowIndex];
05.
06. string room = (string)dgvr.Cells["ColumnRoom"].Value;
07.
08. int count = (from dr in dgv.Rows.Cast<DataGridViewRow>()
09. where (string)dr.Cells["ColumnRoom"].Value == room
10. group dr by dr.Cells["ColumnRoom"].Value into g
11. select g.Sum((int)dr.Cells["ColumnUnit"].Value)).FirstOrDefault();
12.
13. MessageBox.Show(string.Format("ห้อง {0} มีแผ่นอนามัยจำนวน {1} แผ่น", room, count.ToString("#,##0")), "จำนวนแผ่นอนามัย");
14.}
งงง่ะ
