/// <summary> /// The PopulateComboBoxes /// </summary> internal void PopulateAddTabComboBoxes() { DataTable table = new DataBuilder(Source.PRC).Table; string[] query = table.AsEnumerable().Select(p => p.Field <string>("SubProject")).Distinct().ToArray(); foreach (string row in query) { AddSub.Items.Add(row); } string[] year = table.AsEnumerable().Select(p => p.Field <string>("BFY")).Distinct().ToArray(); foreach (string s in year) { AddYear.Items.Add(s); } string[] code = table.AsEnumerable().Select(p => p.Field <string>("Code")).Distinct().ToArray(); foreach (string c in code) { AddCode.Items.Add(c); } string[] fund = table.AsEnumerable().Select(p => p.Field <string>("FundCode")).Distinct().ToArray(); foreach (string f in fund) { AddFund.Items.Add(f); } string[] rc = table.AsEnumerable().Select(p => p.Field <string>("RC")).Distinct().ToArray(); foreach (string r in rc) { AddRc.Items.Add(r); } string[] bl = table.AsEnumerable().Select(p => p.Field <string>("BudgetLevel")).Distinct().ToArray(); foreach (string r in bl) { AddLevel.Items.Add(r); } string[] org = table.AsEnumerable().Select(p => p.Field <string>("Org")).Distinct().ToArray(); foreach (string oo in org) { AddOrg.Items.Add(oo); } string[] ah = table.AsEnumerable().Select(p => p.Field <string>("AH")).Distinct().ToArray(); foreach (string a in ah) { AddAh.Items.Add(a); } string[] boc = table.AsEnumerable().Select(p => p.Field <string>("BOC")).Distinct().ToArray(); foreach (string b in boc) { AddBoc.Items.Add(b); } }