private static void LoadTables(Server server, DataTable openTables, sqlController sqc) { foreach (DataRow r in openTables.Rows) { server.EnterExistingTable((int)r["TableNumber"], (int)r["NumGuests"]); Table table = server.getTable((int)r["TableNumber"]); table.ID = (int)r["ID"]; int billsCount = sqc.getBillCount(table); while (billsCount > 0) { table.AddNewList(); billsCount -= 1; } DataTable billDT = sqc.getBills(table); int count = billDT.Rows.Count; List <Bill> bills = table.GetBills(); foreach (Bill bill in bills) { var query = from mRow in billDT.AsEnumerable() where mRow.Field <int>("CheckNum") == bill.CheckNum select mRow; DataView njview = query.AsDataView(); bill.ID = Int32.Parse(njview[0]["ID"].ToString()); bill.Payment = Decimal.Parse(njview[0]["Payment"].ToString()); } } }