private void GetGrouByDepositAmountList() { string date = DateTime.Now.Month.ToString(); DepositManager aDepositManager = new DepositManager(); List <MemberWithDeposit> memberWithDeposits = aDepositManager.GetMemberWithDepositAmountGroupByName(date); int sno = 1; int subTotal = 0; foreach (var deposit in memberWithDeposits) { ListViewItem item = new ListViewItem(); item.Text = sno++.ToString(); item.SubItems.Add(deposit.MemberName); item.SubItems.Add(deposit.Amount.ToString()); item.SubItems.Add((subTotal = subTotal + deposit.Amount).ToString()); depositListView.Items.Add(item); } }