public void PopulateLists() { string CS = ConfigurationManager.ConnectionStrings["TestDB"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { ListClass lc = new ListClass(); con.Open(); listMain = lc.MainList(con); listGeneral = lc.GeneralList(con); listControl = lc.ControlList(con); listFixedAssets = lc.FixedAssetsControlList(con); listSubHead = lc.SubHeadList(con); mainProducts = lc.MainProductList(con); generalProducts = lc.GeneralProductList(con); departmentList = lc.DepartmentList(con); employeeList = lc.EmployeeList(con); customerList = lc.CustomerList(con); supplierList = lc.SupplierList(con); ownerList = lc.OwnerList(con); otherList = lc.OtherList(con); bankList = lc.BankList(con); govtList = lc.GovtList(con); yearMonthList = lc.MonthYear(con); } }