private DataTable CalculateTypesPercentage() { double sum; List <double> helpListSum = new List <double>(); List <String> helpListNames = new List <String>(); DataTable result = new DataTable(); result.Columns.Add("Type", typeof(string)); result.Columns.Add("Percent", typeof(string)); foreach (InvestmentType t in SqlConnector.GetInvestmentType_All()) { List <double> temp = SqlConnector.GetInvestmentType(t.InvName); if (temp.Count > 0) { sum = temp.Sum(); helpListSum.Add(sum); helpListNames.Add(t.InvName); } } double total = helpListSum.Sum(); for (int i = 0; i < helpListSum.Count; ++i) { TypesPercentage t = new TypesPercentage() { name = helpListNames[i], percent = 100 * helpListSum[i] / total }; result.Rows.Add(t.name, t.percent.ToString("0.00")); } return(result); }