Sum and Group By using LINQ

mySectorDisbursment.ForEach(delegate (SectorDisbursment sectorDisbursment) {

                        xlWorkSheet.Cells[pieSectorColumn, 10] = sectorDisbursment.SectorName;

                        xlWorkSheet.Cells[pieSectorColumn, 11] = sectorDisbursment.AmountDisd / sectorDisbursment.NetCommit;

                        pieSectorColumn++;

                    });

---

This email has been checked for viruses by Avast antivirus software. www.avast.com

Winform Textbox allow decimal number upto 2 decimal places C#

Use below code in the Keypress Event

private void txtPaidCcy_KeyPress(object sender, KeyPressEventArgs e)

        {

            if (char.IsNumber(e.KeyChar) || e.KeyChar == '.')

            {

                int len = txtPaidCcy.Text.Length;

                bool hasDot = txtPaidCcy.Text.Contains(".");

                if (hasDot && e.KeyChar == '.')

                {

                    e.Handled = true;

                }

                if (len >= 20 && !hasDot)

                {

                    if (char.IsNumber(e.KeyChar))

                    {

                        e.Handled = true;

                    }

                }

                if (Regex.IsMatch(txtPaidCcy.Text, "^\\d*\\.\\d{2}$")) e.Handled = true;

            }

            else e.Handled = e.KeyChar != (char)Keys.Back;

        }

Virus-free. www.avast.com