private List <Warehouses> GetWarehousesList() { List <Warehouses> listWarehouses = new List <Warehouses>(); DataBaseReader dbReader = new DataBaseReader(this.sqlConnect); string command = "SELECT [Warehouses].[WarehouseID], " + "[Warehouses].[WarehouseName] FROM [Warehouses]"; dbReader.GetSqlReader(command); while (dbReader.SqlReader.Read()) { listWarehouses.Add(new Warehouses { RowNumber = dbReader.SqlReader[0].ToString(), WarehouseName = dbReader.SqlReader[1].ToString() }); } dbReader.CloseReader(); return(listWarehouses); }